Guest User

Untitled

a guest
Mar 29th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.21 KB | None | 0 0
  1. <?php
  2. if(isset($_GET['delete_id'])) {
  3. $id=$_GET['delete_id'];
  4. $queryUserDel= "DELETE FROM $table WHERE id=$id;"
  5. $mysqlqueryUserDel = mysqli_query($link, $queryUserDel);
  6.  
  7. }
  8.  
  9. ?>
  10. <!DOCTYPE html>
  11. <html lang="en">
  12. <head>
  13. <meta charset="UTF-8">
  14. <title>DB</title>
  15. <style>
  16. table, tr, th, td {
  17. border: 1px solid green;
  18. border-collapse: collapse;
  19. }
  20. </style>
  21. </head>
  22. <body>
  23.  
  24. <table>
  25. <tr>
  26. <th>id</th>
  27. <th>name</th>
  28. <th>age</th>
  29. <th>salary</th>
  30. </tr>
  31. <?php
  32.  
  33. $host = 'localhost';
  34. $user = 'root';
  35. $pass = '123QWErty';
  36. $db_name ='test_db' ;
  37. $table = '`people`';
  38.  
  39. $link = mysqli_connect($host, $user, $pass, $db_name) or die (mysqli_error($link));
  40. mysqli_set_charset($connect, 'utf8');
  41.  
  42. $query = " SELECT * FROM $table";
  43.  
  44. $mysqlquery = mysqli_query($link, $query);
  45.  
  46.  
  47.  
  48. while ($result = mysqli_fetch_array($mysqlquery, MYSQLI_ASSOC)) {
  49.  
  50.  
  51. echo "<tr><td>{$result['id']}</td><td>{$result['name']}</td><td>{$result['age']}</td><td>{$result['salary']}</td><td><a href="?delete_id={$result['id']}">Удалить</a></td></tr>";
  52.  
  53. }
  54.  
  55. ?>
  56. </table>
  57.  
  58. </body>
  59.  
  60. </html>
Add Comment
Please, Sign In to add comment