RE: Delete the Multiple Check Box using php+mysql

"Shehzad Asghar Saddiq" <shehzad_asghar@xxxxxxxxxxxxxxxxxxx> · Sun, 3 Aug 2008 06:49:58 -0700

You are not putting anything in the $count variable.

Kindly make it $count = count($_REQUEST[‘Checkbox’]) before running the for loop for delete.

Thanks & Best Regards, 

Shehzad Asghar Saddiq

Group Manager Products
UAE Experts IT Networking Services 

 "This e-mail message (including any attachments) may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that UAE Experts IT Networking Services  or its sister companies and associated companies, (collectively "UAE Experts IT Networking Services"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of UAE Experts IT Networking Services. Before opening any attachments please check them for viruses and defects."

From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of gopi nath
Sent: Saturday, August 02, 2008 6:49 AM
To: php-objects@xxxxxxxxxxxxxxx
Subject:  Delete the Multiple Check Box using php+mysql

HI Friends,

 i have a doubt in my script. my error is: cannot delete the multiple rows.
<?php

$host="localhost"; // Host name 

$username=""; // Mysql username 

$password=""; // Mysql password 

$db_name="test"; // Database name 

$tbl_name="test_mysql"; // Table name 
// Connect to server and select databse.

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 

mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name";

$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">

<tr>

<td><form name="form1" method="post" action="">

<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">

<tr>

<td bgcolor="#FFFFFF">&nbsp;</td>

<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>

</tr>

<tr>

<td align="center" bgcolor="#FFFFFF">#</td>

<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>

<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>

</tr>

<?php

while($rows=mysql_fetch_array($result)){

?>

<tr>

<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>

</tr>

<?php

}

?>

<tr>

<td colspan="5" align="center" bgcolor="#FFFFFF"><input
name="delete" type="submit" id="delete" value="Delete"></td>

</tr>

<?

// Check if delete button active, start this 

if($delete){

for($i=0;$i<$count;$i++){

$del_id = $checkbox[$i];

$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";

$result = mysql_query($sql);

}
// if successful redirect to delete_multiple.php 

if($result){

echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";

}

}

mysql_close();

?>

</table>

</form>

</td>

</tr>
</body>
</html>

Add more friends to your messenger and enjoy! Go to http://in.messenger.yahoo.com/invite/

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]