Pagination system error

by 3 replies
4
I'm trying to create a pagination system, but there is a problem. I created this page by following a youtube tutorial. The page shown in tutorial works well, but when I write the code for my page, it give me an error.

Here is the code.
Code:
<?php
$perPage = 5;
if (!isset($_GET['submit'])) {
	header("location: index.php?page=1");
}
else {
	$page = $_GET['submit']; }

	$start = (($page - 1) * $perPage);
	$con = mysqli_connect("mysql5.000webhost.com", "a8995753_db2", "xxxxxxxxx", "a8995753_db2") or die("Error ee oay: " . mysqli_connect_error());
$query = "SELECT * FROM customer";
$numOfRows = mysqli_num_rows(mysqli_query($con, $query));
$numOfPages = ceil($numOfRows / $perPage);
$query .= " LIMIT $start, $perPage";
$exQuery = mysqli_query($con, $query);
while ($row = mysqli_fetch_array($exQuery)) {
	 echo $row['custID'] . " " . $row['name'] . "<br>";
}
?>
And here is the URL to my test website where you can see the error. The website doesn't work.
Please help me to solve this problem.
#programming #error #pagination #system
  • Line 4, change index.php?page=1 to index.php?submit=1

    Right now submit is never set for $_GET so you're stuck in a loop.
  • Indeed, at the moment the only bit of code being processed is:

    if (!isset($_GET['submit'])) { header("location: index.php?page=1"); }

    This is because this line of code is saying ' if the value of submit is not set then redirect to location: index.php?page=1' which still does not set the value for submit so it is an infinate loop.
    This line needs to be:
    if (!isset($_GET['submit'])) { header("location: index.php?submit=1"); }

    You can see the working page by using the correct url:
    http://www.myexp.comoj.com/index.php?submit=1
  • Yes am also agree with you.It should be like this:
    if (!isset($_GET['submit'])) {
    header("location: index.php?submit=1");
    }
Join the discussion

Next Topics on Trending Feed

  • 4

    Pagination system error

    I'm trying to create a pagination system, but there is a problem. I created this page by following a youtube tutorial. The page shown in tutorial works well, but when I write the code for my page, it give me an error. Here is the code.