<?php
include "./admin/config.php";
$connect =mysql_connect($host,$user,$password)or die("数据库连接失败");
$select =mysql_select_db($database,$connect);
$result =mysql_query("SELECT Count(*) AS total FROM service_info where kind_id='$kind_id'");
$row=mysql_fetch_array($result);
$total=$row[total];
$max=1;//每页最多显示的记录;
if (!$result) echo "wrong";
$totalpage=$total/$max;
if ($totalpage==0) $totalpage=1;
$totalpage=ceil($totalpage);
$nowpage=ceil($offset/$max)+1;
if(!$offset) $offset=0;
echo "共有<font color=red>$total</font>条信息 分<font color=red>$totalpage</font> 页 当前是第<font color=red>$nowpage</font> 页<br>";
?>
<table border=1 width="100%" cellspacing="0" cellpadding="2" bordercolor="#A8BCE0" bordercolorlight="#FFFFFF" bordercolordark="#A8BCE0" >
<?
$query =mysql_query("select id,title from service_info where kind_id='$kind_id' order by id desc limit $offset,5",$connect);
while($object=mysql_fetch_object($query)){
echo "<tr><td><IMG SRC='images/s_logo3.gif'><font color=#6633FF><a href='show_info_news.php?id=$object->id' target=_blank>$object->title</a></font></td></tr>";
}
?> </table>
<table border=1 width="100%" cellspacing="0" cellpadding="2" bordercolor="#A8BCE0" bordercolorlight="#FFFFFF" bordercolordark="#A8BCE0" >
<?
$query =mysql_query("select * from service_info where kind_id='$kind_id' order by id desc limit $offset,$max ",$connect);
while($object=mysql_fetch_object($query)){
if(file_exists("./pic/$object->pic_url")) $pic="<IMG SRC=\"./pic/$object->pic_url\" align='left'>";
else $pic="";
echo "<tr><td><center><font color=red><b>$object->title</b></font></center></td></tr>";
echo "<tr><td>$pic $object->content</td></tr>";
echo "<tr><td><div align='right'>$object->date</div></td></tr>";
}
?> </table>
<center><br>
<?php
if($offset<$total-$max){
$offset=$offset+$max;
echo"<a href=\"$php_self?offset=$offset&kind_id=$kind_id\">下一页</a> ";
}
else $offset=$offset+$max;
if($offset>$max){
$offset=$offset-2*$max;
echo "<a href=\"$php_self?offset=$offset&kind_id=$kind_id\">上一页</a>";
}
?>
这是我刚入门时写的,有些烂,不过还可以用试一下吧!
include "./admin/config.php";
$connect =mysql_connect($host,$user,$password)or die("数据库连接失败");
$select =mysql_select_db($database,$connect);
$result =mysql_query("SELECT Count(*) AS total FROM service_info where kind_id='$kind_id'");
$row=mysql_fetch_array($result);
$total=$row[total];
$max=1;//每页最多显示的记录;
if (!$result) echo "wrong";
$totalpage=$total/$max;
if ($totalpage==0) $totalpage=1;
$totalpage=ceil($totalpage);
$nowpage=ceil($offset/$max)+1;
if(!$offset) $offset=0;
echo "共有<font color=red>$total</font>条信息 分<font color=red>$totalpage</font> 页 当前是第<font color=red>$nowpage</font> 页<br>";
?>
<table border=1 width="100%" cellspacing="0" cellpadding="2" bordercolor="#A8BCE0" bordercolorlight="#FFFFFF" bordercolordark="#A8BCE0" >
<?
$query =mysql_query("select id,title from service_info where kind_id='$kind_id' order by id desc limit $offset,5",$connect);
while($object=mysql_fetch_object($query)){
echo "<tr><td><IMG SRC='images/s_logo3.gif'><font color=#6633FF><a href='show_info_news.php?id=$object->id' target=_blank>$object->title</a></font></td></tr>";
}
?> </table>
<table border=1 width="100%" cellspacing="0" cellpadding="2" bordercolor="#A8BCE0" bordercolorlight="#FFFFFF" bordercolordark="#A8BCE0" >
<?
$query =mysql_query("select * from service_info where kind_id='$kind_id' order by id desc limit $offset,$max ",$connect);
while($object=mysql_fetch_object($query)){
if(file_exists("./pic/$object->pic_url")) $pic="<IMG SRC=\"./pic/$object->pic_url\" align='left'>";
else $pic="";
echo "<tr><td><center><font color=red><b>$object->title</b></font></center></td></tr>";
echo "<tr><td>$pic $object->content</td></tr>";
echo "<tr><td><div align='right'>$object->date</div></td></tr>";
}
?> </table>
<center><br>
<?php
if($offset<$total-$max){
$offset=$offset+$max;
echo"<a href=\"$php_self?offset=$offset&kind_id=$kind_id\">下一页</a> ";
}
else $offset=$offset+$max;
if($offset>$max){
$offset=$offset-2*$max;
echo "<a href=\"$php_self?offset=$offset&kind_id=$kind_id\">上一页</a>";
}
?>
这是我刚入门时写的,有些烂,不过还可以用试一下吧!
select id,title from service_info where kind_id='$kind_id' order by id desc limit $offset,5",$connect
我使用了,显示不出来,(连的是ACCESS)的 有没有用ODBC连ACCESS的例子,谢谢各位,急!急!急!急!急!急!
可以用如下的笨方法:
用while判断,一条一条的取出来!根据页数筛选出合适的记录输出,有点象oracle的分页方法!
试试
不同的数据的sql实现不太一样。