Escape raw SQL queries in Laravel 4

You can quote your strings this way, through the DB facade.

DB::connection()->getPdo()->quote("string to quote");

I did put this answer in my question when I discovered it, however I've now put it in as an actual answer to make it easier for others to find.

php mysql pdo laravel laravel-4

$value = Input::get("userID");$results = DB::select( DB::raw("SELECT * FROM users WHERE users.id = :value"), array(   'value' => $value, ));

More Details HERE

php mysql pdo laravel laravel-4

You may also try this, (Read Documentation)

$results = DB::select('SELECT * FROM users WHERE users.id = ?', array($userId));

CodeHunter