php+mysql站内搜索+分页-PHP Tutorial-php.cn

php+mysql站内搜索+分页

WBOY

Release： 2016-06-23 14:08:53

Original

1321 people have browsed it

php+mysql站内搜索+分页,下面是站内搜索部分（能显示）,分页就是分不了,由于生活所迫我是边学习边完成这项目给别人，所有未用模板框架，下面的代码在百度知道提交不了，特来求助，麻烦高手帮下小弟
if(isset($_POST['search']) and $_POST['search']!=null){
$result=mysql_query("select * from tb_members where shopname like '%".$_POST['search']."%'");
$info=mysql_fetch_array($result);if($info>=1){
while($info=mysql_fetch_array($result)){?>
">
}
}else{
echo "没有您要查找的内容！";
}
}
?>

回复讨论(解决方案)

分页是个很基础的部分，我不给出解决代码了，顺手找了下几年前买的书上的光盘里的php+mysql分页实例代码，希望你能理解分页的用法

<?php // 创建数据库连接$link = mysql_connect ( "localhost", "root", "123456" ) or die ( mysql_error() );mysql_select_db ( "student_info" ) or die ( mysql_error() );// 设置字符集mysql_query ( "SET NAMES gbk");// 获取当前页网址$currentPage = basename ( $_SERVER["PHP_SELF"] );// 设置基本查询语句$sql = "SELECT student_id AS 学号, student_name AS 姓名,  gender AS 性别, birthdate AS 出生日期 FROM students";   // 设置每页显示的记录数$maxRows = 4;// 计算总记录数和总页数$rsAll = mysql_query ( $sql );$totalRows = mysql_num_rows( $rsAll );$totalPages = ceil ( $totalRows / $maxRows );// 设置当前页号if ( isset( $_GET["pageNum"] ) )  $pageNum = $_GET["pageNum"];else  $pageNum = 1;if ( !is_numeric ( $pageNum ) or ( $pageNum  < 1 ) ) $pageNum = 1;if ( $pageNum > $totalPages ) $pageNum = $totalPages;// 设置起始行号$startRow = ( $pageNum - 1 ) * $maxRows;// 为查询语句添加LIMIT子句$sql_limit = sprintf ( "%s LIMIT %d, %d", $sql, $startRow, $maxRows );// 发送查询语句$rs = mysql_query ( $sql_limit ) or die ( mysql_error() );// 从记录集中获取一行记录$row = mysql_fetch_row ( $rs );?><!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><style type="text/css">input {font-size:10px; font-weight:bold}</style></head><body><table width="90%" border="1" align="center" cellpadding="3"><caption>分页显示记录集</caption><?php print ( "<tr>\n" );$colNum = mysql_num_fields( $rsAll );for ( $i = 0; $i < $colNum; $i++ ) {  $meta = mysql_fetch_field ( $rsAll );  printf ( "<th>%s</th>\n",$meta->name );}print ( "</tr>\n" );do {   print ("<tr>\n");  for ( $i =0; $i < $maxRows; $i++ )     printf ( "<td>%s</td>\n", $row[$i] );  print ( "</tr>\n" );} while ( $row = mysql_fetch_row ( $rs ) );?>  </table><br /><div align="center"><form action="" method="get">页次：<?php echo $pageNum ; ?>/<?php echo $totalPages; ?> 共<?php echo $totalRows ?>条记录 <?phpfor( $i = 1; $i <= $totalPages ; $i++ ){  if($i != $pageNum)    printf ( "<a href=%s?pageNum=%d>%d</a> \n", $currentPage, $i, $i );  else    printf ( "<b><font color=\"red\">%d</font></b> \n", $i);}print ( "<br />" );if( $pageNum > 1) {  printf ( "<a href=%s?pageNum=%d>首页</a>  ", $currentPage, 0 );  printf ( "<a href=%s?pageNum=%d>前页</a>  ", $currentPage, $pageNum -1  );}if ( $pageNum < $totalPages ) {  printf ( "<a href=%s?pageNum=%d>后页</a>  ", $currentPage, $pageNum + 1 );  printf ( "<a href=%s?pageNum=%d>末页</a>  ", $currentPage, $totalPages );}?><input name="pageNum" type="text" size="2" /><input type="submit" name="Submit" value="转到" /></form></div></body></html>

Copy after login

分页我有很多，用到上面的搜索代码中不行（搜索代码能用），我的分页在别处可用