php微信公众号开发之翻页查询

本文为大家分享了php微信公众号开发之翻页查询的具体代码，供大家参考，具体内容如下

注意：公众号列表最多只能列出8列，超出会报错

原理：

注释：+1 是为了说明有多少页

>10 10

核心代码如下：

$postObj = simplexml_load_string($postStr, 'SimpleXMLElement', LIBXML_NOCDATA);        $fromUsername = $postObj->FromUserName;        $toUsername = $postObj->ToUserName;        $type = $postObj->MsgType;        $customevent = $postObj->Event;        $latitude = $postObj->Location_X;        $longitude = $postObj->Location_Y;        $keyword = trim($postObj->Content);        $time = time();        $textTpl = "<xml>              <ToUserName><![CDATA[%s]]></ToUserName>              <FromUserName><![CDATA[%s]]></FromUserName>              <CreateTime>%s</CreateTime>              <MsgType><![CDATA[%s]]></MsgType>              <Content>%s</Content>              <FuncFlag>0</FuncFlag>              </xml>";               switch ($type)        {          case "event";        if ($customevent=="subscribe")          {$contentStr = "感谢你的关注/n栏目正在搭建，敬请期待/n回复1看视频教程";}        break;        case "image";          $contentStr = "你的图片很棒！";          break;        case "location";          $contentStr = "你的纬度是{$latitude},经度是{$longitude},我已经锁定！";          break;        case "link" ;          $contentStr = "你的链接有病毒吧！";          break;        case "text";           include("coon.php");           $num = "SELECT * FROM `kecheng` ";           $que=mysql_query($num);           $no=mysql_num_rows($que);//获得条数           $sumpage=ceil($no/7);           $page=(intval($keyword)-1)*7;           $total=$no-$page+1;           if($total>8)           {$total=8;}            $sql = "SELECT * FROM `kecheng` ORDER BY `id` DESC LIMIT {$page},7";           $query=mysql_query($sql);                   $newsTpl = "<xml>            <ToUserName><![CDATA[%s]]></ToUserName>            <FromUserName><![CDATA[%s]]></FromUserName>            <CreateTime>%s</CreateTime>            <MsgType><![CDATA[news]]></MsgType>            <ArticleCount>$total</ArticleCount>            <Articles>            <item>            <Title><![CDATA[总共{$sumpage}页，输入页数翻页]]></Title>            <Description><![CDATA[]]></Description>            <PicUrl>http://autoguitar.duapp.com/1.jpg</PicUrl>            <Url><![CDATA[]]></Url>            </item>";              while($rs=mysql_fetch_array($query)){                  $newsTpl.="<item>                   <Title>$rs[content]</Title>                    <Description><![CDATA[]]></Description>                   <PicUrl>http://dq095.applinzi.com/2.jpg</PicUrl>                   <Url><![CDATA[]]></Url>                   </item>";                   }              $newsTpl.="</Articles>                   <FuncFlag>0</FuncFlag>                  </xml>";           $myresultStr = sprintf($newsTpl, $fromUsername, $toUsername, $time);           echo $myresultStr;           break;                 default;          $contentStr ="此项功能尚未开发";          }        $msgType="text";        $resultStr = sprintf($textTpl, $fromUsername, $toUsername, $time, $msgType, $contentStr);        echo $resultStr;