Ad:

PHP Discussion Thread
Marked Solved
Views: 8480

Page 1
2
3
Next

You are currently viewing page 1 of this multi-page discussion thread

Aug 13th, 2008

help with delete multiple rows in mysql using checkboxes

Expand Post »

please help i don't know how to delete multiple rows in mysql using checkboxes, because it seems the delete doesn't seem to work.
here's the code:

php Syntax (Toggle Plain Text)
<?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 align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></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>
</table>
<?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 align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></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>
</table>

Last edited by fortiz147; Aug 13th, 2008 at 5:09 am. Reason: code tag

Similar Threads

MySQL Checkbox Multiple data Delete? in PHP

fortiz147

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2008

Permalink

Aug 13th, 2008

Re: help with delete multiple rows in mysql using checkboxes

see this code will work at this url:
http://www.daniweb.com/forums/thread134908.html

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Aug 13th, 2008

Re: help with delete multiple rows in mysql using checkboxes

it won't help sorry.. coz im lookin for the delete function not validation

fortiz147

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2008

Permalink

Aug 13th, 2008

Re: help with delete multiple rows in mysql using checkboxes

hello..
see that code is not for validating...
for checking checkboxes only...
its working fine for me...

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Aug 13th, 2008

Re: help with delete multiple rows in mysql using checkboxes

yep but i need the delete function for mysql >.< i dont know how to query the data from mysql in php when using the checkboxes in each row.

fortiz147

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2008

Permalink

Aug 13th, 2008

Re: help with delete multiple rows in mysql using checkboxes

ya,this is the continuation code for the above post...
after getting all check boxes you checked,then write this query to delete them(checked)

php Syntax (Toggle Plain Text)
if(isset($_POST['check_compare']))
{
$tempids=$_POST['check_compare'];	
echo $tempids;
 
$ser_qry="delete  from sometable where find_in_set(p_id,'".$_POST['check_compare']."')";
$ser_res=mysql_query($ser_qry);
 
 
}
if(isset($_POST['check_compare']))
{
$tempids=$_POST['check_compare'];	
echo $tempids;

$ser_qry="delete  from sometable where find_in_set(p_id,'".$_POST['check_compare']."')";
$ser_res=mysql_query($ser_qry);


}

Last edited by Shanti C; Aug 13th, 2008 at 7:00 am.

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Aug 14th, 2008

Re: help with delete multiple rows in mysql using checkboxes

yep but i need the delete function for mysql >.< i dont know how to query the data from mysql in php when using the checkboxes in each row.

fortiz147

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2008

Permalink

Aug 14th, 2008

Re: help with delete multiple rows in mysql using checkboxes

thank you!!!! i will try the code. =)

fortiz147

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2008

Permalink

Aug 14th, 2008

Re: help with delete multiple rows in mysql using checkboxes

hi.. i am a also a newbie.. try this one.. this worked for me.

php Syntax (Toggle Plain Text)
<html>
	<head>
 
	</head>
	<body>
		<?php
			//mysql connection
			$dbconn = mysql_connect("","","") or die();
			mysql_select_db("table") or die();
 
			$sqlquery = "your query"; // query on table
			$sqlresult = mysql_query($sqlquery, $dbconn);
			$count = mysql_num_rows($sqlresult); // count query result			
 
		?>
 
		<form method="post" action="delete.php">
			<!--
				some table headers here / or html tags
			-->
		<?php
			//loop here
			while($row = mysql_fetch_array($sqlresult))
			{
			//inside while
		?>
				<tr>
					<td><input type="checkbox" name="checkbox[]" id="checkbox[]"  value="<?php echo $row['id']?>" /></td>
					<!--
					and other data you want to print out..
					-->
				</tr>
		<?php	
			}
		?>	
				<tr><input id='delete' type='submit' name='delete' value='Delete'/></tr>
		</form>
	</body>
</html>
 
<?php
#these following code for delete.php file 
?>
 
<html>
	<?php
		//mysql connection here
 
		if($_POST['delete']) // from button name="delete"
		{
			$checkbox = $_POST['checkbox']; //from name="checkbox[]"
			$countCheck = count($_POST['checkbox']);
 
			for($i=0;$i<$countCheck;$i++)
			{
				$del_id  = $checkbox[$i];
				$sql = "delete from table where id = $del_id";
				$result = mysql_query($sql, $dbconn);
			}
				if($result)
				{
					echo "successful delete";
				}
				else
				{
					echo "Error: ".mysql_error();
				}
		}
	?>
</html>
<html>
	<head>

	</head>
	<body>
		<?php
			//mysql connection
			$dbconn = mysql_connect("","","") or die();
			mysql_select_db("table") or die();
			
			$sqlquery = "your query"; // query on table
			$sqlresult = mysql_query($sqlquery, $dbconn);
			$count = mysql_num_rows($sqlresult); // count query result			
			
		?>
		
		<form method="post" action="delete.php">
			<!--
				some table headers here / or html tags
			-->
		<?php
			//loop here
			while($row = mysql_fetch_array($sqlresult))
			{
			//inside while
		?>
				<tr>
					<td><input type="checkbox" name="checkbox[]" id="checkbox[]"  value="<?php echo $row['id']?>" /></td>
					<!--
					and other data you want to print out..
					-->
				</tr>
		<?php	
			}
		?>	
				<tr><input id='delete' type='submit' name='delete' value='Delete'/></tr>
		</form>
	</body>
</html>

<?php
#these following code for delete.php file 
?>

<html>
	<?php
		//mysql connection here
		
		if($_POST['delete']) // from button name="delete"
		{
			$checkbox = $_POST['checkbox']; //from name="checkbox[]"
			$countCheck = count($_POST['checkbox']);
			
			for($i=0;$i<$countCheck;$i++)
			{
				$del_id  = $checkbox[$i];
				$sql = "delete from table where id = $del_id";
				$result = mysql_query($sql, $dbconn);
			}
				if($result)
				{
					echo "successful delete";
				}
				else
				{
					echo "Error: ".mysql_error();
				}
		}
	?>
</html>

Last edited by enim213; Aug 14th, 2008 at 5:21 am.

enim213

Reputation Points: 11

Solved Threads: 2

Light Poster

Offline

40 posts
since Jun 2008

Permalink

Aug 19th, 2008

Re: help with delete multiple rows in mysql using checkboxes

finally!!!!!!! it worked! thank you to everyone especially to enim!

fortiz147

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

18 posts
since Aug 2008

Page 1
2
3
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Update values

Next Thread in PHP Forum Timeline: Getting str_replace function on ' sign

DaniWeb Message

Cancel Changes

User Name
Password