connect_error) { die("Connection failure:" . $conn->connect_error); } // Creates a new DateTime object representing the current date and time in a specified time zone. $currentDate = new DateTime("now", new DateTimeZone('Europe/Paris')); $dateOfTheDay = $currentDate->format('Y-m-d'); $hourOfNow = $currentDate->format('H:i'); // SQL query to retrieve the list of different sensors. $sql = "SELECT DISTINCT Sensor FROM ACTIVITY"; $result = $conn->query($sql); // If there are results, then generate the dropdown list. if ($result->num_rows > 0) { echo '
'; } else { echo "

No sensor found.

"; } // Terminates the connection to the database server. $conn->close(); ?>