锐客网

  1. 首页 > 睿知 > it技术 > >

php怎么设置数据分页 php对数据进行分组( 五 )

IT技术return


tr bgcolor="#eff3ff"
td标题：?php echo $row[title]?/td td时间：?php echo $row[lastdate]?/td
/tr
tr bgcolor="#eff3ff"
td 用户：?php echo $row[user]?/tdtd/td
/tr
tr
td内容：?php echo htmtocode($row[content]);?/td
/tr
br
/table
?php
}
?
方法3：
script
function viewpage(p){
if(window.XMLHttpRequest){
var xmlReq = new XMLHttpRequest();
} else if(window.ActiveXObject) {
var xmlReq = new ActiveXObject('Microsoft.XMLHTTP');
}
var formData = "https://www.04ip.com/post/page="+p;
xmlReq.onreadystatechange = function(){
if(xmlReq.readyState == 4){
document.getElementByIdx_x('content2').innerHTML = xmlReq.responseText;
}
}
xmlReq.open("post", "hotel_list.php", true);
xmlReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xmlReq.send(formData);
return false;
}
/script
脚本2：
header("Content-Type:text/html;charset=GB2312");
$pagesize=10;
//echo $_POST['page'];
$result = mysql_query("Select count(DISTINCT hotelname) FROM ".TBL_HOTELS);
$myrow = mysql_fetch_array($result);
$numrows=$myrow[0];
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize)
$pages++;
if (isset($_POST['page'])){
$page=intval($_POST['page']);
}
else{
//设置为第一页
$page=1;
}
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
//计算记录偏移量
$offset=$pagesize*($page - 1);
//读取指定记录数
$result=mysql_query("select `hotelname` , count( * ) from ".TBL_HOTELS." GROUP BY `hotelname` order by id desc limit $offset,$pagesize");
$num = mysql_num_rows($result);
while ($row = mysql_fetch_array($result,MYSQL_NUM)) {
$hotelname[] = $row[0];
$countpeople[] = $row[1];
}
for($a=0;$a$num;$a++)
{
//$result=mysql_query("select count(title) from " . TBL_Comments ." where `title`=\"".$title[$a]."\"");
//$row = mysql_fetch_row($result);
echo "TABLE style=\"MARGIN-BOTTOM: 20px\" cellSpacing=0 cellPadding=0 width=100% \n";
echo "TBODY\n";
echo "TR\n";
echo "TD style=\"PADDING-TOP: 5px\" vAlign=top align=left width=80\n";
//rating_bar($title[$a],5);
echo "/TD\n";
echo "TD style=\"PADDING-TOP: 5px\" align=left width=100%A title=$hotelname[$a] style=\"FONT-SIZE: 14px\" href=https://www.04ip.com/post/#$hotelname[$a]/A/n";
echo "/TD/TR\n";
echo " TR\n";
echo "TD/TD\n";
echo "TD style=\"PADDING-LEFT: 0px\"\n";
echo "IMG src=https://www.04ip.com/"images/comment.gif\"推荐人数:($countpeople[$a]) |\n";
echo "SPAN平均分：STRONG/STRONG (".$count."票) | 评论数:()/SPAN\n";
echo "/TD/TR/TBODY/TABLE\n";
}
echo "TABLE style=\"MARGIN-TOP: 30px\" cellSpacing=0 cellPadding=0 width=\"100%\"";
echo "";
echo "TBODYTRTD colSpan=3 height=20";
echo "DIV align=center";
echo "P align=leftFONT color=red第".$page."页/总".$pages."页 | 总".$numrows."条/FONT | ";
if ($page1) echo "a onclick=\"viewpage(".$first.")\" href='https://www.04ip.com/post/#'首页/a | ";
if ($page1) echo "a onclick=\"viewpage(".$prev.")\" href='https://www.04ip.com/post/#'上页/a | ";
if ($page$pages) echo "a onclick=\"viewpage(".$next.")\" href='https://www.04ip.com/post/#'下页/a | ";
if ($page$pages) echo "a onclick=\"viewpage(".$last.")\" href='https://www.04ip.com/post/#'尾页/a";
echo "转到第 INPUT maxLength=3 size=3 value=https://www.04ip.com/post/1 name=goto_page 页 INPUT hideFocus onclick=/"viewpage(document.all.goto_page.value)\" type=button value=https://www.04ip.com/post/Go name=cmd_goto";
echo "/P/DIV/TD/TR/TBODY/TABLE";
php分页功能怎么实现php本身是没有分页概念php怎么设置数据分页的php怎么设置数据分页 ， 分页是URL传参php怎么设置数据分页，然后通过mysql查询语句到数据库获取数据，然后实现的分页，url上的参数，通过PHP的$_GET都是可以获取到的 。

推荐阅读


上一篇：网络服务器繁忙请稍后重试 电脑网络服务器繁忙怎么办

下一篇：灯光直播带货的方法，灯具直播怎么做