get方式获取页码,id号分页显示查询结果

来源:互联网 发布:淘宝分享有礼有用吗 编辑:程序博客网 时间:2024/06/11 20:31
<?phprequire "../../class/connect.php";require "../../data/dbcache/class.php";require "../../class/db_sql.php";$link = db_connect();$empire = new mysqlquery();$add = $_GET;$tagid = $add[tagid];$total="select count(*) as total from {$dbtbpre}enewstagsdata where tagid=$tagid ";    $res = mysql_query($total);     $num=mysql_fetch_array($res);$totalNumber=$num[0];$orderby = $_GET["orderby"];$perNumber = 20;$page = $_GET["page"];$totalPage = ceil($totalNumber / $perNumber);if (!$page) {$page = 1;}$startCount = ($page - 1) * $perNumber;    $sql="select id from {$dbtbpre}enewstagsdata where tagid=$tagid order by newstime desc limit $startCount,$perNumber";$rst = mysql_query($sql);while($str=mysql_fetch_assoc($rst)) {$query = mysql_query("select title,newstime,titlepic,titleurl,smalltext,classid,onclick,befrom from {$dbtbpre}ecms_news where id=$str[id]");while ($row = $empire->fetch($query)) {$titlepic = ($row["titlepic"] ? $row["titlepic"] : $public_r[newsurl] . "e/data/images/notimg.gif");$csql = mysql_query("select classname from {$dbtbpre}enewsclass where classid='" . $row["classid"] . "' limit 1");$cr = $empire->fetch($csql);echo "<li class=\"item\"> <span id=\"ad_extra\" style=\"display:none;\"></span>            <div class=\"y-box item-inner\">             <div class=\"y-left lbox\" ga_event=\"article_img_click\">              <a class=\"img-wrap\" target=\"_blank\" href=\"" . $row["titleurl"] . "\"> <img alt=\"\" src=\"" . $titlepic. "\" /> </a>             </div>             <div class=\"rbox \">              <div class=\"rbox-inner\">               <div class=\"title-box\" ga_event=\"article_title_click\">                <a class=\"link title\" target=\"_blank\" href=\"" . $row["titleurl"] . "\"> " . $row["title"] . " </a>               </div>               <div class=\"y-box footer\">                <div class=\"y-left\">                 <div class=\"y-left\">                  <a class=\"lbtn tag-hot\" ga_event=\"article_avatar_click\" href=\"/" . $class_r[$row[classid]][classpath] . "/\">" . $class_r[$row[classid]][classname] . "</a>                  <a class=\"lbtn source\" ga_event=\"article_name_click\">  " . $row["befrom"] . " </a>                 </div>                 <span class=\"lbtn\"> " . date("m-d H:i", $row["newstime"]) . "</span>                 <span> " . $row["onclick"] . "阅读</span>                </div>                <div class=\"y-right\">                </div>               </div>              </div>             </div>            </div>";}}$empire = NULL;db_close();?>

原创粉丝点击