DaniWeb Forum Index > Web Development > PHP

MySQL Checkbox Multiple data Delete?

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2007

Posts: 1

Reputation: NeoNe is an unknown quantity at this point

Solved Threads: 0

NeoNe

Offline

Newbie Poster

MySQL Checkbox Multiple data Delete?

May 15th, 2007

Hi to everyone I’m wondering how to make some simple checkbox for multiple data delete from mysql I found some tutorial on net but don’t work. I tested it without changing anything and doesn’t work. I’m wondering did programmer test it before he posted that tutorial ?

Here is a link of that tutorial if u don’t believe me test it.
phpeasystep.com

I’m working on some cms tool to make posts on site I used a lot of cms like Joomla, WordPress and Textpattern. Now I want to make something like that, of course not even similar to that but just for my personal use and fun.

2 things to do:

Option to select all checkboxes. I like something like in joomla in top there is checkbox with titles when u select it all checkbox are selected and if u uncheck it all is unchecked
When I press delete button all checkboxes that I select are deleted from database or moved to some other category like trash which is nice because u can in that way return some posts that u delete by mistake or some other reason

Here is my code that bothers me becouse checkboxes don't work

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
include ('conf/config.php');
include('conf/opendb.php');
$sql="SELECT id, title, author, DATE_FORMAT(date, '%M %d, %Y') as sd FROM $tbl_name";
$result=mysql_query($sql);
 
$count=mysql_num_rows($result);
 
?>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0" class="adminlist">
<tr id="top">
<th width="5" align="center">Id</th>
<th width="5" align="center">#</th>
<th>Title</th>
<th width="200" align="center">Author</th>
<th width="100" align="center">Date</th>
<th width="80" align="center">Delete</th>
<th width="20" align="center">Edit</th>
</tr>
<?php
while($rows = mysql_fetch_array($result)){
?>
<tr>
<td width="5" align="center"><? echo $rows['id']; ?></td>
<td width="5" align="center"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td><? echo $rows['title']; ?></td>
<td width="200" align="center"><? echo $rows['author']; ?></td>
<td width="100" align="center"><? echo $rows['sd']; ?></td>
<td width="80" align="center" id="trash"><a href="delete_news.php?id=<? echo $rows['id']; ?>">Delete</a></td>
<td width="20" align="center" id="edit"><a href="edit_news.php?id=<? echo $rows['id']; ?>">Edit</a></td>
<?php
}
?>
<tr>
<td colspan="7" align="center"><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=post_manage.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>
<?php
include ('conf/config.php');
include('conf/opendb.php');
$sql="SELECT id, title, author, DATE_FORMAT(date, '%M %d, %Y') as sd FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

?>
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0" class="adminlist">
<tr id="top">
<th width="5" align="center">Id</th>
<th width="5" align="center">#</th>
<th>Title</th>
<th width="200" align="center">Author</th>
<th width="100" align="center">Date</th>
<th width="80" align="center">Delete</th>
<th width="20" align="center">Edit</th>
</tr>
<?php
while($rows = mysql_fetch_array($result)){
?>
<tr>
<td width="5" align="center"><? echo $rows['id']; ?></td>
<td width="5" align="center"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td><? echo $rows['title']; ?></td>
<td width="200" align="center"><? echo $rows['author']; ?></td>
<td width="100" align="center"><? echo $rows['sd']; ?></td>
<td width="80" align="center" id="trash"><a href="delete_news.php?id=<? echo $rows['id']; ?>">Delete</a></td>
<td width="20" align="center" id="edit"><a href="edit_news.php?id=<? echo $rows['id']; ?>">Edit</a></td>
<?php
}
?>
<tr>
<td colspan="7" align="center"><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=post_manage.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

what could be wrong?

•

Join Date: Nov 2006

Posts: 4

Reputation: hookedonphp is an unknown quantity at this point

Solved Threads: 0

hookedonphp hookedonphp is offline

Offline

Newbie Poster

Re: MySQL Checkbox Multiple data Delete?

May 16th, 2007

The author may have register_globals ON, while you have (appropriately) turned it OFF.

Evaluate $_POST['delete'] to see if the value really is "Delete". Instead of simply
if($delete), then if($_POST['delete'] == 'Delete')

•

Join Date: Dec 2006

Posts: 160

Reputation: w_3rabi is an unknown quantity at this point

Solved Threads: 8

w_3rabi

Offline

Junior Poster

Re: MySQL Checkbox Multiple data Delete?

May 16th, 2007

about the CMS there is another guy on daniweb who is making a CMS for fun
u could work with him if u like so u could come out with something useful

programming is an art ,only for those who can understand it.
- th3 php wr3nch -

•

Join Date: Dec 2006

Posts: 160

Reputation: w_3rabi is an unknown quantity at this point

Solved Threads: 8

w_3rabi

Offline

Junior Poster

Re: MySQL Checkbox Multiple data Delete?

May 16th, 2007

check this link out
http://www.daniweb.com/techtalkforums/thread77977.html

programming is an art ,only for those who can understand it.
- th3 php wr3nch -

•

Join Date: Dec 2006

Posts: 34

Reputation: php_coder is an unknown quantity at this point

Solved Threads: 0

php_coder

Offline

Light Poster

Re: MySQL Checkbox Multiple data Delete?

May 22nd, 2007

HIii

while checking if delete button is active or not
you should say

if($_REQUEST['delete']))

{
//code here//
}

Hope now it will work. let me knw after u try...
Cheers
Prati

•

Join Date: May 2007

Posts: 81

Reputation: it2051229 is an unknown quantity at this point

Solved Threads: 1

it2051229

Offline

Junior Poster in Training

Re: MySQL Checkbox Multiple data Delete?

Jun 20th, 2007

Well i'm having a problem with the compatibility of javascript and PHP multiple delete check box.. i used a javascript for the "CHECK ALL BOXES" just like yahoo mail.. so my input is something like this "<input type='checkbox' name='checkbox' value='1'><input type='checkbox' name='checkbox' value='2'>" and the check all boxes function worked but it doesnt work with my PHP code where it is something like this :

$checked = $_POST["checkbox"];
for($i=0; $i < count($checked); $i++) {
....// DELETE ALL CHECKED
}

but if i change my input to something like: <input type='checkbox' name='checkbox[]' value='1'><input type='checkbox' name='checkbox[]' value='2'>.. it does work on my PHP script but it wont work for my "Check all Function" javascript.. damn it.. i need help!!!

•

Join Date: Nov 2008

Posts: 2

Reputation: sajjadpk is an unknown quantity at this point

Solved Threads: 0

sajjadpk

Offline

Newbie Poster

Re: MySQL Checkbox Multiple data Delete?

Nov 21st, 2008

I m facing the same prob buddy if u got solved then plz share it with me

•

Join Date: May 2007

Posts: 81

Reputation: it2051229 is an unknown quantity at this point

Solved Threads: 1

it2051229

Offline

Junior Poster in Training

Re: MySQL Checkbox Multiple data Delete?

Nov 21st, 2008

Yes this problem of mine was since i was still learning javascript. What i did is the name is still the same where the name has the '[]' brackets so that it will work with PHP but the javascript will be different. If you mind posting your javascript so that i can see.

•

Join Date: Dec 2008

Posts: 3

Reputation: Logan_Yupp is an unknown quantity at this point

Solved Threads: 0

Logan_Yupp Logan_Yupp is offline

Offline

Newbie Poster

Re: MySQL Checkbox Multiple data Delete?

Dec 9th, 2008

For The Check All/Uncheck All Functions.
Just Change The Name Of The Form In The Javascript And The HTML As Needed

The Javascript:

 Help with Code Tags 
 Javascript Syntax (Toggle Plain Text) 
function CheckAll() {
	count = document.deleteform.elements.length;
	for (i=0; i < count; i++) {
		if (document.deleteform.elements[i].checked == 0) {
			document.deleteform.elements[i].checked = 1;
		} else {
			document.deleteform.elements[i].checked = 1;
		}
	}
}
 
function UncheckAll() {
	count = document.deleteform.elements.length;
	for (i=0; i < count; i++) {
		if (document.deleteform.elements[i].checked == 1) {
			document.deleteform.elements[i].checked = 0;
		} else {
			document.deleteform.elements[i].checked = 0;
		}
	}
}
function CheckAll() {
	count = document.deleteform.elements.length;
	for (i=0; i < count; i++) {
		if (document.deleteform.elements[i].checked == 0) {
			document.deleteform.elements[i].checked = 1;
		} else {
			document.deleteform.elements[i].checked = 1;
		}
	}
}

function UncheckAll() {
	count = document.deleteform.elements.length;
	for (i=0; i < count; i++) {
		if (document.deleteform.elements[i].checked == 1) {
			document.deleteform.elements[i].checked = 0;
		} else {
			document.deleteform.elements[i].checked = 0;
		}
	}
}

The HTML:

 Help with Code Tags 
 HTML Syntax (Toggle Plain Text) 
<form name="deleteform" action="somepage" method="post">
 
	<input type="checkbox" name="ANY NAME" value="THE VALUE" />
 
	<a href="javascript:void()" onClick = "CheckAll()">Select All</a>
	<a href="javascript:void()" onClick = "UncheckAll()">Select None</a>
 
</form>
<form name="deleteform" action="somepage" method="post">

	<input type="checkbox" name="ANY NAME" value="THE VALUE" />

	<a href="javascript<b></b>:void()" onClick = "CheckAll()">Select All</a>
	<a href="javascript<b></b>:void()" onClick = "UncheckAll()">Select None</a>

</form>

Last edited by Logan_Yupp; Dec 9th, 2008 at 7:30 pm.

•

Join Date: Dec 2008

Posts: 3

Reputation: Logan_Yupp is an unknown quantity at this point

Solved Threads: 0

Logan_Yupp Logan_Yupp is offline

Offline

Newbie Poster

Re: MySQL Checkbox Multiple data Delete?

#10

Dec 9th, 2008

I've been experimenting with my php code for a while now and i found a way to perform the task of deleting the check-boxed items:

In the html, make sure all the check-boxed items have are named with brackets '[]' after the name, Like:

 Help with Code Tags 
 HTML Syntax (Toggle Plain Text) 
<input type="checkbox" name="delete[]" value="THE VALUE" />
<input type="checkbox" name="delete[]" value="THE VALUE" />

Post the results to the second page. In the second page, assign the posted results to a variable. In my example, the variable is $delete:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$delete = $_POST['delete'];
 
 
//Then do what you want with the selected items://
 
foreach ($delete as $id) {
 
	$q = "DELETE FROM table_name WHERE item_id = $id LIMIT 1"; //THE QUERY
	$r = @mysqli_query($DATABASE_CONNECTION, $q); //EXECUTE QUERY
}
 
 
//Show that the items have been successfully removed.//
 
if (mysqli_affected_rows($DATABASE_CONNECTION) > 0) {
	echo '<p>The selected items have been successfully deleted.</p>';
} else {
	echo '<p>An error has occurred while processing your request</p>';
}
$delete = $_POST['delete'];


//Then do what you want with the selected items://

foreach ($delete as $id) {

	$q = "DELETE FROM table_name WHERE item_id = $id LIMIT 1"; //THE QUERY
	$r = @mysqli_query($DATABASE_CONNECTION, $q); //EXECUTE QUERY
}


//Show that the items have been successfully removed.//

if (mysqli_affected_rows($DATABASE_CONNECTION) > 0) {
	echo '<p>The selected items have been successfully deleted.</p>';
} else {
	echo '<p>An error has occurred while processing your request</p>';
}