9.5 MySQL事务 实例265

<?php
include_once("conn.php");
$sql=$conn->query("select * from tb_stu"); 
$info=$sql->fetch_array(MYSQLI_ASSOC);
if($info==NULL)
{
echo "暂无学生信息!";
} 
else
{
do
{
?> 
<tr>
<td height="25" bgcolor="#FFFFFF"><div align="center">

<?php echo $info[sname];?></div></td>
<td height="25" bgcolor="#FFFFFF"><div align="center">

<?php echo $info[sno];?></div></td>
<td height="25" bgcolor="#FFFFFF"><div align="center">

<?php echo $info[sage];?></div></td>
<td height="25" bgcolor="#FFFFFF"><div align="center">

<?php echo $info[saddress];?></div></td>
<td height="25" bgcolor="#FFFFFF"><div align="center">

<?php echo $info[ssfzh];?></div></td>
<td bgcolor="#FFFFFF"><div align="center">

<a href="javascript:if(window.confirm('确定删除该学生信息么?')==true) 

{window.location.href='delete.php?id=<?php echo $info[id];?>';}">删除</a></div></td>
</tr>
<?php
}
while($info=$sql->fetch_array(MYSQLI_ASSOC));
}
?>

<a href="javascript:if(window.confirm('确定删除该学生信息么?')==true)
{window.location.href='delete.php?id=<?php echo $info[id];?>';}">删除</a>

<?php
$id=$_GET[id];
include_once("conn.php");
$conn->autocommit(false);
if(!$conn->query("delete from tb_sco where id='".$id."'"))
{
$conn->rollback();
}
if(!$conn->query("delete from tb_stu where id='".$id."'"))
{
$conn->rollback();
}
$conn->commit();
$conn->autocommit(true);
echo "<script>window.location.href='index.php';</script>";
?>