Laravel 5.1 - Simple SQL Query gives errors

Question

Trying to run a simple SQL query, but I keep getting the same error and I can't find a solution.

The Query

    $user_id = Auth::user()->id;
    $article_id = Request::input('articleId');
    $results = DB::select('select *
                          from favorites
                          where user_id = $user_id AND article_id = $article_id');

The variables $user_id and $article_id work, I tested that by echo'ing them.

The error I'm getting

SQLSTATE[42S22]: Column not found: 1054 Unknown column '$user_id' in 'where clause' (SQL: select * from favorites where user_id = $user_id AND article_id = $article_id)

my favorites table

How can I solve this issue? Thanks in advance

Alex · Accepted Answer · 2015-10-23 13:50:07Z

3

You should either use double qoutes:

"select *
from favorites
where user_id = $user_id AND article_id = $article_id"

or single with concatenation

'select *
from favorites
where user_id = '.$user_id.' AND article_id = '.$article_id ;

answered Oct 23, 2015 at 13:50

Alex

17.3k1 gold badge31 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Baker Over a year ago

Or better yet, create a Favourites model and then use Eloquent

Collectives™ on Stack Overflow

Laravel 5.1 - Simple SQL Query gives errors

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related