pagination works but it doesn't go to next page

Question

i have added pagination on my site, everything is fine but whenever i click next it will go to same page url/dataload2.php?page=0. This is my php code, i think it is something wrong in calculations or looping, thank you for any help.

EDIT: some more code added

    <?php

include 'conn.php';
$num_rec_per_page=2;

if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $num_rec_per_page; 

$sql = "SELECT * from crewlist ORDER BY name ASC LIMIT $start_from, $num_rec_per_page";

$result = $conn->query($sql);

?>

and

 <?php 
    $sql = "SELECT * FROM crewlist"; 
    $rs_result = mysql_query($sql); //run the query
    $total_records = mysql_num_rows($rs_result);  //count number of records
    $total_pages = ceil($total_records / $num_rec_per_page); 

    echo "<a href='dataload2.php?page=1'>".'|<'."</a> "; // Goto 1st page  

    for ($i=1; $i<=$total_pages; $i++) { 
                echo "<a href='dataload2.php?page=".$i."'>".$i."</a> "; 
    }; 
    echo "<a href='dataload2.php?page=$total_pages'>".'>|'."</a> "; // Goto last page
    ?>

EDIT: update syntax

 <?php 
$sql = "SELECT * FROM crewlist"; 
$rs_result = mysqli_query($sql); //run the query
$total_records = mysqli_num_rows($rs_result);  //count number of records
$total_pages = ceil($total_records / $num_rec_per_page); 

echo "<a href='dataload2.php?page=1'>".'|<'."</a> "; // Goto 1st page  

for ($i=1; $i<=$total_pages; $i++) { 
            echo "<a href='dataload2.php?page=".$i."'>".$i."</a> "; 
}; 
?>
<?php
echo "<a href='dataload2.php?page=$total_pages'>".'>|'."</a> "; // Goto last page
?>

You're mixing MySQL APIs here. Your connection could be MySQLi_ (seeing `$conn->query($sql)`), while you're using `mysql_` in the other. Those different APIs don't intermix. — Funk Forty Niner, May 01 '16 at 18:27
update your question with the new code you're now using then. — Funk Forty Niner, May 01 '16 at 18:42
`mysqli_query($sql);` requires db connection `mysqli_query($conn, $sql);` — Funk Forty Niner, May 01 '16 at 18:58

score 1 · Accepted Answer · edited May 23 '17 at 12:07

As per your edit:

$rs_result = mysqli_query($sql);

mysqli_query() requires a db connection be passed as the first parameter

Change your code to read as:

$rs_result = mysqli_query($conn, $sql);

and you'll be good to go.

Reference:

http://php.net/manual/en/mysqli.query.php

Plus, do read up on prepared statements, or PDO with prepared statements as you could get hit by an SQL injection.

Best to be on the safe side ;-)

Additional references:

pagination works but it doesn't go to next page

1 Answers1