if ($adjacents <= 0) { $adjacents = 2; } $reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages . "&adjacents=" . $adjacents; $from = ($page - 1) * $rpp; $members = $db->query("SELECT * FROM `wm_admin_c` limit {$from},{$rpp}")->fetchall(); ?> <table width="100%" border=0 align=center cellpadding=2 cellspacing=1 bordercolor="#799AE1" class=tableBorder> <tbody> <tr> <th align=center colspan=4 style="height: 23px">会员信息</th> </tr> <tr bgcolor="#DEE5FA"> <td align="center" colspan="4" align="center" class=txlrow> <font color="#FF0000"><?php echo paginate_three($reload, $page, $tpages, $adjacents); ?> </font> </td> </tr> <tr bgcolor="#799AE1"> <td width="25%" class=txlHeaderBackgroundAlternate>会员昵称</td> <td width="25%" class=txlHeaderBackgroundAlternate>Email</td> <td width="25%" class=txlHeaderBackgroundAlternate>注册时间</td> <td width="25%" class=txlHeaderBackgroundAlternate>会员积分</td> </tr> <?php foreach ($members as $mem) { ?> <tr> <td class=txlrow><?php
// results per page $adjacents = intval($_GET['adjacents']); if (!$_GET['tpages']) { $count = $db->query("SELECT count(`id`) FROM `wm_grade` WHERE `shopid`='{$shopid}' and `speed`='0'")->fetchColumn(); $tpages = $count ? ceil($count / $rpp) : 1; // total pages, last page number } else { $tpages = $_GET['tpages']; } if ($adjacents <= 0) { $adjacents = 2; } $from = ($page - 1) * $rpp; $dinpj = $db->query("SELECT `wm_grade`.*,`wm_admin_c`.`nickname` FROM `wm_grade`,`wm_admin_c` WHERE `wm_grade`.`shopid`='{$shopid}' and `wm_grade`.`speed` ='0' and `wm_grade`.email=`wm_admin_c`.email ORDER BY `postdate` DESC limit {$from},{$rpp}")->fetchall(); $reload = $_SERVER['PHP_SELF'] . "?tpages=" . $tpages . "&adjacents=" . $adjacents . "&shopid=" . $shopid . "&tag=" . $tag; $smarty->assign("paginate", paginate_three($reload, $page, $tpages, $adjacents)); foreach ($dinpj as $key => $pjrow) { $dininfo = $db->query("select `dinname`,`dinprice`,`isellout` from wm_dininfo where dinid='" . $pjrow['gradeid'] . "'")->fetch(); $dinpj[$key]['dinname'] = $dininfo['dinname']; $dinpj[$key]['dinprice'] = $dininfo['dinprice']; $dinpj[$key]['isellout'] = $dininfo['isellout']; } //餐品评价结束 } $smarty->assign("dinpj", $dinpj); $smarty->assign("yysj", $yysj); $smarty->assign("shopinfo", $shopinfo); $smarty->assign("dinners", $dinners); $smarty->assign("shops", $dintypes); echo "<div id='sidebar'>"; $smarty->assign("shopcart", $cart->display_cart($jcart));