解决方案 »
- 弱智的问题 低手来教下
- mysql_query 问题~! SOS...很急
- php 代理服务器
- iis整合问题 PHP has encountered an Access Violation at 01BAAC7A
- 求助! php mysql insert 长字符串不能插入问题.
- 在寫第一個php程序時出現:mysql_pconnect(): Can't create TCP/IP socket不知怎麽辦???
- session的问题?
- 200分紧急求救: 如何用php+mySQL进行分页处理
- 求救!!
- 有没有这样的php程序或别的程序:在客户端运行这个程序后,就能将服务器上的文件备份到本地?
- 【SOS】求教php AES/CBS/PKCS5Padding加密
- 请问,如何给一个页面2个button附上不同的值
$mysql[Id]
$mysql[artile_title]
等这些最好加上引号,否则会有警告。查询后的分页是需要跳转到下一页时,把查询条件都带过去才可以。所以search这个参数需要$_POST与 $_GET都可以获取到。$search = trim($_REQUEST['search']);
<a href="admin.php?main=main_search&search=<?php echo $search ; ?>&page=<?php echo $pg-1; ?>">上一页</a> <a href="admin.php?main=main_search&search=<?php echo $search; ?>&page=<?php echo $pg+1; ?>">下一页</a>改成这样看看。<?php
$search = trim($_REQUEST['search']);msg($dbname,$dbuser,$dbpass,$dbsj,$dblang);
//$titile = %所% and artile like %的% and artile like %a%;
$titile = preg_replace( "/\s+/","%' and artile_title like '%",$search);if($title!=''){
$title = "'%".$titile."%'";
}// 所 的 空
//$sql ="select * from wenzhang where artile_title like $title order by id desc";
$sql ="select * from wenzhang where artile_title like $title order by id desc";
//select * from wenzhang where artile_title like 所 % and artile like % 的 order by id desc
//echo $sql;
$my = mysql_query($sql);
$number = mysql_num_rows($my); //总行数
//echo $number;
$page = 2;// 设定分页每页的行数
$pagesize = ceil($number/$page); //能显示几页
$pg = $_GET['page'];
if(empty($pg)){
$pg =1;
}
$numbers = ($pg-1)*$page;
$sql ="select * from wenzhang where artile_title like $title order by id desc limit $numbers,$page";
//echo $sql;
$my = mysql_query($sql);
mysql_close();
?>
<table width="100%" border="0" cellspacing="1" bgcolor="#666666";>
<tr>
<td colspan="4" bgcolor="#FFFFFF"><div align="center">文章管理
</td>
</tr> <tr>
<td height="21" bgcolor="#FFFFFF">id</td>
<td bgcolor="#FFFFFF"><div align="center">标题</div></td>
<td bgcolor="#FFFFFF"><div align="center">作者</div></td>
<td bgcolor="#FFFFFF"><div align="center">操作</div></td>
</tr>
<?php
while ($mysql = mysql_fetch_array($my)){
?>
<tr>
<td height="22" bgcolor="#FFFFFF"><?php echo $mysql['Id']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $mysql['artile_title'] ?></td>
<td bgcolor="#FFFFFF"><?php echo $mysql['artile_auther']?></td>
<td bgcolor="#FFFFFF">[<a href="../admin.php?main=main_biji&id=<?php echo $mysql['Id']; ?>">操作</a>][<a href="../admin.php?main=main_del&id=<?php echo $mysql['Id']; ?>">删除</a>]</td>
</tr>
<?php
}
?>
</table><p>一共<?php echo $number; ?>条记录 <a href="admin.php?main=main_search&search=<?php echo $search ; ?>&page=<?php echo $pg-1; ?>">上一页</a> <a href="admin.php?main=main_search&search=<?php echo $search; ?>&page=<?php echo $pg+1; ?>">下一页</a></p>