Mulitple Submit Buttons for Edit/Delete of records returned

dmbxc

Searched the forums but nothing seems to answer my question. I knew to the php scene so this could be a very simple problem in your eyes.

I have a page that returns a list of results into a table. The table contains an edit and delete submit button for each record. The original author of the code designed the page so that you could hit delete in the row and the record would be removed from the database. The only problem is that the ID doesn't appear to be picked up from the row, rather the last ID that was displayed to the page is being picked up. If posting the code would hope I can manage to do that also.

One last thing, I noticed that he gave the submit buttons all the same value as in 'Del' or 'Edit'. When I changed the code to set the vaule equal to $myrow[variable] it does return the unique ID for that row to the caption for the submit button.

Thanks for any help in pointing me to the solution.

Chris

leatherback

please post some code..?

weekender

when you post a form, a submit button can return a value just like any regular field

so what you do is this

//echo the form header
echo "<FORM ACTION=....";

//let's say you're getting the rows for the form from a db
while($row = mysql_fetch_array($result)){
    //output your form
    echo $row['id'] . " - ";
    echo $row['title'];
    //then output the submit button
    echo "<INPUT TYPE=\"submit\" NAME=\"Delete this\" VALUE=\"";
    echo $row['id'];
    echo "\">";
    echo "<BR>";
}
echo "</FORM>";

then, in the file that the form posts to, you will get a value $_POST['submit'] and this value will be the id of the row that you clicked the submit button for.

adam

dmbxc

Tried the code but nothing seemed to work.

I can get the ID to display in the submit button caption but when I tried calling $_POST['submit'] (in the code I'm using its $PHP_SELF['submit'] the only thing that comes back was a forward slash.

Monday morning I will post some of the code which resides on a Redhat 9 box.

Thanks for the help so far, I will read up some more on this site about PHP since our Intra-Net site is mostly PHP on an Apache server.

Cheers

weekender

no, you want the id in the VALUE attribute of the submit button

and there is no $PHP_SELF array - the variable WILL be in $POST or $GET

PHP_SELF (if you have register_globals off, which you should) is a key in $_POST.

leatherback

Hi dmbxc,

Befre you decide to use the value of a button to deicde upon actions (you should actually place: $row[id]\" after the first double quote of the value in the button in weekenders'script, and it shoud werk), consider that not all browsers may interprete it properly.

You could also just have a new form for each row to edit, and a hidden variable with the id value.

dmbxc

The original code posted in response to my problem worked. I made the mistake of not including a underscore mark in $_POST['Sum_Del']. Thanks for all the help.