tushuxinxi_list2.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php
include_once 'conn.php';

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>图书信息</title><script language="javascript" src="js/Calendar.js"></script><link rel="stylesheet" href="css.css" type="text/css">
</head>

<body>

<p>借阅统计：</p>
<form id="form1" name="form1" method="post" action="">
  搜索: 图书代码：<input name="tushudaima" type="text" id="tushudaima" /> 图书名称：<input name="tushumingcheng" type="text" id="tushumingcheng" /> 图书分类：<select name='tushufenlei' id='tushufenlei'><option value="">所有</option><?php
getoption("shangpinleibie", "leibie");
?></select></select>
  <input type="submit" name="Submit" value="查找" style='border:solid 1px #000000; color:#666666' />
</form>
<table width="98%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="f0f0f0" style="border-collapse:collapse">  
  <tr>
    <td  bgcolor="#CCFFFF">序号</td>
    <td bgcolor='#CCFFFF'>图书代码</td><td bgcolor='#CCFFFF'>图书名称</td><td bgcolor='#CCFFFF'>图书分类</td>
    <td bgcolor='#CCFFFF'>第一季度</td>
    <td bgcolor='#CCFFFF'>第二季度</td>
    <td bgcolor='#CCFFFF'>第三季度</td>
    <td bgcolor='#CCFFFF'>第四季度</td>
    <td bgcolor='#CCFFFF'>总量</td>
  </tr>
  <?php
$sql = "select * from tushuxinxi where 1=1";

if ($_POST["tushudaima"] != "") {
    $nreqtushudaima = $_POST["tushudaima"];
    $sql            = $sql . " and tushudaima like '%$nreqtushudaima%'";
}
if ($_POST["tushumingcheng"] != "") {
    $nreqtushumingcheng = $_POST["tushumingcheng"];
    $sql                = $sql . " and tushumingcheng like '%$nreqtushumingcheng%'";
}
if ($_POST["tushufenlei"] != "") {
    $nreqtushufenlei = $_POST["tushufenlei"];
    $sql             = $sql . " and tushufenlei like '%$nreqtushufenlei%'";
}
if ($_POST["tushuzuozhe"] != "") {
    $nreqtushuzuozhe = $_POST["tushuzuozhe"];
    $sql             = $sql . " and tushuzuozhe like '%$nreqtushuzuozhe%'";
}
if ($_POST["chubanshe"] != "") {
    $nreqchubanshe = $_POST["chubanshe"];
    $sql           = $sql . " and chubanshe like '%$nreqchubanshe%'";
}
if ($_POST["chubanriqi1"] != "") {
    $nreqchubanriqi1 = $_POST["chubanriqi1"];
    $sql             = $sql . " and chubanriqi >= '$nreqchubanriqi1'";
}
if ($_POST["chubanriqi2"] != "") {
    $nreqchubanriqi2 = $_POST["chubanriqi2"];
    $sql             = $sql . " and chubanriqi <= '$nreqchubanriqi2'";