Final Project: Make-through

now we need to have a virtual server and database client installed to start send and store data

after some times in search, we found WAMP it's a windows application that has apache server and mysqlserver and phpmyadmin all required package to make your own server

wamp installation is very easy as any standard setup (also there's a silent installation version ... just double click)

Trial #2 (Successful): Creating Database Schematic

• Step1: we Created Table Called BME or any other name you prefer

• Step 2 : we need 6 columns (ID,temp,hum,pressure,altitude,timestamp)

ID Act as refernce key for each record it should be unique and auto increment

timestamp also should be auto to prevent any lag or time shifting and to decrease received data size we can make it default time from server

any other column data type should be float as we recived

• Step1: downloading and importing required library

• Step2: as any basic input we need to read data and store it in variables to print it on a serial monitor

Phase #2 (Successful): Creating API over PHP

Here's the problem there's no library to send data directly as they are different platfrom

the solution is to create PHP API to receive data from HTTP request that nodemcu can handle and insert the received data to MySQL database

• Step1: connecting 3.7V LIPO Battery with battery holder to charging module

we found two problems

1. the power consumption for node mcu is less than 0.07 ma which less than what charging module sence and make the module turned off

2. it only take about 18 hours to totally discharge battery whish is not long enough

Trial#2 (semi-successful): Adding Solar Cell to run forever

• Step1 : adding 6V/4.5 Solar Panel To charge Battery

the problem here is charger have limit input to 5.5v max and solar cell output up-to 7 v in extreme light so we put zener daiode as voltage limitation to 5 v

• Step2: connecting battery direct to vin pin instead of charging module to prevent under sensing limit for charging module

Problem 2 : we still can only run battery for about 18 hours

Trial#3 (successful): Sleep Mode

• Step1: first we need to import external library for nodemcu as it's not built-in in Autodesk eagle

• Step2:adding all part and start connecting nets

• Step3:Creating board layout and routing air wires

Trial#1 (unsuccessful): First Fail Fabrication

the milling procces is running perfect the problem here is about node mcu footprint the pads didn't fit so I tried to edit foot print

Trial#2 (successful):

after editing the footprint trying to re-fabricate pcb again and every thing goes fine

not we will solder component board

• Step1: creating a basic table to read last 100 row from database

• Step2: Style the table to be responsive in any mobile tablet or any screen

Phase#2 (successful):Creating WebBase View Chart

the second section is to visualize the data in graph to make easier to read

used bootstrap temnplete as responsive design

we used Cavischart js Module to view data from database

• Step1: Creating Basic Box MDF 3mm with T-joint

• Step2: Creating opens to fit sensors