search.php

一个小型图书管理系统

<?
//####################用户查询库中的书##########################
include "config.php";
include "header.php";
include "auth.php";
 ?> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
<?if($search){
if(empty($book_name)&&empty($pub_addr)&&empty($pub_addr)&&empty($sort_id)&&empty($author)&&empty($author)){
	echo "请输入查询条件0"; 
	exit;
	}
$sqlbook="select * from $book_table where 1=1";
if($book_name) {$sqlbook=$sqlbook." and book_name like '%$book_name%' ";} 
if($author) {$sqlbook=$sqlbook." and author like '%$author%'";} 
if($pub_addr) {$sqlbook=$sqlbook." and pub_addr like '%$pub_addr%'";}
if($sort_id){$sqlbook=$sqlbook." and sort_id='%$sort_id%'";}
$query=mysql_query($sqlbook); 
 $n=0; 
 $row=mysql_fetch_array($query);
   $count=mysql_num_rows($query);
      if(empty($offset))
              {$offset=0;}
	?>
		<table width="770" border="0" cellspacing="1" cellpadding="0" bgcolor="#333333" align="center">
  <tr> 
    <td bgcolor="#FFFFFF"> 
      <div align="center" class="title">书名</div>
    </td>
    <td width=100 bgcolor="#FFFFFF"> 
      <div align="center" class="title">作者</div>
    </td>
    <td bgcolor="#FFFFFF"> 
      <div align="center" class="text"> 
        <p>出版社</p>
      </div>
    </td>
    <td width=65 bgcolor="#FFFFFF"> 
      <div align="center" class="title">出版日期</div>
    </td>
    <td width="5%" bgcolor="#FFFFFF"> 
      <div align="center" class="title">价格(元)</div>
    </td>
    <td width="9%" bgcolor="#FFFFFF"> 
      <div align="center" class="title">分类号</div>
    </td>
    <td width=30 bgcolor="#FFFFFF" class="title"> 
      <div align="center">册数</div>
    </td>
    <td width=30 bgcolor="#FFFFFF" class="title">
      <div align="center">状态</div>
    </td>
    <td width="9%" bgcolor="#FFFFFF" class="title">
      <div align="center">借书</div>
    </td>
  </tr>
		<?
   $query=mysql_query($sqlbook." order by book_id desc limit $offset,$list_num") or die ("fail");
   while($row=mysql_fetch_array($query)){
        if(($n%2)!='0'){
 	  echo "<tr bgcolor=#FFFFff>";}
	  else{
	  echo "<tr bgcolor=#E4E4E4>";
	  }
     echo"<td   height='15'> 
		<div align='center' class='text'>".$row['book_name']."</div></td>
    <td width=100  height='15' class='text'> <div align='center'>".$row['author']."</div></td>
    <td   height='15' class='text'> <div align='center'>".$row['pub_addr']."</div></td>
    <td width=65  height='15' class='text'> <div align='center'>".$row['pub_date']."</div></td>
    <td width='5%'  height='15' class='text'><div align='center'>".$row['price']."</div></td>
    <td width='9%'  height='15' class='text'> <div align='center'>".$row['sort_id']."</div></td>
    <td  height='15' class='text'> <div align='center'>".$row['volumes']."</div></td>
    <td width=30  height='15' class='text'> <div align='center'>".$row['status ']."</div></td>
    <td   height='15' class='text'><div align='center'><a href=borrow.php?book_name=".$row['book_name'].">借书</a></div></td>
  </tr> ";
   $n++;
   }
 ?>
</table>
<?
    $pages=ceil($count/$list_num);
echo "<table width=770 border=0 cellspacing=0 cellpadding=0 align=center class='text'>
          <tbody> 
          <tr> 
     <td width='159'><font color='#ff0000'>目前共有