PHP array help

[AJLX]

Hello All,

Hopefully this should be an easy one. I have the following select box:

 

echo '<td><input name="checkbox[]" type="checkbox"  id="checkbox[]" value='.$row['ID']."></td>";

 

I get these variables on a separate page and try and run them through a loop so that I can delete all of the select items. It is this bit that I'm struggling with at the moment. Here is what I have so far:

 

<?php
session_start();
include("inc/session.inc.php");
include("inc/conf2.inc.php");

    foreach($_POST['checkbox'] as $value);
     $sql_query = mysql_query("DELETE FROM messages WHERE ID = '$value'");
?>

 

At the moment this doesn't appear to be working. Does anyone have any ideas?

 

Regards

 

AJLX

[Pikachu2000]

What about it isn't working?

[sikken]

this might help

 

HTML:

<input type="checkbox" name="stuff" value="a" checked="checked" />
<input type="checkbox" name="stuff" value="b" checked="checked" />
<input type="checkbox" name="stuff" value="c" checked="checked" />



PHP:

foreach($_GET['stuff'] as $val)
echo 'val='.$val;



RESULT:

val=a
val=b
val=c

 

[Pikachu2000]

That code would return an "Invalid argument supplied for foreach()" warning.

[AJLX]

It is worth noting that the check box code sits in a 'while' statement so that there are lots of them, each of which have the message ID attached to them. I want to then delete messages by this ID.

 

Regards

 

AJLX

[ChemicalBliss]

Try this and see what it says:

 

<?php
session_start();
include("inc/session.inc.php");
include("inc/conf2.inc.php");

print_r($_POST); echo("\n\n<br />");

    foreach($_POST['checkbox'] as $value){
       $sql_query = "DELETE FROM messages WHERE ID = '$value'";
       $sql_result = mysql_query($sql_query);
    }
?>

 

use "view page source" and copy/paste the results, maybe you will find the answer yourself

[AJLX]

Hello guys,

 

Using ChemicalBliss's code I get the following returned:

Array ( )

Warning: Invalid argument supplied for foreach() in /home/ajlxcou1/public_html/ProjectA/delete_message.php on line 8

 

My guess would be that the array is empty. Which then means that the foreach statement has nothing to run, and therefor throws me back an error? Is this correct? I'm not asking you guys to write this for me, but a prod in the right direction is useful!

 

Regards,

 

AJLX

 

[ChemicalBliss]

Correct .

 

Check your form html. Make sure your form tag has the method attribute set to post. Eg.

<form method="post">

 

Hope this helps

[AJLX]

Perfect I had a couple of html issues.

1) I had post[] instead of post. In my mind it made sense to be posting an array.

2) I had $rows[iD] instead of $row[iD]

 

All working now. Special thanks to ChemicalBliss.

 

Regards,

 

AJLX