<table width="700" border="0">
<tr>
<td align="right" > 物料名称:</td>
<td><input name="txtName" type="text" id="txtName" value="<?=$_REQUEST['txtName']?>" /></td>
<td align="right">入库类别:</td>
<td> <input name="txtCate" type="text" id="txtCate" size="10" />
<select name="sltCategory" id="sltCategory" onchange="document.getElementById('txtCate').value=document.getElementById('sltCategory').value" >
<option value="0,1" >全部</option>
<option value="0" >采购</option>
<option value="1" >归还</option>
</select></td>
<td width="50" align="right"><input name="btnSearch" type="submit" id="btnSearch" value="查询" /></td>
</tr>
<tr>
<td align="right" valign="top">开始时间:</td>
<td><input name="txtStDate" type="text" id="txtStDate" size="10" /><br />
<select name="sltstYear" id="sltstYear">
<?php
sltDate(2010,2020);
?>
</select>
年
<select name="sltstMonth" id="sltstMonth" onchange="document.getElementById('txtStDate').value=document.getElementById('sltstYear').value+document.getElementById('sltstMonth').value">
<?php sltDate(1,12);
?>
</select>
月</td>
<td align="right" valign="top">结束时间:</td>
<td> <input name="txtEdDate" type="text" id="txtEdDate" size="10" value="<?=date("Ym",time())?>" /><br />
<select name="sltedYear" id="sltedYear" >
<?php
sltDate(2010,2020);
?>
</select>
年
<select name="sltedMonth" id="sltedMonth" onchange="document.getElementById('txtEdDate').value=document.getElementById('sltedYear').value+document.getElementById('sltedMonth').value">
<?php sltDate(1,12);
?>
</select>
月</td>
<td></td>
</tr>
</table>
<?php
$name = $_REQUEST['txtName'];
$startDate = $_REQUEST['txtStDate'];
$endDate = $_REQUEST['txtEdDate'];
$category = $_REQUEST['txtCate'];
if($name != null){
$sql = "select * from material m, materialinstorage mis
where m.Mat_name like '%$name%'
and (left(MIS_date,6)<='$endDate' and left(MIS_date,6)>='$startDate')
and MIS_category in ($category)
and m.Mat_id = mis.Mat_id
order by MIS_date desc";
$page = page($db,$sql,1,$class);
while($row = mysql_fetch_array($page[0])){...
?>等于现在是有四个空,我想随便填写一个到四个空的内容,然后点击搜索,下面列出搜索的内容
可是现在分页后,点击下一页后,$category的数据就是得不到,导致查询的sql语句有问题了,这个应该怎么办
<tr>
<td align="right" > 物料名称:</td>
<td><input name="txtName" type="text" id="txtName" value="<?=$_REQUEST['txtName']?>" /></td>
<td align="right">入库类别:</td>
<td> <input name="txtCate" type="text" id="txtCate" size="10" />
<select name="sltCategory" id="sltCategory" onchange="document.getElementById('txtCate').value=document.getElementById('sltCategory').value" >
<option value="0,1" >全部</option>
<option value="0" >采购</option>
<option value="1" >归还</option>
</select></td>
<td width="50" align="right"><input name="btnSearch" type="submit" id="btnSearch" value="查询" /></td>
</tr>
<tr>
<td align="right" valign="top">开始时间:</td>
<td><input name="txtStDate" type="text" id="txtStDate" size="10" /><br />
<select name="sltstYear" id="sltstYear">
<?php
sltDate(2010,2020);
?>
</select>
年
<select name="sltstMonth" id="sltstMonth" onchange="document.getElementById('txtStDate').value=document.getElementById('sltstYear').value+document.getElementById('sltstMonth').value">
<?php sltDate(1,12);
?>
</select>
月</td>
<td align="right" valign="top">结束时间:</td>
<td> <input name="txtEdDate" type="text" id="txtEdDate" size="10" value="<?=date("Ym",time())?>" /><br />
<select name="sltedYear" id="sltedYear" >
<?php
sltDate(2010,2020);
?>
</select>
年
<select name="sltedMonth" id="sltedMonth" onchange="document.getElementById('txtEdDate').value=document.getElementById('sltedYear').value+document.getElementById('sltedMonth').value">
<?php sltDate(1,12);
?>
</select>
月</td>
<td></td>
</tr>
</table>
<?php
$name = $_REQUEST['txtName'];
$startDate = $_REQUEST['txtStDate'];
$endDate = $_REQUEST['txtEdDate'];
$category = $_REQUEST['txtCate'];
if($name != null){
$sql = "select * from material m, materialinstorage mis
where m.Mat_name like '%$name%'
and (left(MIS_date,6)<='$endDate' and left(MIS_date,6)>='$startDate')
and MIS_category in ($category)
and m.Mat_id = mis.Mat_id
order by MIS_date desc";
$page = page($db,$sql,1,$class);
while($row = mysql_fetch_array($page[0])){...
?>等于现在是有四个空,我想随便填写一个到四个空的内容,然后点击搜索,下面列出搜索的内容
可是现在分页后,点击下一页后,$category的数据就是得不到,导致查询的sql语句有问题了,这个应该怎么办
解决方案 »
- rails的问题
- wince 窗体全屏显示问题
- 关于创建数据库函数MYSQL_create_db()出现未定义数据函数的错误?
- 国外网站信用卡支付流程?
- 【向MSN、QQ好友发送邀请】功能
- mysql这么慢???select * from list ORDER BY id DESC LIMIT 49990,10 竟然需要7秒??!!
- linux中的上传文件权限不足,怎么办?
- 高分 征 求 一 句 SQL !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 问一SQL查询
- 有人想收个徒弟吗???
- 一个很奇怪的PHP问题,可能是环境,可能是版本,请大家指教
- zend studio 8.0使用问题,请指教
<input type="hidden" name="gpparam" value="<?php echo base64_encode(serialize(array_merge($_GET, $_POST)));?>">然后页面处理时先从gpparam中释放参数,再查page
echo $class."<br>";
if($_REQUEST['txtName']&&$_GET['action']=="search"){
$name = $_REQUEST['txtName'];
$startDate = $_REQUEST['txtStDate'];
$endDate = $_REQUEST['txtEdDate'];
$category = $_REQUEST['txtCate'];
//sql语句
然后再sql语句查询,分页
点击下一页的时候$txtCate的数据就是传不到,前三个数据都有,这是为什么啊?哪里写错了嘛?