How to delete the selected php line mysql

Question

There is such a table output from MySql. How to set the delete line when you click the delete link

while($rows = $result->fetch_assoc())[1] { print '<tr> <td>'.$rows ['first_name'].'</td> <td>'.$rows ['last_name'].'</td> <td>'.$rows ['gender'].'</td> <td>'.$rows ['nationality'].'</td> <td>'.$rows ['countries'].'</td> <td>'.$rows ['adress'].'</td> <td>'.$rows ['passport'].'</td> <td>'.$rows ['phone'].'</td> <td>'.$rows ['date_birsd'].'</td> <td><a href="del_sportsmans.php">Удалить</a></td> </tr>'; }

[ enter image description here ]

Andrei Katalkin Andrei Katalkin 743 3 7 · Answer 1 · 2016-05-05T12:23:31

First, you should find out which field in the table is a unique identifier (id).

Next, update the deletion link by adding this identifier there (substitute the required field instead of 'id'):

 '<td><a href="del_sportsmans.php?id='.$rows['id'].'">Удалить</a></td>'

The del_sportsmans.php file logic:

Get the id:

 $id = $_REQUEST['id'];

Make a removal request:

 DELETE FROM <имя таблицы> WHERE <идентификатор>=$id

How to delete the selected php line mysql

1 answer 1

More articles: