Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. <form method="POST" >
  2. <table border="1">
  3. <tr>
  4. <th>Student Name</th>
  5. <th>Matric Number</th>
  6. <th>IC Number</th>
  7. <th></th>
  8. <th></th>
  9. </tr>
  10. <?php
  11. $link=mysqli_connect("localhost","root","") or die(mysqli_error());
  12. mysqli_select_db($link,"myDataBase") or die(mysqli_error());
  13. $query="Select * From student" or die(mysqli_error());
  14. $result=mysqli_query($link,$query);
  15.  
  16. if($result->num_rows > 0) {
  17. while($row = $result->fetch_assoc()) {
  18. echo "<tr><td>".$row["name"]."</td><td>".$row["matric"]."</td><td>".$row["ic"]."</td>
  19. <td><input type=button value=Update></td><td><input type=submit value=Delete name=delete ><input type=hidden name=id value=".$row["id"]." ></td></tr>";
  20. }
  21. }else{
  22. die("0 results");
  23. }
  24. if (isset($_POST['delete'])){
  25. echo $did=$_POST['id'];
  26. $query="Delete From student where id='$did'";
  27. $result=mysqli_query($link,$query);
  28. }
  29. ?>
  30. </table>
  31. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement