Laravel查询我的变量

Question

Controller:

public function getSpecificPost($id)
{
    $returnArray = with(new Posts)->getSpecificPost($id);

    print_r($returnArray);
}
?>

Model:

public function getSpecificPost($post_id)
{
   //exit($post_id);
   return DB::table('posts')->where('id', $post_id)->toSql();
}
?>

If I uncomment the exit, it gives me a 1 as return. When I comment the exit I of course get a query, the query is as follows:

select * frompostswhereid= ?

Its Laravel Framework, help me out please!

Answer 1

The ? is a placeholder for your variable. It will be replaced with (in this case) 1. See the colored block on this page:

Note: The Laravel query builder uses PDO parameter binding throughout to protect your application against SQL injection attacks. There is no need to clean strings being passed as bindings.

You are aware of the fact that your don't actually execute the query? If you want to get the specific post with $post_id, you can change the line in your model to this one:

return DB::table('posts')->where('id', $post_id)->first();

If you want to see all executed queries (with replaced variables!) with Eloquent, you can use Laravel PHP Debugbar.