Advertisement
Makerino

PHP Ausgabe

Jul 28th, 2019
187
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.26 KB | None | 0 0
  1. <?php
  2.    /* Verbindung aufnehmen */
  3.    $con = mysqli_connect("localhost","NUTERNAME_PHPMYADMIN","PASSWORT_PHPMYADMIN");
  4.  
  5.    /* Datenbank auswählen */
  6.    mysqli_select_db($con, "wohnzimmer");
  7.  
  8.    /* SQL-Abfrage ausführen */
  9.    $res = mysqli_query($con, "select * from sensorwerte ORDER BY ID DESC LIMIT 1");
  10.  
  11.  
  12.  
  13.    /* Datensätze aus Ergebnis ermitteln, */
  14.    /* in Array speichern und ausgeben    */
  15.    
  16.    echo "<table border=1>";
  17.                  
  18.                echo "<tr>";
  19.                     echo "<td>" . ID . "</td>";
  20.                echo "<td>" . Zeit . "</td>";
  21.                echo "<td>" . Temperatur . "</td>";
  22.                echo "<td>" . Luftfeuchte . "</td>";
  23.                echo "<td>" . Druck . "</td>";
  24.                echo "</tr>";
  25.    
  26.          
  27.    while ($dsatz = mysqli_fetch_assoc($res))    
  28.    {  
  29.  
  30.                echo "<tr>";
  31.                     echo "<td>" . $dsatz["ID"] . "</td>";
  32.                echo "<td>" . $dsatz["Zeit"] . "</td>";
  33.                echo "<td>" . $dsatz["Temperatur"] . "</td>";
  34.                echo "<td>" . $dsatz["Luftfeuchte"] . "</td>";
  35.                echo "<td>" . $dsatz["Druck"] . "</td>";
  36.                echo "</tr>";
  37.    }
  38.    
  39.    echo "</tr>";
  40.    echo "</table>";
  41.  
  42.    /* Verbindung schließen */
  43.    mysqli_close($con);
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement