php查询数据库并分页查询

Question

我现在去数据库写成功了，但是取出来的是全部数据，分页功能已经实现了 怎么调用分页按钮

<?php 
function paginations($count, $perlogs, $page, $url, $anchor = ''){
    $pnums = @ceil($count / $perlogs);
    $re = '';
    $urlHome = preg_replace("|[\?&/][^\./\?&=]*page[=/\-]|", "", $url);
    for ($i = $page - 5; $i <= $page + 5 && $i < $pnums; $i++) {
    if ($i >= 0) {
    if ($i == $page) {
    $re .= "<li class=\"active\"><a>".($i+1)."</a></li>";
    } elseif ($i == 0) {
    $re .= "<li><a href=\"$urlHome$anchor\">".($i+1)."</a></li>";
    } else {
    $re .= "<li><a href=\"$url$i$anchor\">".($i+1)."</a></li>";
    }
    }
    }
    if ($page > 6)
    $re = "<li class=\"prev\"><a href=\"{$urlHome}$anchor\">首页</a>$re</li>";
    if ($page + 5 <= $pnums)
    $re .= "<li class=\"next\"><a href=\"$url".($pnums-1)."$anchor\" title=\"尾页\">尾页</a></li>";
    if ($pnums <= 0)
    $re = '';
    return $re;
}
$DB=MySql::getInstance();
$page = isset($_GET['page']) ? intval($_GET['page']) : 0;
$sizepage = 10;
$limit = $page*$sizepage;
$query=$DB->query("select id,content,img,author,type,create_time from ".DB_PREFIX."weiyu limit $limit,$sizepage");
while($row = $DB->fetch_array($query)){?>
<?php echo $row["content"];?><br />
<?php }?>

现在就差分页按钮调用不出来了

Answer 1

limit