hi i m trying to create a delete conformation box using php in my website but im getting some issues . if i click cancel button also its deleting the row in my database. The index page is designed in jquery
this is the php code which i have used for delete option?
<?php
echo "<script language='javascript' type='text/javascript'>var x=confirm('Successfully Deleted!')</script>";
if(x==true)
{
echo"deleted";
include ("dbconnection.php");
$pid=$_GET['pid'];
$sql="DELETE FROM voters where id=$pid";
$res = mysql_query($sql) or die(mysql_error());
echo "<script language='javascript' type='text/javascript'>window.open('index.php','_self')</script>";
}
else
{
echo"cancelled";
}
?>
this is my jquery code...
$str.="<thead><tr><th>ID</th><th>Card No</th><th>Name</th><th>Mob_num</th><th>Email</th><th>Action</th></tr></thead><tbody>";
while($row = mysql_fetch_array($res)){
$str.="<tr><td><center>".$row['id']."</center></td>";
$str.="<td>".$row['vcardno']."</td>";
$str.="<td>".$row['vname']."</td>";
$str.="<td>".$row['mob_num']."</td>";
$str.="<td>".$row['email']."</td>";
$str.="<td><center><a class='fancybox fancybox.ajax' href='viewstudent.php?ppid=".$row['id']."' onclick='return update()'><img src = 'images/view.png' height='30' width='30' alt = 'view' title = 'view'/></a><a class='fancybox fancybox.ajax' href='updatestudent.php?ppid=".$row['id']."' onclick='return update()'><img src = 'images/edit-icon.png' height='30' width='30' alt = 'edit' title = 'edit'/></a><a href='delete1.php?pid=".$row['id']."' onclick='return deleteItem()' ><img src = 'images/edit_delete.png' height='30' width='30' alt = 'delete' title = 'delete'/></a></center></td></tr>";
}
thanks..