bookBorrow.php ( File view )

  • By shaomengjing 2014-01-04
  • View(s):1560
  • Download(s):12
  • Point(s): 3
			<?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;"> &nbsp; <span class="word_orange">&nbsp;当前位置:图书借还 &gt; 图书借阅&gt;&gt;&gt; </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">&nbsp;</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];?>">
                            &nbsp;
                              <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">姓&nbsp;&nbsp;&nbsp;&nbsp;名:
                              <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>性&nbsp;&nbsp;&nbsp;&nbsp;别:
                              <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">
                              册
                            &nbsp;</td>
                          </tr>
                      </table></td>
                    </tr>
                </table></td>
            </tr>
                 <tr>
                   <td height="32">&nbsp;添加的依据:
                     <input name="f" type="radio" class="noborder" value="barcode" checked>
                     图书条形码 &nbsp;&nbsp;
                     <input name="f" type="radio" class="noborder" value="bookname">
  图书名称&nbsp;&nbsp;
  <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>
<?php
$readerid=$info[id];

...
...
(Please download the complete source code to view)
			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 3

Download
0 lines left, continue to read
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
01.97 kB
.project396.00 B2013-03-18|17:49
book.php3.06 kB2013-03-26|11:18
bookBack.php6.32 kB2013-03-18|17:49
bookBack_ok.php374.00 B2013-03-18|17:49
bookBorrow.php9.91 kB2013-03-18|17:49
bookcase.php2.45 kB2013-03-26|12:43
bookcase_add.php1.60 kB2013-03-18|17:49
bookcase_add_ok.php421.00 B2013-03-18|17:49
bookcase_del.php401.00 B2013-03-18|17:49
bookQuery.php4.54 kB2013-03-18|17:49
bookRenew.php6.61 kB2013-03-18|17:49
book_add.php4.29 kB2013-03-18|17:49
book_del.php221.00 B2013-03-18|17:49
book_look.php3.56 kB2013-03-18|17:49
book_Modify.php5.38 kB2013-03-18|17:49
book_modify_ok.php806.00 B2013-03-18|17:49
book_ok.php769.00 B2013-03-18|17:49
borrowQuery.php6.36 kB2013-03-18|17:49
borrow_oncemore.php568.00 B2013-03-18|17:49
bremind.php2.71 kB2013-03-18|17:49
check_login.php182.00 B2013-03-18|17:54
chklogin.php1.15 kB2013-03-19|09:37
01.97 kB
conn.php231.00 B2013-03-18|17:49
copyright.php651.00 B2013-03-23|10:10
01.97 kB
style.css2.95 kB2013-03-18|17:49
01.97 kB
01.97 kB
db.opt65.00 B2013-03-18|17:49
tb_bookcase.frm8.38 kB2013-03-18|17:49
tb_bookcase.MYD180.00 B2013-03-18|17:49
tb_bookcase.MYI2.00 kB2013-03-18|17:49
tb_bookinfo.frm8.79 kB2013-03-18|17:49
tb_bookinfo.MYD580.00 B2013-03-18|17:49
tb_bookinfo.MYI2.00 kB2013-03-18|17:49
tb_booktype.frm8.42 kB2013-03-18|17:49
tb_booktype.MYD104.00 B2013-03-18|17:49
tb_booktype.MYI2.00 kB2013-03-18|17:49
tb_borrow.frm8.57 kB2013-03-18|17:49
tb_borrow.MYD448.00 B2013-03-18|17:49
tb_borrow.MYI2.00 kB2013-03-18|17:49
tb_library.frm8.63 kB2013-03-18|17:49
tb_library.MYD148.00 B2013-03-18|17:49
tb_library.MYI2.00 kB2013-03-18|17:49
tb_manager.frm8.41 kB2013-03-18|17:49
tb_manager.MYD208.00 B2013-03-18|17:49
tb_manager.MYI2.00 kB2013-03-18|17:49
tb_parameter.frm8.42 kB2013-03-18|17:49
tb_parameter.MYD13.00 B2013-03-18|17:49
tb_parameter.MYI2.00 kB2013-03-18|17:49
tb_publishing.frm8.39 kB2013-03-18|17:49
tb_publishing.MYD76.00 B2013-03-18|17:49
tb_publishing.MYI1.00 kB2013-03-18|17:49
tb_purview.frm8.54 kB2013-03-18|17:49
tb_purview.MYD50.00 B2013-03-18|17:49
tb_purview.MYI2.00 kB2013-03-18|17:49
tb_reader.frm8.80 kB2013-03-18|17:49
tb_reader.MYD1.01 kB2013-03-18|17:49
tb_reader.MYI2.00 kB2013-03-18|17:49
tb_readertype.frm8.42 kB2013-03-18|17:49
tb_readertype.MYD168.00 B2013-03-18|17:49
tb_readertype.MYI2.00 kB2013-03-18|17:49
01.97 kB
banner.jpg29.91 kB2013-03-21|13:47
bg.jpg32.28 kB2013-03-21|13:42
bg_line.gif1.74 kB2013-03-18|17:49
bookborr.gif5.50 kB2013-03-18|17:49
bookborrow.gif3.82 kB2013-03-18|17:49
bookgh.gif5.50 kB2013-03-18|17:49
bookxj.gif5.54 kB2013-03-18|17:49
borrow_fg.gif959.00 B2013-03-18|17:49
dangan.gif3.93 kB2013-03-18|17:49
item_out.gif1.78 kB2013-03-18|17:49
item_over.gif1.97 kB2013-03-18|17:49
line.gif1.69 kB2013-03-18|17:49
line2.gif678.00 B2013-03-18|17:49
main_booksort.gif7.72 kB2013-03-18|17:49
main_booksort_1.gif179.00 B2013-03-18|17:49
main_booksort_2.gif674.00 B2013-03-18|17:49
menu_line.gif1.20 kB2013-03-18|17:49
menu_line1.gif1.18 kB2013-03-18|17:49
navigation_bg.gif133.00 B2013-03-18|17:49
reader_checkbg.jpg15.22 kB2013-03-18|17:49
search.gif1.34 kB2013-03-18|17:49
subBG.jpg31.22 kB2013-03-18|17:49
Thumbs.db53.00 kB2013-03-18|17:49
Top_flag.gif48.00 B2013-03-18|17:49
index.php3.33 kB2013-03-18|17:49
01.97 kB
function.js1.41 kB2013-03-18|17:49
menu.JS8.07 kB2013-03-18|17:49
library_modify.php3.76 kB2013-03-18|17:49
library_ok.php772.00 B2013-03-18|17:49
login.php2.98 kB2013-03-26|12:49
manager.php3.67 kB2013-03-18|17:49
manager_add.php2.29 kB2013-03-18|17:49
manager_del.php402.00 B2013-03-18|17:49
manager_modify.php3.06 kB2013-03-18|17:49
manager_modifyok.php893.00 B2013-03-18|17:49
manager_ok.php457.00 B2013-03-18|17:49
navigation.php2.45 kB2013-03-21|13:48
parameterModify_ok.php521.00 B2013-03-18|17:49
parameter_modify.php2.24 kB2013-03-18|17:49
pwd_Modify.php3.32 kB2013-03-18|17:49
pwd_ok.php275.00 B2013-03-18|17:49
reader.php3.06 kB2013-03-18|17:49
readerType.php2.30 kB2013-03-18|17:49
readerType_add.php1.96 kB2013-03-18|17:49
readerType_del.php641.00 B2013-03-18|17:49
readerType_ok.php457.00 B2013-03-18|17:49
reader_add.php4.43 kB2013-03-18|17:49
reader_del.php357.00 B2013-03-18|17:49
reader_info.php3.93 kB2013-03-18|17:49
reader_modify.php5.26 kB2013-03-18|17:49
reader_modifyok.php714.00 B2013-03-18|17:49
reader_ok.php954.00 B2013-03-18|17:49
safequit.php96.00 B2013-03-18|17:49
...
Sponsored links

bookBorrow.php (215.36 kB)

Need 3 point
Your Point(s)

Your Point isn't enough.

Get point immediately by PayPal

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more point

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D