bookQuery.php ( File view )

  • By shaomengjing 2014-01-04
  • View(s):1560
  • Download(s):12
  • Point(s): 3
			<?php session_start();?>
<html>
<head>
<title>图书馆管理系统</title>
<link href="CSS/style.css" rel="stylesheet">
</head>
<body>
<table width="776" border="0" align="center" cellpadding="0" cellspacing="0" class="tableBorder">
  <tr>
    <td>
	<?php include ("navigation.php"); ?>
	</td>
	</tr>
	<td>
	<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top" bgcolor="#FFFFFF"><table width="99%" height="510"  border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="tableBorder_gray">
  <tr>
    <td height="510" align="center" valign="top" style="padding:5px;"><table width="98%" height="487"  border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td align="center" valign="top">
	      <table width="723" height="37" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td background="Images/dangan.gif">&nbsp;</td>
            </tr>
          </table>
	      <form  name="form1" method="post" action="">
	        <table width="98%" height="38"  border="1" cellpadding="1" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#9ECFEE" class="tableBorder_gray">
  <tr>
    <td align="center">
&nbsp;<img src="Images/search.gif" width="37" height="29"></td>
    <td>&nbsp;&nbsp;请选择查询依据:
      <select name="f" class="wenbenkuang" id="f">
        <option value="<?php echo "b.barcode";?>">条形码</option>
        <option value="<?php echo "t.typename";?>">类别</option>
        <option value="<?php echo "b.bookname";?>" selected>书名</option>
        <option value="<?php echo "b.author";?>">作者</option>
        <option value="<?php echo "p.pubname";?>">出版社</option>
        <option value="<?php echo "c.name";?>">书架</option>
                  </select>
      <input name="key1" type="text" id="key1" size="50">
      <input name="Submit" type="submit" class="btn_grey" value="查询"></td>
  </tr>
</table>
</form>
<?php 
include("conn/conn.php");
$query=mysql_query("select b.*,c.name as bookcasename,p.pubname,t.typename from tb_bookinfo b left join tb_bookcase c on b.bookcase=c.id join tb_publishing p on b.ISBN=p.ISBN join tb_booktype t on b.typeid=t.id");
$result=mysql_fetch_array($query);
if($result==false){

?>
          <table width="100%" height="30"  border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td height="36" align="center">暂无图书信息!</td>
            </tr>
          </table>
<?php
 
}
 else{

 ?>		  
  <table width="98%"  border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#D2E3E6" bordercolorlight="#FFFFFF">
  <tr align="center" bgcolor="#D0E9F8">
    <td width="13%">条形码</td>  
    <td width="26%">图书名称</td>
    <td width="15%">图书类型</td>
    <td width="14%">出版社</td>
    <td width="12%">书架</td>
  </tr>
<?php
if($_POST[key1]==""){

do{

?>
  <tr>
    <td style="padding:5px;">&nbsp;<?php echo $result[barcode];?></td>  
    <td style="padding:5px;"><a href="book_look.php?id=<?php echo $result[id]; ?>"><?php echo $
...
...
(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

bookQuery.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