php実装ページング
2913 ワード
<?php
// PDO php mysql
header('content-type:text/html;charset=utf-8');
try{
//
$page=$_GET['p'];
$arr=array(
'DB_USER' =>'root',
'DB_PASS' =>'',
'DB_TYPE' =>'mysql',
'DB_HOST' =>'localhost',
'DB_NAME' =>'chat'
);
$dsn=''.$arr['DB_TYPE'].':host='.$arr['DB_HOST'].';dbname='.$arr['DB_NAME'].'';
$pdo = new PDO($dsn,$arr['DB_USER'],$arr['DB_PASS'],array(PDO::ATTR_PERSISTENT => true));
//$sql1="select *from chat_message".($page-1)*10.",10";
// $page=$page-1;
$num=10;
$sql ="select * from chat_message limit ".($page-1).",$num";
$pdo->query("SET NAMES UTF8");
echo "<table border=1 cellspacing =0 width=50%>";
echo "<tr>";
echo "<td>id</td>";
echo "<td>content</td>";
$stmt =$pdo->query($sql);
$sql1="select count(*) from chat_message";
$total=$pdo->query($sql1);
foreach($total as $key)
{
echo $key[0];
//var_dump($key);
}
foreach($stmt as $k){
echo "<tr>";
echo "<td>{$k['id']}</td>";
echo "</br>";
echo "<td>{$k['content']}</td>";
echo"</tr>";
}
echo "</tr>";
echo "</table>";
// 10
// value ,value 。
$total_pages=ceil($key[0]/$num);
$page_banner="";
//echo $total_pages;
//echo $page;
for($i=1;$i<=$total_pages;$i++){
echo $page="<a href='".$_SERVER['PHP_SELF']."?p=".($i)."'>$i</a>";
}
if($page>1){
//echo ' ';
echo $index="<a href='".$_SERVER['PHP_SELF']."?p=1'> </a>";
echo $page_up="<a href='".$_SERVER['PHP_SELF']."?p=".($page-1)."'> </a>";
}
if($page<$total_pages){
echo $page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'> </a>";
echo $end_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($total_pages)."'> </a>";
}
//print_r($pdo);
//
//$page_banner="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'> </a>";
//$page_banner.="<a href='".$_SERVER['PHP_SELF']."?p=".($page+1)."'> </a>";
echo " ".$key[0];
}catch(PDOException $e){
$e->getMessage();
}
?>