<?php
    $host_name = "localhost:3307";
    $database = "weather";
    $user_name = "weather_update";
    $password = "lolpassword";


    $connect = mysqli_connect($host_name, $user_name, $password, $database);

    if(mysqli_connect_errno()){
        echo "La connexion au serveur MySQL a échoué: " .mysqli_connect_error() . "<br>";
    }
    else{
        echo 'Connexion au serveur MySQL établie avec succès.<br>';
        //mysql_select_db("weather");
        $read = mysql_query("SELECT * FROM metrics");
        if (!$result) {
            die("Requête invalide : " . mysql_error() . "<br>");
        }
        else{
            while ($donnees = mysql_fetch_array($read)){
                echo $donnees['timestamp'] . " : " . $donnees['temperature'] ."<br>";
            }
        }

        mysql_free_result($result);

    }
?>