php问题!新手求解!!谢谢啦。
<?php session_start();?>
<html>
<head>
<link href="CSS/style.css" rel="stylesheet">
<script language="javascript">
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();
}
</script>
</head>
<body>
<?php include("navigation.php");?>
<table width="776" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td valign="top" bgcolor="#FFFFFF"><table width="100%" height="509" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="tableBorder_gray">
<tr>
<td align="left" valign="top" style="padding:5px;"> <span class="word_orange"> 当前位置:图书借还 > 图书借阅>>> </span> <table width="100%" border="0" cellpadding="0" cellspacing="0">
<?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);
?>
<form name="form1" method="post" action="">
<tr>
<td height="72" align="center" valign="top" background="Images/main_booksort_1.gif" bgcolor="#F8BF73">
<br>
<table width="96%" border="0" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#9ECFEE" class="tableBorder_grey">
<tr>
<td height="33" valign="top" background="Images/bookborr.gif">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="33" background="Images/bookborr.gif"> </td>
</tr>
</table>
<table width="100%" height="21" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="24%" height="18" style="padding-left:7px;padding-top:7px;"><img src="Images/bg_line.gif" width="132" height="20"></td>
<td width="76%" style="padding-top:7px;">读者条形码:
<input name="barcode" type="text" id="barcode" size="24" value="<?php echo $info[barcode];?>">
<input name="Button" type="button" class="btn_grey" value="确定" onClick="checkreader(form1)"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="13" align="left" style="padding-left:7px;"><hr width="90%" size="1"></td>
</tr>
<tr>
<td align="center"><table width="96%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="27">姓 名:
<input name="readername" type="text" id="readername" value="<?php echo $info[name];?>">
<input name="readerid" type="hidden" id="readerid" value="<?php echo $info[id];?>"></td>
<td>性 别:
<input name="sex" type="text" id="sex" value="<?php echo $info[sex];?>"></td>
<td>读者类型:
<input name="readerType" type="text" id="readerType" value="<?php echo $info[typename];?>"></td>
</tr>
<tr>
<td height="27">证件类型:
<input name="paperType" type="text" id="paperType" value="<?php echo $info[paperType];?>"></td>
<td>证件号码:
<input name="paperNo" type="text" id="paperNo" value="<?php echo $info[paperNO];?>"></td>
<td>可借数量:
<input name="number" type="text" id="number" value="<?php echo $info[number];?>" size="17">
册
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="32"> 添加的依据:
<input name="f" type="radio" class="noborder" value="barcode" checked>
图书条形码
<input name="f" type="radio" class="noborder" value="bookname">
图书名称
<input name="inputkey" type="text" id="inputkey" size="50">
<input name="Submit" type="button" class="btn_grey" id="Submit" onClick="checkbook(form1);" value="确定">
<input name="operator" type="hidden" id="operator" value="<?php echo $_SESSION[adminname];?>">
<input name="Button2" type="button" class="btn_grey" id="Button2" onClick="window.location.href='bookBorrow.php'" value="完成借阅"> </td>
</tr>
<tr>
<td valign="top" bgcolor="#D2E5F1" style="padding:5px"><table width="99%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#9ECFEE" bgcolor="#FFFFFF">
<tr align="center" bgcolor="#E2F4F6">
<td width="29%" height="25">图书名称</td>
<td width="12%">借阅时间</td>
<td width="14%">应还时间</td>
<td width="17%">出版社</td>
<td width="14%">书架</td>
<td colspan="2">定价(元)</td>
</tr>
先给代码的前半段,下面给后半段
请问这段代码有没有问题?为什么不能实现正确借书?
PS:1,在登录界面填写读者条形码的时候,不管这个读者有没有,只要书的条形码存在,系统就显示借书成功,怎么回事?
2,系统显示借书成功后,mysql里没有借书记录,在系统的借阅查询里也查不到借书记录,那里出问题啦?
在线等解答,好心人帮忙解决!!!谢谢啦!