<?php

//連接數(shù)據(jù)庫(kù)

error_reporting(0);?

mysql_connect('127.0.0.1', 'code1', '');

mysql_select_db('code1');

mysql_query("set names 'utf8'");

//預(yù)設(shè)翻頁(yè)參數(shù)

$page = 2;

$pagesize = 2;

//offset就相當(dāng)于當(dāng)前第幾條數(shù)據(jù)

$offset = ($page-1)*$pagesize;

//從第幾條數(shù)據(jù)開(kāi)始,顯示幾條數(shù)據(jù)

$sql = '&quot;select * from user limit $offset,$pagesize&quot;';

//獲取翻頁(yè)數(shù)據(jù)

$result = mysql_query($sql);

$data = array();

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

? ? $data[] = $row;

}

echo '<pre>';

print_r($data);

echo '</pre>';