MySQL Checkbox Multiple data Delete?

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')

hookedonphp

Newbie Poster

4 posts since Nov 2006

Reputation Points: 10

Solved Threads: 0

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

w_3rabi

Junior Poster

160 posts since Dec 2006

Reputation Points: 18

Solved Threads: 9

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

w_3rabi

Junior Poster

160 posts since Dec 2006

Reputation Points: 18

Solved Threads: 9

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

php_coder

Light Poster

34 posts since Dec 2006

Reputation Points: 10

Solved Threads: 0

4 Years Ago

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 "" 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: .. it does work on my PHP script but it wont work for my "Check all Function" javascript.. damn it.. i need help!!!

it2051229

Junior Poster in Training

82 posts since May 2007

Reputation Points: 7

Solved Threads: 1

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

sajjadpk

Newbie Poster

2 posts since Nov 2008

Reputation Points: 10

Solved Threads: 0

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.

it2051229

Junior Poster in Training

82 posts since May 2007

Reputation Points: 7

Solved Threads: 1

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

The Javascript:

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:

<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>

Logan_Yupp

Newbie Poster

3 posts since Dec 2008

Reputation Points: 10

Solved Threads: 0

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:

<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:

$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>';
}

Logan_Yupp

Newbie Poster

3 posts since Dec 2008

Reputation Points: 10

Solved Threads: 0

On the top of the page, just include the following piece of code...

<?php
if($_POST['delete']=="Delete")
{
    $delete_ids=implode(",",$_POST['checkbox']);
    mysql_query("Delete from $tbl_name WHERE id in $delete_ids");
   //Checkbox is the input field named checkbox.. It automatically takes goes as an array in php.

    //Thats it.. you are done.....
}

sikka_varun

Junior Poster in Training

94 posts since Dec 2008

Reputation Points: 11

Solved Threads: 12

Thats awesome..i'm a newbie to programming with php so the implode function is new to me..thanks for showing that =)

Logan_Yupp

Newbie Poster

3 posts since Dec 2008

Reputation Points: 10

Solved Threads: 0

Show Comments

-2

Hey Buddy!! Try This It will work.. Thing is you are POSTING the check box value but not receiving it.. Hope it may help you.. Cheers..

<?php
// Check if delete button active, start this
$action = $_POST['delete'];
$value = $_POST['check'];
if($action == 'Delete')
{
for($i=0;$i<$count;$i++){
$del_id = $value[$i];
$sql = "DELETE FROM $tbl_name WHERE Issue_No='$del_id'";
$result = mysql_query($sql) or die ('Could not connect: ' . mysql_error());
}

// if successful redirect to delete_multiple.php
if($result)
{
echo "";
}
}
mysql_close();
?>

vivek.rangasamy

Newbie Poster

2 posts since Oct 2009

Reputation Points: 9

Solved Threads: 0

Show Comments

-2

The above message Check ur Check BOX will definitely Help
Mr. NeoNe or any one with the same bug..

vivek.rangasamy

Newbie Poster

2 posts since Oct 2009

Reputation Points: 9

Solved Threads: 0

echo "";

what is the purpose of the echo statement ??

benila

Newbie Poster

1 post since Oct 2009

Reputation Points: 10

Solved Threads: 0