php中连接mysql（分页显示）

<? php
//  连接，选择数据库
$link   =   mysql_connect ( ' localhost ' ,   ' root ' ,   '' );
echo   ' Connected successfully ' . " <br> " ;
mysql_select_db ( " school " , $link );
$page_num = 2 ;
if ( ! $page_no );
{
  $page_no = 1 ; 
}
$start_num = $page_num * ( $_GET [ " page_no " ] - 1 ); // 页号$page_no
// 执行 SQL 查询
$query   =   " SELECT * FROM articles limit  $start_num , $page_num " ;
$result   =   mysql_query ( $query );
$num = @ mysql_num_rows ( $result );
echo   " 行数= $num \n " . " <br> " ;
for ( $i = 0 ; $i < $num ; $i ++ )
{
 @ mysql_data_seek ( $result , $i );
  $data = @ mysql_fetch_array ( $result );
  echo   " <pre> " ;
  echo   " id: $data [id],title: $data [title],body: $data [body] " ;
  echo   " </pre> " ; 
}
echo   " <a href='connect.php?page_no= " . ( $_GET [ " page_no " ] - 1 ) . " '>上一页</a> <a href='connect.php?page_no= " . ( $_GET [ " page_no " ] + 1 ) . " '>下一页</a> " ;
  // 关闭连接
mysql_close ( $link );
?>

转载于:https://www.cnblogs.com/zhuboxingzbx/articles/1163132.html