PHP框架如何实现分页功能_PHP框架分页功能实现代码与技巧

use Illuminate\Http\Request;
use App\Models\Post;
<p>public function index(Request $request)
{
// 每页显示10条记录
$posts = Post::paginate(10);</p><pre class='brush:php;toolbar:false;'>return view('posts.index', compact('posts'));

<div class="pagination">
    {!! $posts->links() !!}
</div>

$perPage = $request->input('limit', 10); // 默认10条
$posts = Post::paginate($perPage);

use app\model\Post;
<p>public function index()
{
$list = Post::order('id', 'desc')
->paginate([
'list_rows' => 10,     // 每页数量
'page'      => input('page', 1),
]);</p><pre class='brush:php;toolbar:false;'>return view('index', ['list' => $list]);

<div class="pagination">
    {$list|raw}
</div>

$page = (int)($_GET['page'] ?? 1);
$limit = 10;
$offset = ($page - 1) * $limit;

$total = $pdo->query("SELECT COUNT(*) FROM posts")->fetchColumn();
$sql = "SELECT * FROM posts ORDER BY id DESC LIMIT ? OFFSET ?";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(1, $limit, PDO::PARAM_INT);
$stmt->bindValue(2, $offset, PDO::PARAM_INT);
$stmt->execute();
$posts = $stmt->fetchAll();

$totalPages = ceil($total / $limit);
<p>for ($i = 1; $i <= $totalPages; $i++) {
echo "<a href='?page={$i}'>{$i}</a> ";
}</p>