HTML Code:
<td><a onClick="return confirm('Are you sure you want to delete this record?')"
href='view-emp.php?A=<?php echo $rec[0] ?>'><?php echo " $rec[2]" ?></a></td>
PHP Code:
<?php
if(isset($_GET['A']))
{
$P = $_GET['A'];
$A = mysql_connect("localhost","root","") or die ("error in sql connection");
mysql_select_db("payroldb",$A) or die ("error in database");
mysql_query("delete from tblemp Where ID=$P",$A) or die ("error in query");
mysql_close($A);
}
?>
No comments:
Post a Comment