Updates to multiple records - more than one field

[TangoGirl]

I fixed the last problem I had and learned quite a bit through posting here, so here we go again...

This time I have a results page which displays records with the facility to update the database using checkboxes, e.g.:

Record 1
[checkbox] Delete this record
[checkbox] Update this record

Record 2
[checkbox] Delete this record
[checkbox] Update this record

etc.

The checkboxes generated contains unique IDs as values. What I need to work out is how to get this to work. I was trying out a theory where the 'Delete' checkbox is named 'delete[]' and 'Update' is 'update[]', using a foreach loop to perform the correct function. Not sorted the syntax out yet but discovered a new problem.

I only want the user to be able to select one option, either Delete OR Update, but I can't use radio buttons because I need the name of the input field to create the array as above.

Any guidance on whether you think the foreach loop idea should work, or overcoming the second problem, much appreciated!

[ingchun]

Dear TangoGirl:

I hope this help...

Record 1
[checkbox]......

Record 2
[checkbox] ......

.
.
.
.
.

[Button for Delete] [Button for Update]

Button with name=button and value="delete" or value="update"
name the checkbox with anyname. for ex: anyname[]

<?
if ($button==delete){

use for loop to obtain value of array anyname[] and
perform delete action...

}

if ($button==update){

use for loop to obtain value of array anyname[] and
perform update action...

}

?>

[TangoGirl]

Thanks for the response ingchun.

I guess this is is easiest way of achieving what I want to do - I think two options for each record and one submit button would be too complex. Cheers!

[TangoGirl]

Arrgghh! This seemed to work fine yesterday but now records are being deleted no matter which button is pressed. Any feedback appreciated:

 if ($HTTP_POST_VARS['button'] = 'del') {
  $updateSQL = sprintf("DELETE from employees WHERE ID IN (". implode($HTTP_POST_VARS['select'], ',') . ")");
 }

// if the 'update' button has been pressed
 elseif ($HTTP_POST_VARS['button'] = 'update') {
  foreach($HTTP_POST_VARS['select'] as $IDlist);
  $updateSQL = sprintf("UPDATE employees SET Status = 'Live' WHERE ID IN ($IDlist)");
 }

Where the checkbox is named 'select' and there are 2 buttons named 'button' with the values set as 'delete' and 'update'.

I know the 2 methods are different, I was just trying each out - both should work, no?

[xblue]

Hi TangoGirl,

me again 🙂

Check the implode syntax, the delimiter is supposed to be the first argument, and the array you want to implode the second.

Hope this helps,
xblue

[TangoGirl]

Hi again xblue...

See what you mean re the syntax, fixed this. Shouldn't affect the second elseif statement though?

The if and elseif criteria are being ignored, and the records are being deleted whichever button is pressed, I just can't see why!

[chinni_77]

hi ya tango girl,

did yu fix the problem???I guess, I did such example long time before....
Think i can help you!

cheers

[siwis]

A bit behind the times, but this is most likely the cause of the deletions:

if ($HTTP_POST_VARS['button'] = 'del') {

that really should read

if ($HTTP_POST_VARS['button'] == 'del') {

because your version sets the value to del and then executes it!

[mykg4orce]

everyone is so nice to the girls 🙂

[TangoGirl]

Hmmm. I started out with if $button == delete etc as advised by ingchun but that does nothing, everything is just ignored. Think I need to start from scratch!

If anyone has achieved something similar I would appreciate some guidance... thanks chaps!

[xblue]

okay:
($button==0) does not work. The comparison operator is correct, but with a new php version you can't access variables this way, you need to use
$_POST['button'] or
$HTTP_POST_VARS['button']

($HTTP_POST_VARS['button'] = 'del') does not work. This is because you use the assignment operator, it will always evaluate to true (see Siwis' post).

Now, next try probably would be
($HTTP_POST_VARS['button'] == 'del')
😉

And 'button' needs to be the name of the respective input type=submit, of course.

[TangoGirl]

Thanks xblue - my code is actually as below, soz was just using a shortcut:

if ($HTTP_POST_VARS['button'] == "del") {
  $updateSQL = sprintf("DELETE from employees WHERE ID IN (". implode(',', $HTTP_POST_VARS['select']) . ")");

  mysql_select_db($database_connEmployee, $connEmployee);
  $Result1 = mysql_query($updateSQL, $connEmployee) or die(mysql_error());
 }

elseif ($HTTP_POST_VARS['button'] == "update") {
  $updateSQL = sprintf("UPDATE employees SET Status='Live' WHERE ID IN (". implode(',',$HTTP_POST_VARS['select']) . ")");

  mysql_select_db($database_connEmployee, $connEmployee);
  $Result1 = mysql_query($updateSQL, $connEmployee) or die(mysql_error());
 }

[TangoGirl]

Still banging my head against the wall over this one! chinni_77, or anyone who has a working example of this, would you mind posting your code so I can check it against mine?

Many thnx

[chinni_77]

gimmi ur e-mail or write me on [e-mail]