Displaying a table with delete links

[TaSMaNiaC]

Hey guys... I'm trying to use PHP to draw up a table from a mysql database and display it in the browser... I've managed to do this, no problem but what I would like to have is an additional column in the table with a delete link for each entry. That way upon clicking on it, it would remove that entry from the database and thus the table. I'm sure this is possible somehow but I just can't figure it out.

Can someone possibly help me out or point me in the right direction?

Thanks in advance!

[djjjozsi]

First, your table needed to have a primary key, to identify the rows.
Name it for example: table_id

Your printing the values with a while cycle,
add a table cell, with a link:

print "<a href=\"index.php?todo=del&table_id=". $row['table_id']."\">Del</a>";

Then in your program, lets check if the $GET['todo'] is del and $GET['table_id'] has a value. IF yes, you can now create an SQL DELETE command to delete the record with its primary key number. Its suggested to make a confirmation page (on client or server side).

[Weedpacket]

Using links for this is poor design: GET requests such as those generated by links should not delete parts of the site (see RFC2616 on the HTTP protocol for details).
Also, check out http://thedailywtf.com/Articles/The_Spider_of_Doom.aspx

[TaSMaNiaC]

Hehe thanks Weedpacket, I never thought of that happening! It's kinda funny in an unfortunate way! Thankfully this PHP app I am building will only be used on an intranet so not exposed to the outside world. That being said I have decided to abandon this method as I have created a dropdown box that pulls all the values from the table and has a delete button next to it.

Thanks for the info!