我想删除我的 mysql 表记录,但它不起作用,带有 onclick 弹出窗口


I want to DELETE my mysql table record, but it doesn't work, with onclick popup

我的代码直接转到"delete_product.php"并删除记录,不显示弹出窗口。

 echo "<td><a href='delete_product.php?id=".$sno."' onClick='return confirm('Do you want to delete?');'>Delete</a></td>";   

引号有问题,内部引号需要通过反斜杠转义。

onClick='return confirm(''Do you want to delete?'');'

尝试用 html 而不是用 php 编写它

?>
<td><a href="delete_product.php?id=<?php echo $sno?>" onClick="return confirm('Do you want to delete?');">Delete</a></td>
<?php   

你可以用于链接

<a href=delete_product.php?id=$sno>Delete</a>

用于delete_product.php删除

$delete_id=$_GET['id']; 
mysqli_query($con,"DELETE FROM table_name WHERE id='$delete_id'") or die(mysql_error());