Delete Usings Checkboxes

[adamjblakey]

Hi,

I have a system in place like an inbox which people can select a check box next to each message and then press delete which will delete the selected.

<input name="delete" type="checkbox" id="delete" value="<?php print $rows['id']; ?>" />

This is my code:

[PHP]
$delete = $_POST['delete'];

foreach ($delete as $deleted) {
$sql = mysql_query("DELETE * FROM messages WHERE id='$deleted'");

}
[/PHP]

This is not working though. Any ideas?

Cheers,
Adam

[ajcolburn]

Hi,

I have a system in place like an inbox which people can select a check box next to each message and then press delete which will delete the selected.

<input name="delete" type="checkbox" id="delete" value="<?php print $rows['id']; ?>" />

This is my code:

[PHP]
$delete = $_POST['delete'];

foreach ($delete as $deleted) {
$sql = mysql_query("DELETE * FROM messages WHERE id='$deleted'");

}
[/PHP]

This is not working though. Any ideas?

Cheers,
Adam

Hi there,
Try replacing 'delete' with 'delete[]' as the name to post checkbox values as an array, eg:

<input name="delete[]" type="checkbox" id="delete" value="<?php print $rows['id']; ?>" />
 

[adamjblakey]

I have just tried this and it appears that it does not work :( Any ideas?

[Markus]

echo the deleted out, to see if its being passed.
[php]
$delete = $_POST['delete'];

foreach ($delete as $deleted)
{
echo $deleted . "<br />";
// $sql = mysql_query("DELETE * FROM messages WHERE id='$deleted'");
}
[/php]

[adamjblakey]

No nothing is being passed :S

Why do you think that is?

[Markus]

Post the code for your form please :)

We'll have a harder look!

[adamjblakey]

Ok great, i am using smarty so if the tags look weird thats why.

 
<form action="send-message-process.php?type=delete" method="post" name="frm1" id="frm1">
 
             <input type="submit" name="Submit3" value="Delete" class="buttons" />
 
        <table width="100%" border="0" cellspacing="0" cellpadding="3">
                                <tr>
                                  <td width="4%" height="30" background="images/red-nav-bar.jpg"><h2 class="white">
                                      <input name="allbox2" type="checkbox" id="allbox2" value="checkbox" onclick='checkedAll(frm1);'/>
                                  </h2></td>
                                  <td colspan="2" background="images/red-nav-bar.jpg"><h2><span class="white">Sender</span></h2>                                    </td>
                                  <td width="61%" background="images/red-nav-bar.jpg"><h2><span class="white">Subject</span></h2></td>
                                  <td width="15%" background="images/red-nav-bar.jpg"><h2 class="white">Date</h2></td>
                                </tr>
                                {php} 
                                $sqls = mysql_query("SELECT * FROM messages WHERE profileid = '$_COOKIE[id]'"); 
                                while($rows = mysql_fetch_array($sqls)){ 
                                {/php}
                                <tr>
                                        <td bgcolor="#FCE4E5"><input name="delete[]" type="checkbox" id="delete[]" value="{php} print $rows['id']; {/php}" /></td>
                                  <td width="10%" bgcolor="#FCE4E5"> {php} 
                                    $sql = mysql_query("SELECT * FROM users WHERE id = '$rows[userid]'"); 
                                    while($row = mysql_fetch_array($sql)){ 
                                    {/php} <a href="message-details.php?id={php} print $row['id']; {/php}"><img src="profile/thumbs/{php} print $row['image_1']; {/php}" width="50" height="40" border="0" /></a> {php} } {/php} <br />                                        </td>
                                  <td width="10%" bgcolor="#FCE4E5"><a href="message-details.php?id={php} print $row['id']; {/php}">{php} print $rows[username]; {/php}</a></td>
                                  <td bgcolor="#FCE4E5"><a href="message-details.php?id={php} print $rows[id]; {/php}">{php} print $rows[title]; {/php}</a></td>
                                  <td bgcolor="#FCE4E5">{php} print $rows['sdate']; {/php}</td>
                                </tr>
                                {php} } {/php}
                              </table>
                              <p><a href="#" onclick='checkedAll(frm1);'>Select All</a> / <a href="#" onclick='checkedAll(frm1);'>Unselect All</a> </p>
 
       <input type="submit" name="Submit22" value="Delete" class="buttons" />
 
                              </p>
                            </form>