Exemplo n.º 1
0
include_once '../classes/users.php';
include_once '../classes/room.php';
$room = new room();
$users = new users();
$page = isset($_GET['page']) ? $_GET['page'] : 1;
if ($page == "" || $page == "1") {
    $page1 = 0;
} else {
    $page1 = $page * 5 - 5;
}
$query = $users->select_all_users($page1);
$count = mysqli_num_fields($query);
$counting = ceil($count / 5);
while ($row = mysqli_fetch_array($query)) {
    echo "<tr> \n\t<td> {$row['1']}</td>";
    $rooms = $room->select_room($row[6]);
    while ($row1 = mysqli_fetch_array($rooms)) {
        echo "  <td>{$row1['1']}</td>  ";
    }
    echo "<td><img src=uploads/{$row['4']}  width=60px height=45px></td>\n\t<td>{$row['5']}</td>\n\t<td> <a href='add_user_update.php?user_id=" . $row['user_id'] . "' class=' btn btn-primary'> Edit</a>\n\t<a href='deleteuser.php?user_id=" . $row['user_id'] . "' class=' btn btn-primary'> Delete</a>\n\n</td>\n  \t </tr>";
}
?>
    </table>
</div>
<div class="pag">
    <ul class="pagination">
        <?php 
for ($index = 1; $index <= $counting; $index++) {
    echo " <li><a href='all_user.php?page={$index}'> " . $index . "</a></li>";
}
?>