Modifying multiple records with one click

abel122

Hi all.

I want to make a page where let's say 10 records will be visible with a check box for each record. After changing some of the check box values, I want to click a button and have those records updated in the table.

It is kind of like the delete feature in Yahoo mail and Hotmail.

Is it possible to do it with php? If so, I would really appreciate if you could point me to a resource or give me some advice.

Thanks and have a great day!

cgraz

yeah, I've done this in the past to delete a list of members. Here's what i did.

The list of members was stored in the database. I dynamically created a list of the members that looked like this

[ ] Member Name Email
[ ] Member Name Email
[ ] Member Name Email

The checkboxes all had the same name; they were an array. So you have to name them something like

This would give you the array $to_update to work with, and the value of each array key would be the members id in the database. Then, you can loop through the results on the processing page and do what you want with it.

abel122

Thanks for your response cgraz.

After thinking about it a little bit, I want to change my approach. I want each row to contain a checkbox and when that check box gets updated, that record in the database gets updated.

I tried onClick but can't get it to work. Any suggestion will be greatly appreciated.

Thanks, Abel

cgraz

well give them a name like I said (so they become an array) and the value is the id, then loop through the results to update the database

foreach($_POST['to_update'] as $value) {
   $query = mysql_query("UPDATE table SET bla='whatever' WHERE id='$value'") or die(mysql_error());
}

Or something to that extent.

Cgraz