O'Reilly logo

Internet of Things Programming with JavaScript by Ruben Oliva Ramos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data queries from the database

It's important to have data recorded and to make some queries to have the data show in the web page.

Software for the scripts

Here we have the scripts that we used to show the data in the page:

You can now either copy the code inside a file called query1.php, or just get the complete code from the folder for this project:

<!DOCTYPE html> <html> <body> <h1>Clik on the buttons to get Data from MySQL</h1> <form action="query1.php" method="get"> <input type="submit" value="Get all Data"> </form> </br> <form action="query2.php" method="get"> <input type="submit"value="Humidity <= 15"> </form> </br> <form action="query3.php" method="get"> <input type="submit" value="Temperature <=25"> </form> </br> <?php $con=mysql_connect("localhost","root","ruben","arduinobd"); ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required