Update Multiple Records via Checkbox

KrisCons

Hi,

Bit of a pickle. Please advise a learner.

I have a page which displays records of data each with a checkbox field:

Code at the top of my page takes the value of the value of persselected[] when the submit button is pressed:

if (isset($POST['submitpersons'])) {
$selectedpers = implode(",", $POST['persselected']);
$success = EnterPersons($selectedpers );
echo $success;
}

The problem I am having ( i think) is with my Function. I need it to insert how ever many records/checkboxs are selected. At the moment, it only inserts one record:

function EnterPersons($personid) {

$sqlquery = "INSERT INTO mytable (field1, field2, field3)
VALUES ($personid, 0, 0)";

$result = mysql_query($sqlquery, $_SESSION['S_REMOTE_DB']);

if ($result) {
$blnresult = true;
} else {
$blnresult = false;
}

return $blnresult;

Can someone please point out what I am missing and where it should go?

Thanks in advance.

}

bubblenut

Yep, what you've forgoten is that $selectedpers is an array and you must therefore iterate through it to generate the multiple inserts. Also, please remember to surround php code with [php] [/php] tags, thanks.

function EnterPersons($personid) {

$sqlquery = "INSERT INTO mytable (field1, field2, field3) VALUES ";
for($i=0, $c=count($personid); $i<$c; $i++) {
    $sqlquery.=($i?',':'')."('$personid[$i]', 0, 0)";
}

$result = mysql_query($sqlquery, $_SESSION['S_REMOTE_DB']);

if ($result) {
    $blnresult = true;
} else {
    $blnresult = false;
}

return $blnresult;
}

KrisCons

Hi,

Thank you for the swift response, but when using this code, it only inserts one row no matter how many checkboxes I select.

If it helps, its always the first checkbox row that is selected which gets inserted into the database.

Kind Regards

bubblenut

Could you do a [man]print_r()[/man] and the $_POST array and post up the result please?