Sometimes, we want to apply bindValue method in LIMIT clause with PHP.

In this article, we’ll look at how to apply bindValue method in LIMIT clause with PHP.

How to apply bindValue method in LIMIT clause with PHP?

To apply bindValue method in LIMIT clause with PHP, we convert the value we use with limit into an integer.

For instance, we write

$fetchPictures = $PDO->prepare("SELECT * 
    FROM pictures 
    WHERE album = :albumId 
    ORDER BY id ASC 
    LIMIT :skip, :max");

$fetchPictures->bindValue(':albumId', $_GET['albumid'], PDO::PARAM_INT);

if(isset($_GET['skip'])) {
    $fetchPictures->bindValue(':skip', (int) trim($_GET['skip']), PDO::PARAM_INT);
} else {
    $fetchPictures->bindValue(':skip', 0, PDO::PARAM_INT);  
}

$fetchPictures->bindValue(':max', $max, PDO::PARAM_INT);
$fetchPictures->execute() or die(print_r($fetchPictures->errorInfo()));
$pictures = $fetchPictures->fetchAll(PDO::FETCH_ASSOC);

to write

$fetchPictures->bindValue(':skip', (int) trim($_GET['skip']), PDO::PARAM_INT);

to bind the value of the :skip placeholder to the $_GET array’s skip value.

We convert it to an int with (int) so that there won’t be any data type errors when calling bindValue.

Conclusion

To apply bindValue method in LIMIT clause with PHP, we convert the value we use with limit into an integer.