Advertisement
Guest User

Untitled

a guest
Sep 26th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "week05";
  6.  
  7. //--------------------- Create connection ---------------------
  8. $conn = new mysqli($servername, $username, $password, $dbname);
  9. //---------------------- Check connection ---------------------
  10. if ($conn->connect_error) {
  11. die("Connection failed: " . $conn->connect_error);
  12. }
  13. //--------------------------- SELECT --------------------------
  14. $sql = "SELECT * FROM description";
  15. $result = mysqli_query($conn,$sql);
  16.  
  17. if($result) {
  18. $no=0;
  19. while ($row=mysqli_fetch_assoc($result))
  20. {
  21. $no++;
  22. //-------------------------------------------------------------
  23.  
  24. ?>
  25. <tr>
  26. <td><?php echo $no; ?></td>
  27. <td><?php echo $row["studentid"]; ?></td>
  28. <td><?php echo $row["fname"]; ?></td>
  29. <td><?php echo $row["lname"]; ?></td>
  30. <td><a class='btn btn-primary' href="week04_3.php?id=<?php echo $row["studentid"]; ?>" role='button'><span class="glyphicon glyphicon-edit"></span></a>
  31. <a class='btn btn-primary' href="delete.php?id=<?php echo $row["studentid"]; ?>" role='button'><span class='glyphicon glyphicon-trash'></span></a>
  32. </td>
  33. </tr>
  34.  
  35. <?php
  36. }
  37. }
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement