代码如下:
<?php
session_start();
include "../inc/chec.php";
include "../conn/conn.php";
include "../inc/func.php";
?>
<link href="../css/style.css" rel="stylesheet" />
<script src="../admin/js/admin_js.js"></script>
<table width="1050" border="0" cellpadding="0" cellspacing="0" style="border: 1px solid #9CBED6; margin-top:15px;">
<tr>
<td align="center" >
<form name="found" method="post" action="found_staf_chk.php">
<table cellpadding="0" cellspacing="0" border = "0" >
<tr>
<td width="80">查找条件:</td>
<td width="37"><select name="u_field">
<option value="name">品名</option>
<option value="lot_number">批号</option>
<option value="r_data">入库日期</option>
<option value="supplier">供应商</option>
</select> </td>
<td width="140"><input type="text" name="u_key" size="20"/></td>
<td width="42"><input type="submit" value="查找" onclick="return chk_null();" /></td>
<td width="65" align="center" valign="middle"><a href="show_staf.php">显示全部</a></td>
</tr>
</table>
</form>
<form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0" width="1050" class="table2">
<tr>
<td width="75" height="25" align="center" valign="middle" scope="col">ID</td>
<td width="75" height="25" align="center" valign="middle" scope="col">品名</td>
<td width="125" height="25" align="center" valign="middle" scope="col">批号</td>
<td width="75" height="25" align="center" valign="middle" scope="col">入库日期</td>
<td width="75" height="25" align="center" valign="middle" scope="col">供应商</td>
<td width="75" height="25" align="center" valign="middle" scope="col">库管员</td>
<td width="75" height="25" align="center" valign="middle" scope="col">经手人</td>
<td width="75" height="25" align="center" valign="middle" scope="col">备注</td>
<td width="75" height="25" align="center" valign="middle" scope="col">操作</td>
</tr>
<?php
$str1=$_POST[u_field];
$str2=$_POST[u_key];
$sql=mysql_query("select count(*) as total from ruku where $str1 like '%$str2%' ",$conn) ;
$info=mysql_fetch_array($sql) ; //这是46行
$total=$info[total];
if($total==0)
{
echo "<tr align='center'><td > >没有找到相关记录</td></tr>";
}
else
{
$pagesize=2;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
}
$sql1=mysql_query( "select id,name,lot_number,r_data,supplier,custos,deal_name,comment from ruku where $str1 like '%$str2%' limit " .($page-1)*$pagesize.",$pagesize ",$conn) ;
while($rows = mysql_fetch_row($sql1)){ //这是70行
echo "<tr>";
for($i = 0; $i < count($rows); $i++){
if ($rows[$i] == "")
echo "<td height='30'> </td>";
else
echo "<td height='30' align='center' valign='middle'> ".$rows[$i]." </td>";
}
echo "<td><a href='modify_staf.php?id=".$rows[0]."'>修改</a>/<a href='del_staf_chk.php?id=".$rows[0]."'onclick='return del_chk();'>删除</a></td>";
echo "</tr>";
}
?>
<tr>
<td colspan="9" align="right" >
<div align="right"> 共有记录 <?php echo $total; ?> 条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页<?php if($page>=2)
{
?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=1" title="首页"><font face="webdings"> 9 </font></a>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="前一页"><font face="webdings"> 7 </font></a>
<?php
}
if($pagecount<=4){
for($i=1;$i<=$pagecount;$i++){
?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?>
</div></td></tr>
</table>
</form>
</td></tr></table>
</center>
?>查询后,可以正常分页,但是单击下一页后就会报错!
错误如下:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\dihoclient\storeroom\ruku\found_staf_chk.php on line 46
>没有找到相关记录 Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\dihoclient\storeroom\ruku\found_staf_chk.php on line 70
<?php
session_start();
include "../inc/chec.php";
include "../conn/conn.php";
include "../inc/func.php";
?>
<link href="../css/style.css" rel="stylesheet" />
<script src="../admin/js/admin_js.js"></script>
<table width="1050" border="0" cellpadding="0" cellspacing="0" style="border: 1px solid #9CBED6; margin-top:15px;">
<tr>
<td align="center" >
<form name="found" method="post" action="found_staf_chk.php">
<table cellpadding="0" cellspacing="0" border = "0" >
<tr>
<td width="80">查找条件:</td>
<td width="37"><select name="u_field">
<option value="name">品名</option>
<option value="lot_number">批号</option>
<option value="r_data">入库日期</option>
<option value="supplier">供应商</option>
</select> </td>
<td width="140"><input type="text" name="u_key" size="20"/></td>
<td width="42"><input type="submit" value="查找" onclick="return chk_null();" /></td>
<td width="65" align="center" valign="middle"><a href="show_staf.php">显示全部</a></td>
</tr>
</table>
</form>
<form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0" width="1050" class="table2">
<tr>
<td width="75" height="25" align="center" valign="middle" scope="col">ID</td>
<td width="75" height="25" align="center" valign="middle" scope="col">品名</td>
<td width="125" height="25" align="center" valign="middle" scope="col">批号</td>
<td width="75" height="25" align="center" valign="middle" scope="col">入库日期</td>
<td width="75" height="25" align="center" valign="middle" scope="col">供应商</td>
<td width="75" height="25" align="center" valign="middle" scope="col">库管员</td>
<td width="75" height="25" align="center" valign="middle" scope="col">经手人</td>
<td width="75" height="25" align="center" valign="middle" scope="col">备注</td>
<td width="75" height="25" align="center" valign="middle" scope="col">操作</td>
</tr>
<?php
$str1=$_POST[u_field];
$str2=$_POST[u_key];
$sql=mysql_query("select count(*) as total from ruku where $str1 like '%$str2%' ",$conn) ;
$info=mysql_fetch_array($sql) ; //这是46行
$total=$info[total];
if($total==0)
{
echo "<tr align='center'><td > >没有找到相关记录</td></tr>";
}
else
{
$pagesize=2;
if ($total<=$pagesize){
$pagecount=1;
}
if(($total%$pagesize)!=0){
$pagecount=intval($total/$pagesize)+1;
}else{
$pagecount=$total/$pagesize;
}
if(($_GET[page])==""){
$page=1;
}else{
$page=intval($_GET[page]);
}
}
$sql1=mysql_query( "select id,name,lot_number,r_data,supplier,custos,deal_name,comment from ruku where $str1 like '%$str2%' limit " .($page-1)*$pagesize.",$pagesize ",$conn) ;
while($rows = mysql_fetch_row($sql1)){ //这是70行
echo "<tr>";
for($i = 0; $i < count($rows); $i++){
if ($rows[$i] == "")
echo "<td height='30'> </td>";
else
echo "<td height='30' align='center' valign='middle'> ".$rows[$i]." </td>";
}
echo "<td><a href='modify_staf.php?id=".$rows[0]."'>修改</a>/<a href='del_staf_chk.php?id=".$rows[0]."'onclick='return del_chk();'>删除</a></td>";
echo "</tr>";
}
?>
<tr>
<td colspan="9" align="right" >
<div align="right"> 共有记录 <?php echo $total; ?> 条 每页显示 <?php echo $pagesize;?> 条 第 <?php echo $page;?> 页/共 <?php echo $pagecount; ?> 页<?php if($page>=2)
{
?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=1" title="首页"><font face="webdings"> 9 </font></a>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="前一页"><font face="webdings"> 7 </font></a>
<?php
}
if($pagecount<=4){
for($i=1;$i<=$pagecount;$i++){
?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php
}
}else{
for($i=1;$i<=4;$i++){
?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $i;?>"><?php echo $i;?></a>
<?php }?>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $page-1;?>" title="后一页"><font face="webdings"> 8 </font></a>
<a href="found_staf_chk.php?id=<?php echo $id;?>&page=<?php echo $pagecount;?>" title="尾页"><font face="webdings"> : </font></a>
<?php }?>
</div></td></tr>
</table>
</form>
</td></tr></table>
</center>
?>查询后,可以正常分页,但是单击下一页后就会报错!
错误如下:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\dihoclient\storeroom\ruku\found_staf_chk.php on line 46
>没有找到相关记录 Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in D:\xampp\htdocs\dihoclient\storeroom\ruku\found_staf_chk.php on line 70
解决方案 »
- mysql_insert_id();返回值为0 是什么原因 表中有自增字段 且为主键
- php 修改代码的问题....请帮忙
- 网站用cookie设置登录状态。安全吗 ?
- 分享IIS下安装php533的体验
- 如何实现 当点击完一个链接后.链接就变色的功能?
- 紧急求助!登陆验证页面出现奇怪问题!
- 跪求高手帮忙,我想偷却偷不到.
- 在我的数据库中加入符号"•",就会出现乱码,而且影响到其它字段
- 怎样在页面中取出注册session变量的值
- 初学php,请问文章(不是页面)对应的页面的哪个?预览文章时总是跳到首页
- An error has occurred when creating this preference page.
- 新手请教啊
这就不会吗??呵呵。。新手
呵呵
select count(*) as total from ruku where like '%%'
从记录偏移a开始,连续取b条记录。
你把sql输出看看对不对。
$str2=$_POST[u_key];
应该是$_GET[""]; 吧,从URL取值
但点击页码后sql语句输出就变成:select count(*) as total from ruku where like '%%'
发现u_field和u_key的值都没了,我想这是导致出错的原因,但我不知道为什么会没,该怎样能保存住这两个值呢!
$str2=$_POST[u_key];
---------------------------------
点下一页后,分别echo 这两个变量,看看取值是否正常,这个地方是关键.
没有输出,说明form 没有POST,你要想个方法让form POST
<a href='<?php ....?>' onclick='form1.submit()'>后一页</a>
<a href="....&field=u_field.value&value=u_key.value"
或者把ID放到post中
* 得到参数指定天数前的时间
*
* @param date 开始日期
* @param day 天数
* @return
*/
public static Date getDateBefore(Date date, int day) {
Calendar now = Calendar.getInstance();
now.setTime(date);
now.set(Calendar.DATE, now.get(Calendar.DATE) - day);
return now.getTime();
}
private static final long DAY_IN_MINUTE = 24L * 60L * 60L * 1000L; private static final int TEN = 10;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.time.FastDateFormat;