图书管理系统关于图书借阅源代码
<?php session_start();?>
<html>
<head>
<link href="CSS/style.css" rel="stylesheet">
[removed]
function checkreader(form){
if(form.barcode.value==""){
alert("请输入读者条形码!");form.barcode.focus();return;
}
form.submit();
}
function checkbook(form){
if(form.barcode.value==""){
alert("请输入读者条形码!");form.barcode.focus();return;
}
if(form.inputkey.value==""){
alert("请输入查询关键字!");form.inputkey.focus();return;
}
if(form.number.value-form.borrowNumber.value<=0){
alert("您不能再借阅其他图书了!");return;
}
form.submit();
}
[removed]
</head>
<body>
<?php include("navigation.php");?>
当前位置：图书借还 > 图书借阅>>>
<?php
include("conn/conn.php");
//$barcode=$_POST[barcode];
$sql=mysql_query("select r.*,t.name as typename,t.number from tb_reader r left join tb_readerType t on r.typeid=t.id where r.barcode='$barcode'");
//$sql=mysql_query("select r.*,t.name as typename,t.number,book.bookname,book.price,borr.borrowTime,borr.backTime,pub.pubname,bc.name as bookcase from tb_reader r left join tb_readerType t on r.typeid=t.id join tb_borrow as borr on borr.readerid=r.id join tb_bookinfo as book on book.id=borr.bookid join tb_publishing as pub on book.ISBN=pub.ISBN join tb_bookcase as bc on book.bookcase=bc.id where r.barcode='$barcode'");
$info=mysql_fetch_array($sql);
?>
| |
