Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_GET['delete_id'])) {
- $id=$_GET['delete_id'];
- $queryUserDel= "DELETE FROM $table WHERE id=$id;"
- $mysqlqueryUserDel = mysqli_query($link, $queryUserDel);
- }
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <title>DB</title>
- <style>
- table, tr, th, td {
- border: 1px solid green;
- border-collapse: collapse;
- }
- </style>
- </head>
- <body>
- <table>
- <tr>
- <th>id</th>
- <th>name</th>
- <th>age</th>
- <th>salary</th>
- </tr>
- <?php
- $host = 'localhost';
- $user = 'root';
- $pass = '123QWErty';
- $db_name ='test_db' ;
- $table = '`people`';
- $link = mysqli_connect($host, $user, $pass, $db_name) or die (mysqli_error($link));
- mysqli_set_charset($connect, 'utf8');
- $query = " SELECT * FROM $table";
- $mysqlquery = mysqli_query($link, $query);
- while ($result = mysqli_fetch_array($mysqlquery, MYSQLI_ASSOC)) {
- 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>";
- }
- ?>
- </table>
- </body>
- </html>
Add Comment
Please, Sign In to add comment