Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";
- $username = "YUN";
- $password = "xxx";
- $dbname = "TestnaBaza";
- // naredi povezavo
- $conn = mysqli_connect($servername, $username, $password, $dbname);
- //preveri povezavo
- if (!$conn){
- die ("Povezava ni uspela" .mysqli_connect_error());
- }
- $sql = "SELECT id, temperatura, datum FROM YunPodatki";
- $result = mysqli_query($conn, $sql);
- if (mysqli_num_rows($result) > 0) {
- // izhodni podatki vsake vrstice
- while ($row = mysqli_fetch_assoc($result)){
- echo "id".$row["id"]. "Temperatura" . $row["temperatura"] . "Datum" . $row["datum"] . "<br>";
- }
- } else {
- echo "0 rezultatov";
- }
- mysqli_close($conn);
- ?>
Add Comment
Please, Sign In to add comment