Multiple Chechbox selection problem

Anon

hello
i have used checkboxes for multiple selection
iam able to get the boxes cheked but unable to delete that particulr row from database
kindly help me in this regard

Roopa

PHPFAQ

Hey i'm having the same problem.
I'm working on a mail application, in which i have to delete multiple rows from the database, only which are checked in the check box. Same we do in the Yahoo or other mails.

Please Reply ASAP.

Thank You.
Pratik.

rikmoncur

Your checkboxes have to be made into an array by adding square brackets to the name []

Then when the form is submitted, you loop through the array with a while loop to get the keys and values. Then use the value in the sql to delete from your db.


while 
(list($k,$v) = each($deleterecord)) 
 { 
$sql="delete from YourTable WHERE YourRecord=$v";
 }

If you don't want to re-invent the wheel, there's a cool mailing programme at
http://dustin.polvero.com/email-list.php
that's the one I pulled apart to learn from.

PHPFAQ

this is inbox.php

while($msg=mysql_fetch_array($res))
{
$mid = $msg['mid'];
$sender = $msg['frm'];
$sub = $msg['sub'];
$dt = $msg['dt'];

$d = "ch".$mid;

echo '<tr>';

echo '<td align="center">';

echo '<input type="checkbox" name="ch[]">';

echo '</td>';

echo '<td align="center">';
echo $mid;
echo '</td>';

echo '<td align="center">';
echo $sender;
echo '</td>';

echo '<td align="center">';
echo "<a href = disp_msg.php?mid=$mid>$sub";
echo '</td>';

echo '<td align="center">';
echo $dt;
echo '</td>';

echo '</tr>';

}

and when the form is submitted delete.php is called.

the below is the delete.php

while
(list($k,$v) = each($ch))
{
$sql="delete from msg WHERE mid=$v";
print $sql;
}

AND it is giving me the ERROR;;;;;

Warning: Variable passed to each() is not an array or object in D:\Tution\php\MailApp\delete.php on line 11

kubis

try this:

<form>
<input type="checkbox" name="chbx[1]" value="1">
<input type="checkbox" name="chbx[4]" value="1">
<input type="checkbox" name="chbx[5]" value="1">
</form>

in php:

foreach($_POST['chbx'] as $key => $value){
  $sqlquery = "DELETE FROM table WHERE primaryKeyColumn=".intval($key);
 // execute the query
}

the point is, that the number in chbx[] is a row identifier, e.g. a primary key in table..

you can use the same thing in <select> whele multiple selection is allowed

PHPFAQ

it is not working as well as it is not showing any ERROR.

rikmoncur

Yes, sorry for not making that clear - your checkbox will need a value - mine is dynamically filled from the database with the users id.


<input type="checkbox" name="deleterecord[]" value="<?php echo $row_rs_multidelete['YourRecords_ID']; ?>">

PHPFAQ

but what is this ?
$row_rs_multidelete['YourRecords_ID']

kubis

assume $row_rs_multidelete is a result of, lets say, mysql_fetch_array()

the YourRecords_ID is the primary key (i.e. the identifying column) of table

rikmoncur

as kubis said.

jmshillito

I have this code to list multiple students for deletion:

<?php
session_start();
if(!$SESSION['loggedin'] || !isset($SESSION['loggedin']))
{echo 'Sorry, you do not have access to this page. <a href="mer_index.php">Home page</a>';die();};
$back = '<a href="javascript:history.go(-4)">Add another</a>';
$login = '<a href="mer_index">Log out</a>';
$tname= $_SESSION['teachername']; //issuing teacher
print "<b> $tname </b>";
print "</tr><br />\n";
require 'mer_connect.php';
$csql = "select * from mer_merits where teachername = '$tname' and prt='1'";
$result = mysql_query($csql);
$nrows = mysql_affected_rows();
if ($nrows == -1) {echo 'Unexpected error in the query:<br/>';
die($csql);};
?>
<form action="mer_testeval.php" method="get">
<input type="submit" value="Delete"><br/>
<?php
while ($row = mysql_fetch_array($result))
{
echo '<input type="checkbox" name="'
.$row['studentname']
.'"> '
.$row['studentname'].' '
.$row['meritdescription']
.'<br/>';
}
?>
</form>

I then have this page - mer_testeval - to delete the ticked students:

<?php
$back = '<a href="javascript:history.go(-1)"></a>';
require 'mer_connect.php';
$table = "mer_merits";

        foreach ($_GET ['delete'] as $value) {
            $del = "DELETE FROM mer_merits WHERE mID = '".$value."'";
            mysql_query($del) or die('SQL error: '.mysql_error());
            header("Location: ".$PHP_SELF);
    }

It deosn't work - any ideas how to change the code?

Thanks

PHPFAQ

Warning: Variable passed to each() is not an array or object in c:\inetpub\wwwroot\dmp\MailApp\delete.php on line 15

PHPFAQ

rikmoncur wrote:
Yes, sorry for not making that clear - your checkbox will need a value - mine is dynamically filled from the database with the users id.
<input type="checkbox" name="deleterecord[]" value="<?php echo $row_rs_multidelete['YourRecords_ID']; ?>">

Warning: Variable passed to each() is not an array or object

Please HELP

PHPFAQ

the inbox.php code

<input type='checkbox' name='m[]' id='m' value = '$mid'>

delete.php code...

$n = $_POST['m'];

foreach($n as $m)
{
	$sqlquery = "DELETE FROM msg WHERE mid = '$m'";
	mysql_query($sqlquery);
}