Message:

This question already has answers here:

My Answer:
- How to use LIMIT in a PDO query with placeholders?
- PDO prepared statement with LIMIT clause not working as expected

You can try using the following code to use LIMIT in a PDO prepared statement with fetchAll:

php

$stmt = $pdo->prepare("SELECT * FROM table_name LIMIT :limit");

$stmt->bindValue(':limit', $limit, PDO::PARAM_INT);

$stmt->execute();

$results = $stmt->fetchAll();

Make sure to replace `table_name` with your actual table name and `limit` with the desired limit value. This should work properly with fetchAll and the LIMIT clause in PDO prepared statements.

Rate this post

4 of 5 based on 3225 votes

John Davidson

php - My PDO Prepared Statement is not working with a fetchALL and Limit