Employee父表中的主键是EmployeeNo,EmployeeOther表的主键EmployeeNo也是外键(参照Employee表的主键),
现要做个删除功能,我想在不改数据库约束条件的情况下,先删除子表中的相关信息,再删除父表的相关信息,不知道这样行不行呢?执行的时候提示删除记录成功了,但再查询的时候那记录还是存在请问这是为什么呢?
<?php
$EmployeeNo=$_GET["EmployeeNo"];
$conn=OCILogon("howl","howl");
$sql ="delete from EmployeeOther where EmployeeNo='".$EmployeeNo."'";
$stmt = OCIParse($conn, $sql);
if(OCIExecute($stmt)!=1)
{ echo "<script language='javascript'>";
echo "alert('从EmployeeOther表删除失败!'); self.location='admin.php'";
echo "</script>";
exit;}
$sql ="delete from Employee where EmployeeNo='".$EmployeeNo."'";
$stmt = OCIParse($conn, $sql);
if(OCIExecute($stmt)!=1)
{ echo "<script language='javascript'>";
echo "alert('从Employee表删除失败!'); self.location='admin.php'";
echo "</script>";
exit;
}
$sql ="commit";
$stmt = OCIParse($conn, $sql);
if(OCIExecute($stmt)!=1)
{echo "<script language='javascript'>";
echo "alert('提交删除事务失败!'); self.location='admin.php'";
echo "</script>";
exit;
}else{
echo "<script language='javascript'>";
echo "alert('删除成功!'); self.location='admin.php'";
echo "</script>";}?>
现要做个删除功能,我想在不改数据库约束条件的情况下,先删除子表中的相关信息,再删除父表的相关信息,不知道这样行不行呢?执行的时候提示删除记录成功了,但再查询的时候那记录还是存在请问这是为什么呢?
<?php
$EmployeeNo=$_GET["EmployeeNo"];
$conn=OCILogon("howl","howl");
$sql ="delete from EmployeeOther where EmployeeNo='".$EmployeeNo."'";
$stmt = OCIParse($conn, $sql);
if(OCIExecute($stmt)!=1)
{ echo "<script language='javascript'>";
echo "alert('从EmployeeOther表删除失败!'); self.location='admin.php'";
echo "</script>";
exit;}
$sql ="delete from Employee where EmployeeNo='".$EmployeeNo."'";
$stmt = OCIParse($conn, $sql);
if(OCIExecute($stmt)!=1)
{ echo "<script language='javascript'>";
echo "alert('从Employee表删除失败!'); self.location='admin.php'";
echo "</script>";
exit;
}
$sql ="commit";
$stmt = OCIParse($conn, $sql);
if(OCIExecute($stmt)!=1)
{echo "<script language='javascript'>";
echo "alert('提交删除事务失败!'); self.location='admin.php'";
echo "</script>";
exit;
}else{
echo "<script language='javascript'>";
echo "alert('删除成功!'); self.location='admin.php'";
echo "</script>";}?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货