Prikazi cijelu temu 15.12.2018 23:57
zxz Van mreze
Administrator
Registrovan od:03.02.2009
Lokacija:Tuzla


Predmet:MySQli konekcija
PreuzmiIzvorni kôd (HTML):
  1. <!DOCTYPE html>
  2. table, th, td {
  3.     border: 1px solid black;
  4. }
  5. </head>
  6.  
  7. <?php
  8. $servername = "localhost";
  9. $username = "username";
  10. $password = "password";
  11. $dbname = "myDB";
  12.  
  13. // Create connection
  14. $conn = new mysqli($servername, $username, $password, $dbname);
  15. // Check connection
  16. if ($conn->connect_error) {
  17.     die("Connection failed: " . $conn->connect_error);
  18. }
  19.  
  20. $sql = "SELECT id, firstname, lastname FROM MyGuests";
  21. $result = $conn->query($sql);
  22.  
  23. if ($result->num_rows > 0) {
  24.     echo "<table><tr><th>ID</th><th>Name</th></tr>";
  25.     // output data of each row
  26.     while($row = $result->fetch_assoc()) {
  27.         echo "<tr><td>" . $row["id"]. "</td><td>" . $row["firstname"]. " " . $row["lastname"]. "</td></tr>";
  28.     }
  29.     echo "</table>";
  30. } else {
  31.     echo "0 results";
  32. }
  33.  
  34. $conn->close();
  35. ?>
  36.  
  37. </body>
  38. </html>

Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.