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";
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)