Skip to main content

PHP PDO LIMIT

By

Had an issue with PDO and MySQL SELECT statement while using LIMIT in it.
It threw an exception while I tried to bind the parameter like I normally do.


$pdo = $db->prepare("SELECT * FROM table LIMIT :limit");
$pdo->bindValue('limit', $limit, PDO::PARAM_INT)
$pdo->execute();

From here I found a solution. It is necessary to cast the parameter $limit. Like this..

$pdo->bindValue('limit', (int) $limit, PDO::PARAM_INT)

Comments

Post a Comment

Popular posts from this blog

How to run Laravel and Angular app on the same development host?

By
I had to build a quick demo using Angular . I decided to use Laravel as back end for my app. Setup Setup went easy. I used  angular2-seed for Angular. Cloned it using git. $ git clone https://github.com/angular/angular2-seed.git my-demo-app-gui With command "npm start" after "npm install" in the "my-demo-app-gui" folder I got my angular application running locally - http://localhost:3000. To create a new Laravel project I used following command line command: "laravel new my-demo-app-web" to create PHP server side for my project. In folder I just created, I executed following command: "php -S localhost:8000 -t public" to start local back end server -  http://localhost:8000. So far everything went smoothly. So I started build something amazing, like script of Laravel is suggesting before it is finishing its job. Since the goal for me was to build a web application that will get its data from the back end of the same hos...
2 comments
Read more