Need help for multiple deletions using checkboxes

n_baswa

Hello frends,

I'm trying to create a webpage in which i have records with checkboxes at the end. When i check the boxes and click on delete button, the selected records
should be deleted.

I'm able to create the checkboxes in every row, but not able to write the delete
code.

These r my codes:

<?php

include('dbconntry.php');

$sql="SELECT * FROM properties";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

echo "Found the following entries in the database:";
echo "<br />";
echo "<br />";

$result = mysql_query("SELECT * FROM properties");

echo "<table border='1'>
<tr>
<th>House ID</th>
<th>Address</th>
<th>Location</th>
<th>Rent</th>
<th>Deposit</th>
<th>Square Feet</th>
<th>Available</th>
<th>Bed Room</th>
<th>Bath</th>
<th>Family Room</th>
<th>Fireplace</th>
<th>Type</th>
<th>Terms</th>
<th>Carpetting</th>
<th>Garage</th>
<th>Yard</th>
<th>Pet</th>
<th>Delete</th>
</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['house_id'] . "</td>";
echo "<td>" . $row['address'] . "</td>";
echo "<td>" . $row['area'] . "</td>";
echo "<td>" . $row['rent'] . "</td>";
echo "<td>" . $row['deposit'] . "</td>";
echo "<td>" . $row['sqft'] . "</td>";
echo "<td>" . $row['available'] . "</td>";
echo "<td>" . $row['br'] . "</td>";
echo "<td>" . $row['bath'] . "</td>";
echo "<td>" . $row['familyrm'] . "</td>";
echo "<td>" . $row['fireplace'] . "</td>";
echo "<td>" . $row['type'] . "</td>";
echo "<td>" . $row['terms'] . "</td>";
echo "<td>" . $row['carpetting'] . "</td>";
echo "<td>" . $row['garage'] . "</td>";
echo "<td>" . $row['yard'] . "</td>";
echo "<td>" . $row['pet'] . "</td>";
echo "<td align=center><input type = \"checkbox\" name = \"delete[]" . $house_id . "\" id = \"delete[]" . $house_id . "\" value = \"delete\" ></td>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
echo "<br>";

$num=mysql_numrows($result);
echo "Total number of entries: $num";

if(!$result)
{
echo "No data.";
}

<html>
<head><title>Web Database Sample Index</title>
</head>
<body>
<h3>Click on the links below to Alter/Modify the Database</h3>

</body>
</html>

This code helps create the checkboxes in every row.
The delete.php code which i'm using is as follows:

<?php

include('dbconntry.php');

$query = "SELECT * FROM properties";

$row= mysql_query($query);

$num_rows = mysql_num_rows( $row);

echo "$num_rows";
echo "<br>";

if($delete){

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

$del_id = $delete[$i];

$sql = "DELETE FROM properties WHERE house_id='$del_id'";

}

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}

	echo "Selected Records Deleted";
	echo "<br />";

header("Location: indextry.php");
exit;

mysql_close();

Plz guys help me in resolving this. I've to complete this project soon.

Thanks.

devinemke

a very simple example:

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	<input type="checkbox" name="delete[]" value="1"> 1<br>
	<input type="checkbox" name="delete[]" value="2"> 2<br>
	<input type="checkbox" name="delete[]" value="3"> 3<br>
	<input type="checkbox" name="delete[]" value="4"> 4<br>
	<input type="checkbox" name="delete[]" value="5"> 5<br>
	<input type="submit" name="submit" value="delete checked">
	</form>
	';
}
else
{
	if (isset($_POST['delete']))
	{
		$sql = 'DELETE FROM table WHERE id IN(' . implode(',', $_POST['delete']) . ')';
		echo $sql;
	}
	else
	{
		echo 'you did not check anything';
	}
}
?>

n_baswa

Thanks Devinemke.... but this example is only displaying the $sql statement with id number.

I didn't get how u've tried to explain me. Can u plz explain.

n_baswa

If possible, plz tell me what is wrong in my code and how do i change it so that it works. This is my first project in PHP and i'm not very good at it.

FusionComputers

if (isset($_POST['btnSubmit']) && $_POST['btnSubmit'] == 'Delete Selected')
{
  $selMessage = $_POST['selMessage'];
  $messageIDs = "";
  $selMessageCount = count($selMessage);
  if ($selMessageCount != 0)
  {
    reset($selMessage);
    $messageCounter = 1;
    while (list($key, $val) = each($selMessage)) 
    {
      if ($messageCounter != $selMessageCount)
      {
        $messageIDs .= "MessageId = " . $val . " OR ";
        $messageCounter++;
      }
      else
      {
        $messageIDs .= "MessageId = " . $val;
      }
    }
    $deletionString = "DELETE * FROM tblMessages WHERE $messageIDs";
    $rs = $db_connection->execute($deletionString);
    if ($selMessageCount != 1)
    {
      echo "<h4>$selMessageCount Messages deleted successfully.</h4>";
  }
  else
  {
    echo "<h4>$selMessageCount Message deleted successfully.</h4>";
  }
}
else
{
echo "<h4>No messages were selected.</h4>";
}

n_baswa

Thank u FusionComputers, but it is not wrking. It is giving me a blank page and when i look in the error log file, it says...

"PHP Parse error: syntax error, unexpected $end in C:\www\html\folder\delete.php on line 64"

Line 64 in my file has nothing. It is infact after the '?>', where we close the PHP.

Plz let me know...

FusionComputers

That's actually part of a larger script, but simplifies working with arrays quite a bit.

I think the reason why you're getting the errors is how I used $selMessage for working with the array. It's easier than typing out $_GET['selMessage'] when I want to refer to what's in the array. selMessage[] may not exist as an object that php can refer to. Anyhow, I'm going to grab some dinner, and then I'll give you the rest of the script, just a form with a few checkboxes that do nothing with a database. You can put the database code in with the script with a few lines.

Roger_Ramjet

Oh dear oh dear oh dear, Devinemike's code shows you how to first create the checkboxes with values that you can then use to construct the query - but does not execute it: echo not mysql_query !!!

I am sure he expected you to use the example to amend your own code, not just paste his in.

n_baswa

Thanks FusionComputers,

Can u pls explain me further. I'm sorry, i saw ur msg very late.

n_baswa

Hello frends,

Is thr anyone who can help me with this?

cgraz

Yes. Click here for your answer on a platter.

n_baswa

Hello FusionComputers...I've changed my code according to the one u gave...but i didn't get what the $key and $val are in the code. Can u or anyone pls help me in this...plzzzzzzzzzzzzzzzzzz.....i've very less time to finish this project...

<?php

include('dbconntry.php');

if (isset($POST['delete']) && $POST['delete'] == 'Delete Selected')
{
//$selMessage = $_POST['selMessage'];
$house_id = "";
//$selMessageCount = count($selMessage);

$query = "SELECT * FROM properties";

$row= mysql_query($query);

$num_rows = mysql_num_rows( $row);

if ($num_rows != 0)
{
reset($row);
$messageCounter = 1;
while (list($key, $val) = each($row))
{
if ($messageCounter != $num_rows)
{
$house_id .= "house_id = " . $val . " IN ";
$messageCounter++;
}
else
{
$house_id .= "house_id = " . $val;
}
}
echo "$house_id";
$deletionString = "DELETE * FROM properties WHERE $house_id";
//$rs = $db_connection->execute($deletionString);
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else
{
header("Location: indextry.php");
exit;
}
}
if ($num_rows != 1)
{
echo "<h4>$num_rows Messages deleted successfully.</h4>";
}
else
{
echo "<h4>$num_rows Message deleted successfully.</h4>";
}
}

else
{
echo "<h4>No messages were selected.</h4>";
}

FusionComputers

$key and $val are variables used to hold the key of an array, and $val is used to hold the value at that key. What this allows you to do is step through an array without having to worry about nonsequential or non-numeric keys. Also is useful to step through an array that has been sorted.

Can a mod please edit his post to make it legible?

n_baswa

come on guys....is thr no one who can help me with this....
plz...i'm trying this since last 3 days....

FusionComputers

Look, no one has access to the database info you've created, so we're just guessing here. We can't do the entire thing for you, because of this.

Sxooter

That and your code is not inside php tags. go in and edit it and put it in PHP tags. I don't even look at code that isn't in php tags cause all your formatting is lost and it's hard to follow. help us help you.

Roger_Ramjet

<?php

include('dbconntry.php');


if (isset($_POST['delete']) && $_POST['delete'] == 'Delete Selected')
{
//$selMessage = $_POST['selMessage'];
$house_id = "";
//$selMessageCount = count($selMessage);

$query = "SELECT * FROM properties";

$row= mysql_query($query);

$num_rows = mysql_num_rows( $row);

if ($num_rows != 0)
{
reset($row);
$messageCounter = 1;
while (list($key, $val) = each($row))
{
if ($messageCounter != $num_rows)
{
$house_id .= "house_id = " . $val . " IN ";
$messageCounter++;
}
else
{
$house_id .= "house_id = " . $val;
}
}
echo "$house_id";
$deletionString = "DELETE * FROM properties WHERE $house_id";
//$rs = $db_connection->execute($deletionString);
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else
{
header("Location: indextry.php");
exit;
}
}
if ($num_rows != 1)
{
echo "<h4>$num_rows Messages deleted successfully.</h4>";
}
else
{
echo "<h4>$num_rows Message deleted successfully.</h4>";
}
}
else
{
echo "<h4>No messages were selected.</h4>";
}


?>

Just to show the difference