editing single column on multiple rows

[smerny]

If I have a page that displays rows of a database in rows on the webpage... what is the best way to use checkboxes so that I can edit all the rows that are checked?

 

basically:

 

SET status='0' WHERE checkmarked

[Psycho]

Create the checkboxes as an array with the value of each set to the id of the relevant record. Example

Record 1 <input type="checkbox" name="idList[]" value="1" /><br />
Record 2 <input type="checkbox" name="idList[]" value="2" /><br />
Record 3 <input type="checkbox" name="idList[]" value="3" /><br />

 

Then on your processing page just check to make sure that the field is passed (i.e. at least one checkbox was checked) and run a single query using the array of values as part of the WHERE clause.

 

Example

if (isset($_POST['idList']))
{
    $idListValues = implode(',', $_POST['idList']);
    $query = "UPDATE table SET status=0 WHERE id IN ($idListValues)";
    mysql_query($query);
}

 

Of course you need to add proper validation of the values to prevent sql injection.

[smerny]

perfect, thanks