PHP每页新闻5 /分页下一页 - 上一页

Question

Is possibile to create PHP pagination system?

With next - prev pagination link? Max 5 news per page.

This is my php code:

<?php
include('config.php');

$query1=mysql_query("select id, name, email , age from addd");
echo "<table><tr><td>Testo</td><td>Nome</td><td>Anni</td></tr>";

function truncate_string($str, $length) {
if (!(strlen($query2['name']) <= $length)) {
$query2['name'] = substr($query2['name'], 0, strpos($query2['name'], '        ', $length)) . '...';
}

return $query2['name'];
}

while($query2=mysql_fetch_array($query1))
{
$number= $query2['name'];
echo "<tr><td>".substr($query2['name'], 0, 500).".....</td>";
echo "<td>".$query2['email']."</td>";
echo "<td>".$query2['age']."</td>";
echo "<td>".str_word_count($number)."</td>";
echo "<td><a href='edit.php?id=".$query2['id']."'>Mod</a></td>";
echo "<td><a href='delete.php?id=".$query2['id']."' onclick=\"return     confirm('Sei sicuro di volerlo eliminare?');\");'>Canc</a></td><tr>";
echo "<td><a href='singletwo.php?id=".$query2['id']."');'>vedi</a></td><     tr>"; }?>

I tried it in different ways , but I failed. I read other answers , but I have been of help.

Answer 1

You can do most of it in your query, for example:

if( isset( $_GET["page"]) ) $PAGE=$_GET["page"]; else $PAGE=1;
$query1=mysqli_query($db,"select id, name, email , age from add LIMIT ". ($PAGE * 5) - 5) .",5");

this will give you pagination. You can then point next and previous links to ?page=n (where n is the next page number).

Hope this helps!