Advertisement
Guest User

Untitled

a guest
Dec 6th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 1.04 KB | None | 0 0
  1. <html>
  2.  
  3. <head>
  4.     <meta charset="utf-8">
  5.     <title></title>
  6. </head>
  7.  
  8. <body>
  9.     <table id="students">
  10.         <?php
  11.            $servername = "127.0.0.1";
  12.            $username = "test";
  13.            $password = "123";
  14.            $dbname = "students";
  15.            
  16.            $conn = new mysqli($servername, $username, $password, $dbname);
  17.            
  18.            if ($conn->connect_error) {
  19.                 die("Неудалось подключиться: " . $conn->connect_error);
  20.             }
  21.        
  22.             $q = mysqli_query($conn, "SELECT * FROM studentsDB");
  23.  
  24.             if ($q) {
  25.                 echo "<tr><th>Факультет</th><th>Группа</th><th>Студент</th></tr>";
  26.                 while($r = mysqli_fetch_assoc($q)) {
  27.                     echo "<tr><td>" . $r[""] . "</td>" . "</tr>";
  28.                 }
  29.             } else {
  30.                 echo "Ошибка: " . $sql . "<br>" . mysqli_error($conn);
  31.             }
  32.  
  33.             mysqli_close($conn);
  34.         ?>
  35.     </table>
  36. </body>
  37.  
  38. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement