Delete Multiple rows in database

[rdztech]

PRoblem:

Selected rows are not deleted. I got this code from:

http://www.phpeasystep.com/mysql/8.html

<?php

$host="localhost"; // Host name 
$username="warisanm_fleet"; // Mysql username 
$password="warisan007"; // Mysql password 
$db_name="warisanm_fleet"; // Database name 
$tbl_name="fleet"; // 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>Lorry_No</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Trailer_No</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Location</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Remarks</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['Lorry_No']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Trailer_No']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Location']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['Remarks']; ?></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>

hmmm

[bradgrafelman]

Looks like another bad tutorial... no surprise it doesn't work, of course.

For example, where is $delete ever defined? Or $checkbox? And where's the data sanitization to make sure that invalid data (or even worse, SQL injection attacks) are rejected? And what about all of the PHP error messages and invalid HTML markup being generated?

Did I mention it was a bad tutorial? 😉

[rdztech]

Oh I see... No wonder both code are not working... perghhh.. Can you suggest any website I can get the better code?

[djjjozsi]

rdztech;10991099 wrote:

Oh I see... No wonder both code are not working... perghhh.. Can you suggest any website I can get the better code?

search for these phrases:
"post array PHP"
"process form array PHP"
"process array checkbox PHP"

[rdztech]

djjjozsi;10991106 wrote:

search for these phrases:
"post array PHP"
"process form array PHP"
"process array checkbox PHP"

thank you... I'll try...