Advertisement
sdee3

PVA - Povez. na MySQL tabelu

Dec 7th, 2016
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.71 KB | None | 0 0
  1. <?php
  2.  
  3.     $serverName = "localhost";
  4.     $user = "root";
  5.     $pass = "";
  6.     $dbName = "baza2";
  7.  
  8.     $conn = mysqli_connect($serverName,$user,$pass,$dbName);
  9.  
  10.     if(!$conn){
  11.         die("Neuspesna konekcija.");
  12.     }else{
  13.         echo "Uspesno povez. sa bazom <br>";
  14.     }
  15.  
  16.     $sql = "SELECT * FROM student";
  17.  
  18.     $rezultat = mysqli_query($conn, $sql);
  19.  
  20.     if(mysqli_num_rows($rezultat) > 0){
  21.         while($row = mysqli_fetch_assoc($rezultat)){
  22.             echo "Fakultet: " . $row["fakultet"] . "\t" . "indeks: " . $row["indeks"]. " - Ime i prezime: " . $row["ime"]. " " . $row["prezime"]. "<br>";
  23.         }
  24.     }else{
  25.         echo "Upit je vratio 0 podataka.";
  26.     }
  27.  
  28.     mysqli_close($conn);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement