用户的PHP分页？

Question

I've tried to make a pagination with PHP, but it seems to not work. I want to limit my data which showing in each page, I have this code and it uses PHP code:

showUsers.php

<?php 
$query = mysql_query("select * from users");

while ($data = mysql_fetch_array($query)) {
?>

<td><?php echo $data['no_peg']; ?></td>
<td>
    <?php 
    echo $data['username']; 

    //previlage admin
    if ($_SESSION['role'] == 'admin') {
    ?>
        <div class="row-actions">
        <a href="edit.php?uid=<?php echo $data['id_user'];?>">Edit</a>
        <?php if ($data['role'] != 'admin') {?>
         | <a href="delete.php?uid=<?php echo $data['id_bio'];?>" onClick="return confirm('Hapus akun ini?')" class="delete">Delete</a>
        <?php } ?>
    </div>
    <?php } ?>
</td>
<td><?php echo $data['fullname']; ?></td>
<td><?php echo $data['telephone']; ?></td>
<td><?php echo $data['email']; ?></td>

I want to show just 10 names per page, to avoid long scrolling, but how can it work?

Answer 1

<?php 

$sqlCount = "select count(id_user) from users";   
$rsCount = mysql_fetch_array(mysql_query($sqlCount));  
$totalData = $rsCount[0];  
$page = isset($_GET['page']) ? $_GET['page'] : 1;  
$limit = 10;  
$start_from = $limit * ($page - 1);  
$sql_limit = "SELECT * FROM users limit $start_from, $limit";  
$result = mysql_query($sql_limit);  



        while ($data = mysql_fetch_array($result)) {
        ?>

            <td><?php echo $data['no_peg']; ?></td>
            <td>
                <?php 
                echo $data['username']; 

                //previlage admin
                if ($_SESSION['role'] == 'admin') {
                ?>
                    <div class="row-actions">
                    <a href="edit.php?uid=<?php echo $data['id_user'];?>">Edit</a>
                    <?php if ($data['role'] != 'admin') {?>
                     | <a href="delete.php?uid=<?php echo $data['id_bio'];?>" onClick="return confirm('Hapus akun ini?')" class="delete">Delete</a>
                    <?php } ?>
</div>
<?php } ?>
</td>
<td><?php echo $data['fullname']; ?></td>
<td><?php echo $data['telephone']; ?></td>
            <td><?php echo $data['email']; ?></td>
        </tr>



        <?php 

        } 
        ?>





<?php
$totalPage = ceil($totalData / $limit);  
echo 'Page : ';  
for($i = 1; $i <= $totalPage; $i++){  
if($page != $i){  
echo '[<a href="showUsers.php?page='.$i.'">'.$i.'</a>] ';  
}else{  
echo "[$i] ";  
  }  
 }  
?>