Jure199

Check the table

May 26th, 2016
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. <?php
  2.     $servername = "localhost";
  3.     $username = "YUN";
  4.     $password = "xxx";
  5.     $dbname = "TestnaBaza";
  6.    
  7.     // naredi povezavo
  8.     $conn = mysqli_connect($servername, $username, $password, $dbname);
  9.     //preveri povezavo
  10.     if (!$conn){
  11.         die ("Povezava ni uspela" .mysqli_connect_error());
  12.     }
  13.    
  14.     $sql = "SELECT id, temperatura, datum FROM YunPodatki";
  15.     $result = mysqli_query($conn, $sql);
  16.    
  17.     if (mysqli_num_rows($result) > 0) {
  18.         // izhodni podatki vsake vrstice
  19.         while ($row = mysqli_fetch_assoc($result)){
  20.             echo "id".$row["id"]. "Temperatura" . $row["temperatura"] . "Datum" . $row["datum"] . "<br>";
  21.         }
  22.     } else {
  23.         echo "0 rezultatov";
  24.        
  25.     }
  26.    
  27.     mysqli_close($conn);
  28.     ?>
Add Comment
Please, Sign In to add comment