1) ? ($page * $perPage) - $perPage : 0; // Query the database for user data $query = $db->prepare("SELECT * FROM users LIMIT {$start}, {$perPage}"); $query->execute(); $users = $query->fetchAll(PDO::FETCH_ASSOC); // Use the users array to display data on the page foreach ($users as $user) { echo "{$user['name']}
"; } // Display pagination controls $query = $db->prepare("SELECT COUNT(*) FROM users"); $query->execute(); $total = $query->fetchColumn(); $pages = ceil($total / $perPage); echo "