Pagination with PHP

PHP
1

ok I’ve got this database table named data containing six rows!
what i want paginate the data & display only two columns from the table! I’m giving my code, it displays the table Header row only with no data inside.

<?php

$connection = mysql_connect("localhost","root","");
if(!$connection){
('Could not connect: ' . mysql_error());
}
mysql_select_db("mydata",$connection);

 
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * 5; 
$sql = "SELECT * FROM data ORDER BY roll ASC LIMIT $start_from, 5"; 
$rs_result = mysql_query ($sql,$connection); 
?> 
<table border=2 bgcolor="lightblue" font-family="tahoma">
<tr><td>year</td><td>roll</td></tr>
<?php 
while ($row = mysql_fetch_assoc($rs_result)) { 
?> 
            <tr>
            <td><? echo $row["year"]; ?></td>
            <td><? echo $row["roll"]; ?></td>
            </tr>
<?php 
}; 
?> 
</table>
<?php 
$sql = "SELECT COUNT(roll) FROM data"; 
$rs_result = mysql_query($sql,$connection); 
$row = mysql_fetch_row($rs_result); 
$total_records = $row[0]; 
$total_pages = ceil($total_records / 5); 
 
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<a href='index.php?page=".$i."'>".$i."</a> "; 
}; 
?>
2

If you are on the first page then you are selecting zero results. Without $_GET[‘page’], you set $page to equal 1, then in your $start_from variable you are deducting 1 from the number stored in the $page variable and then multiplying by 5. so, on your first page $page = 1, you then deduct 1 which will give you $page = 0 and then multiply by 5 which will give you $start_from = 0 (5 * 0 = 0).

3

is this one alright?

if (isset($_GET[“page”])) { $page = $_GET[“page”]; } else { $page=1; };
$start_from = ($page);
$sql = “SELECT * FROM data ORDER BY roll ASC LIMIT $start_from, 1”;
$rs_result = mysql_query ($sql,$connection);

4

I don’t think so based on what you were trying to do. If you want 5 records per page:

if (isset($_GET["page"])) { $page  = $_GET["page"];
$start_from = ($page * 5) - 4;  
}else { 
$start_from=0; 
}
$sql = "SELECT * FROM data ORDER BY roll ASC LIMIT $start_from, 5";
5

Did that! The table increases in size as if it shows 1 data, but actually is blank now! nothing shows up in that row! Code again!

<?php

$connection = mysql_connect("localhost","root","");
if(!$connection){
('Could not connect: ' . mysql_error());
}
mysql_select_db("mydata",$connection);

 


if (isset($_GET["page"])) { $page  = $_GET["page"];
$start_from = ($page * 5) - 4;  
}else { 
$start_from=0; 
}
$sql = "SELECT * FROM data ORDER BY roll ASC LIMIT $start_from, 5";  
$rs_result = mysql_query ($sql,$connection); 
?> 
<table border=2 bgcolor="lightblue" font-family="tahoma">
<tr><td>year</td><td>roll</td></tr>
<?php 
while ($row = mysql_fetch_assoc($rs_result)) { 
?> 
            <tr>
            <td><? echo $row["year"]; ?></td>
            <td><? echo $row["roll"]; ?></td>
            </tr>
<?php 
}; 
?> 
</table>
<?php 
$sql = "SELECT COUNT(roll) FROM data"; 
$rs_result = mysql_query($sql,$connection); 
$row = mysql_fetch_row($rs_result); 
$total_records = $row[0]; 
$total_pages = ceil($total_records / 5); 
 
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<a href='index.php?page=".$i."'>".$i."</a> "; 
}; 
?>

Or if u have ur own code for PHP TABLE PAGINATION WITH MYSQL, please share!

6

Sorry a little confused - are you saying the table has the right number of rows but no data? If that is a case, please use proper PHP opening tags:

<?php

7

No, not the right number of rows, the table sizes increases just a little, as if just showing 1 data only!! Do u have any or know any links for any php pagination tutorial please?

8

I meant your database table, not the html table. What results (or errors) do you get if you run the query in phpMyAdmin?

Sorry, don’t know of any tutorials off the top of my head without searching but you could try the articles and tutorials on this website.