checkbox multiple delete in mysql rows

Anon

hi
i hope some of you'll be able to find an answer to my problem

ok
i've a table that generates a list of table rows (including my table key) and populates them with data from a mysql table (by a simple select)
each row has a checkbox next to them to allow multiple row deletions from the database

here's my code :

<?php
$host = MYHOST;
$user = MYUSER;
$bdd = mydb;
$password = mypasswd;

mysql_connect($host, $user,$password) or die("error");

$query = "SELECT A,B,C,D,E,F,G FROM Mytable where Mytable.DELETED='N'";
mysql_select_db($bdd) or die("error");
$result = mysql_query($query);

if (mysql_num_rows($result) != 0) {
while ($row = mysql_fetch_row($result)){
$A = $row[0];
$B = $row[1];
$C = $row[2];
$D = $row[3];
$E = $row[4];
$F = $row[5];
$G = $row[6];

=> then i display my html stuff
<DIV ALIGN="center">
<tr>
<td><a href="/pathtoscript/?A=<?php echo $A?>&Flag=<?php $Flag?>"><?php echo $A ?/a></td>
<td><?php echo $B ?></td>
<td><?php echo $C ?></td>
<td><?php echo $D ?></td>
<td><?php echo $E ?></td>
<td><?php echo $F ?></td>
<td><?php echo $G ?></td>
<td><INPUT TYPE="checkbox" NAME="$files[]" VALUE="<?php echo "$A"; ?>" > <?php echo "$A" ?></td><br>
</tr>
</DIV>
===> A is my key field

<?php
}
mysql_close();
}
?>

==> then i submit
</TABLE>

<BR><BR>
<DIV ALIGN="center">
<FORM ACTION="/pathtosamescript" METHOD=POST>
<INPUT TYPE="submit" VALUE="SUBMIT"
ONSUBMIT=<?php

for ($i=0;$i<count($files);$i++)
{
$sql_id = $sql_id."A='$files$i]'" . " OR ";
}
// Chop off the last OR statement on $sql_id
$sql_id = substr($sql_id, 0, -3);
*/

mysql_connect($host, $user,$password) or die("error");

$query = "Update Appartement set DELETED='O' Where $sql_id ";
mysql_select_db($bdd) or die("error");
$result = mysql_query($query);

// Deconnexion de la base de donnees
mysql_close();
?> >
</DIV>

</FORM>

and then i get no result when i check the row i want to delete (in fact the row isn't really deleted but i set a flag DELETED="O" then i only display the row where my flag="N")

please if some could help quickly it'd be very nice cause i've the same problem on an other column & i've got the same code but it still won't work

hope you'll helpl me

Anon

Hi !

I'm tired (on my way to bed) and didn't want to dig into your code. Too big 😉

However, I use something like this:

/ The sending page /

// do query and receive result
$resultSet = mysql_query( "SELECT id, name FROM tblTable", $dbhMysql );

// for each row, get [id] and [name]
while( list( $id, $name ) = mysql_fetch_array( $resultSet ) )
{
echo "<INPUT TYPE = 'checkbox' NAME = 'DeleteItems[]' VALUE = '$id'> $name<BR>";
}

/ The receiving page /

// construct a comma delimited string of the array
$csvID = implode( ",", $DeleteItems );

// construct a sql-query using IN( /* comma_separated_list_here */ )
$DeleteQuery = "DELETE FROM tblTable WHERE id IN($csvID)";

I think that is the easiest solution to a "checkbox-multiple-delete"

/ Ronnie

Anon

Ronnie you are my god. I couldnt figure out how to do this. But your method is short, simple and works perfectly.

I have one correction to your code, and this was because you were read to go to bed. but in your implode it should be:

$csvID = implode($DeleteItems, ",");

You just had it backwards.

Regards,

Derek C

basher

I kinda get where you are going with this code, can someone give an example page for these pages the sending page and the receiving page. I'm not sure how you pass the info from one page to the next, buy submit button or what. Thanks..

Hi !

I'm tired (on my way to bed) and didn't want to dig into your code. Too big 😉

However, I use something like this:

/ The sending page /

// do query and receive result
$resultSet = mysql_query( "SELECT id, name FROM tblTable", $dbhMysql );

// for each row, get [id] and [name]
while( list( $id, $name ) = mysql_fetch_array( $resultSet ) )
{
echo "<INPUT TYPE = 'checkbox' NAME = 'DeleteItems[]' VALUE = '$id'> $name<BR>";
}

/ The receiving page /

// construct a comma delimited string of the array
$csvID = implode($DeleteItems, ",");

// construct a sql-query using IN( / comma_separated_list_here / )
$DeleteQuery = "DELETE FROM tblTable WHERE id IN($csvID)";

I think that is the easiest solution to a "checkbox-multiple-delete"

/ Ronnie