= (NOW() - INTERVAL $hours HOUR) order by dateandtime desc"; //NOTE: If you want to show all entries from current date in web page uncomment line below by removing // //$sql="select * from temperaturedata where date(dateandtime) = curdate();"; // set query to variable $temperatures = mysqli_query($connectdb,$sql); // create content to web page ?>
Date | Sensor | Temperature | Humidity |
---|---|---|---|
".$temperature['dateandtime']." | "; echo "".$temperature['sensor']." | "; echo "".$temperature['temperature']." | "; echo "".$temperature['humidity']." | "; echo "