PHP分页显示错误[关闭]

Question

I have created a pagination for my website and It shows an error:

Parse error: syntax error, unexpected '"' in Foldername on line 29

Here's the code I've been working on:

<?php

    $count_query = mysql_query("SELECT NULL FROM posts");
    $count = mysql_num_rows($count_query);

    if (isset($_GET['page'])) {

        $page = preg_replace("#[^0-9]#","",$_GET['page']);

    } else {

        $page = 1;

    }

    $perPage = 10;
    $lastPage = ceil($count / $perPage);

    if ($page < 1) {

        $page = 1;

    } else if ($page > $lastPage) {

        $page = $lastPage;

    }

    $limit = "LIMIT " .($page -1)"$perPage.","$perPage";

    $query = mysql_query("SELECT * FROM posts ORDER BY postNum DESC $limit");

    if ($lastPage != 1) {

        if ($page != $lastPage) {
            $next = $page + 1;
            $pagination .= '<a href="foldername/?page='.$next.'" class="pagerRight">Next</a>';
        }

        if ($page != 1) {
            $prev = $page - 1;
            $pagination .= 'foldername/?page='.$prev.'" class="pagerLeft">Prev</a>';
        }

    }

?>

The line 29 is: $limit = "LIMIT " .($page -1)"$perPage.","$perPage";

Answer 1

You can try and change

$limit = "LIMIT " .($page -1)"$perPage.","$perPage";

with

$limit = "LIMIT ".($page -1)*$perPage.",".$page*$perPage."";

This solution will multiply $page-1 for 10 (i've seen your code) limiting paging -1 * 10 to page *10

Example:

Page 1:

LIMIT 0, 10 Page 2: LIMIT 10,20 etc...

Edit:

Try change

$query = mysql_query("SELECT * FROM posts OREDER BY postNum DESC $limit");

with:

$query = mysql_query("SELECT * FROM posts ORDER BY postNum DESC ".$limit."");

Corrected OREDER with ORDER and used correct chain (dot)