Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('Database.php');
- require_once('Paginator.php');
- $database = Database::getInstance();
- $conn = $database->getConnection();
- $page = $_GET['page'] ?: 1;
- $paginator = new Paginator($conn);
- $paginator->setQuery('SELECT * FROM users');
- $result = $paginator->getResult($page);
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="UTF-8">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta http-equiv="X-UA-Compatible" content="ie=edge">
- <title>Document</title>
- <style>
- table {
- border-collapse: collapse;
- }
- table td,
- table th {
- border: 1px solid #ddd;
- padding: 8px;
- }
- </style>
- </head>
- <body>
- <table>
- <thead>
- <tr>
- <td>Name</td>
- <td>Username</td>
- <td>Email</td>
- </tr>
- </thead>
- <tbody>
- <?php foreach ($result->data as $row): ?>
- <tr>
- <td><?php echo $row->name; ?></td>
- <td><?php echo $row->username; ?></td>
- <td><?php echo $row->email; ?></td>
- </tr>
- <?php endforeach; ?>
- </tbody>
- </table>
- <br />
- <?php echo $paginator->links(); ?>
- <br />
- <p>Current Page: <?php echo $result->page; ?></p>
- <p>Limit: <?php echo $result->limit; ?></p>
- <p>Total Items: <?php echo $result->total; ?></p>
- <p>Total Pages: <?php echo $result->pages; ?></p>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement