#Arduino to mysql database server from scratch code#

?> Code Explanation (led_update.php) You Tube This script establishes the connection with server. We have included another php script (dbIoT.php) in the above script. Though, for this particular example we can conveniently place this anywhere in the code. The above block of code to be inserted after the closing head tag (). In this project the desired state is On for led_status=1 and desired state is Off if led_status=2. In this example we are using one one LED but for generalized projects we use led_id for a specific LED. When we submit a form by pressing either of two buttons created (for On and Off), the status of LED is updated. Using isset() with $_POST check whether we have submitted a post request or not and returns true if post request is submitted. The isset( variable) returns true if the variable is not NULL and is set (defined) or exists, otherwise it returns false. The important php function used in the script is isset( variable) function. To begin with, we will go for first option but switch to other options for SSP using jQuery/AJAX. One, insert the script in the same HTML or two, to create a separate file to process the server side processing. Now we can write php script to connect to server and process the request submitted through the HTML form.

Use the following code to generate the page We will follow the steps the steps explained in home -page (click to view in new Tab) tutorial to develop the following web page. Create a Web Portal (Web Page) to Control LED We have to use separate table if we wish to record the history of updates which will enable us to analysis the on-off states of the appliance.įollowing short video will take you through the steps of creating table using phpMyAdmin GUI of cPanel/XAMPP/WAMP.

#Arduino to mysql database server from scratch update#

Using data as dataType will record only date of update but using timestamp will record the time as well as date.

submit_time can be used to record the last updated time.

You have to change the codes (led_update.php and controlLedWeb.ino) accordingly. You can have it of your choice in your project. Presently, we use 1 for ON status and 2 for OFF status.

led_status stores a code for ON and OFF the LED/Appliance.

We will use it later when we will give access to User through a front end to add more LED/Appliance/Devices of similar kind.

led_name is the user defined name of LED/Appliance.

led_id of INT dataType, auto increment (AI) id and set as Primary Key.

For beginners, it is recommended to use GUI for creating table. You can use SQL query, GUI or php script to create this table. Create Table led with the structure as below.