Hi,
Here i m giving a example for deleting all records and also u can delete a single record. U check it and if u have any doubt u pls message me. If you press all button in the headings, it will delete all records.
Sample Codings:
<?php
$con=mysql_connect("localhost","root","simply123") or die(mysql_error());
mysql_select_db("databasename",$con) or die(mysql_error());
// Give r connection details for database
if($_REQUEST['delete'])
{
$totalarray=sizeof($del);
for($i=0;$i<$totalarray;$i++)
{
if(!empty($del[$i])){
mysql_query("delete from tbl_sample where id=".$del[$i]) or die(mysql_error());
}
}
$msg="Values Deleted Successfully";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<script language="JavaScript">
<!--
function CheckAll()
{
for (var i=0;i<document.frmdeleteall.elements.length;i++)
{
var e = document.frmdeleteall.elements[i];
if (e.name != "allbox")
e.checked = document.frmdeleteall.allbox.checked;
}
}
//-->
</script>
</HEAD>
<BODY>
<form name="frmdeleteall" method="post" action="deleteall.php">
<table border=1 cellpadding=0 cellspacing=2 width="70%" align="center">
<?if($msg){?>
<tr>
<td colspan=5 align="center"><?=$msg?></td>
</tr>
<?}?>
<tr>
<td>S.No</td>
<td>Name</td>
<td>Address</td>
<td>City</td>
<td>All: <input name="allbox" type="checkbox" value="1" onClick="CheckAll();"></td>
</tr>
<?
$sql="select * from tbl_sample order by id limit 0,3";
$i=0;
$query=mysql_query($sql) or die(mysql_error());
while($row=mysql_fetch_array($query))
{
echo "<tr>";
echo "<td>".$i++."</td>";
echo "<td>".$row['Name']."</td>";
echo "<td>".$row['Address']."</td>";
echo "<td>".$row['City']."</td>";
echo "<td><input type=\"checkbox\" name=\"del[]\" value=".$row['id']."></td>";
echo "</td>";
echo "</tr>";
}
?>
<tr>
<td colspan=5 align="center"><input type="submit" name="delete" value="Submit"></td>
</tr>
</table>
</BODY>
</HTML>
254
