Laravel mysql select result

Question

I am trying to add a feature to a website built with Laravel. There is a table containing vote numbers and user. I want to get the total points a user has in a certain category. I do not have any PHP or Laravel experience but said I would give this a shot.

$votes1 = UserVotes::select ('select vote from user_votes where feedback_id = ? and feedback_type = 1',  Auth::user()->id);

This should return an object containing the vote amount. I want to interrogate the the object to check if the vote number is above a certain amount and then do something based on that being the case or not.

if vote > 50{
    //do stuff 
}

foreach ($votes1 as $vote1) {
     echo $vote1->vote;
}

The query should return 1. I have verified this by querying the database, so the problem is with my understanding of Laravel or php. What I am doing wrong?

What is the error you get?

John Bupit
– John Bupit

2015-08-14 11:39:11 +00:00
Commented Aug 14, 2015 at 11:39 — John Bupit
– John Bupit, Commented Aug 14, 2015 at 11:39
No error, just an empty object.

redned
– redned

2015-08-14 11:46:51 +00:00
Commented Aug 14, 2015 at 11:46 — redned
– redned, Commented Aug 14, 2015 at 11:46

benJ · Accepted Answer · 2015-08-14 11:46:04Z

2

You don't need to construct your own SQL statement; Eloquent will do that for you.

If your models are set up in the default way, your query would look something like:

$votes = UserVotes::where('feedback_id', Auth::user()->id)
    ->where('feedback_type', 1)
    ->get();

You can then iterate over that as normal.

Additionally, if there is a relationship set up with the user model you could do something like

$votes = Auth::user()->votes()
    ->where('feedback_type', 1)
    ->get();

Check out the documentation here: http://laravel.com/docs/4.2/eloquent

answered Aug 14, 2015 at 11:46

benJ

2,6001 gold badge20 silver badges16 bronze badges

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

Comments

yazfield · Accepted Answer · 2015-08-14 11:45:47Z

2

assuming UsersVotes extends Model, here's how you should do it: UsersVotes::select('vote')->where('feedback_type', 1)->where('feedback_id', Auth::user()->id)-get();

answered Aug 14, 2015 at 11:45

yazfield

1,28312 silver badges19 bronze badges

Collectives™ on Stack Overflow

Laravel mysql select result

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related