Why is my model scope not working and returning an empty array?

Question

Why do I get an empty collection result using the scope? This is my current controller:

class PunxController extends Controller {
    public function index()
    {
        $scholars = Scholar::age()->get();

        return $scholars;
    }
}

and on my model Scholar:

use Illuminate\Database\Eloquent\Model;

class Scholar extends Model {

    protected $primaryKey = 'scholar_id';
    protected $fillable = ['ngo_id','scholar_lname','scholar_fname','scholar_image','scholar_nickname','scholar_cityAddress','scholar_permaAddress','scholar_birthday','scholar_placebirth','scholar_age','scholar_gender','scholar_email','scholar_contact'];

    public static function scopeAge($query)
    {
        return $query->where('scholar_age', '>=', 5);
    }
}

and the result is:

but when I try on PHPMYADMIN:

Update1

result of DB::getQueryLog():

Try running \DB::enableQueryLog() before you run the query and then use dd(\DB::getQueryLog()) after to see what was actually run. Then post the result here please! — Jonathon
– Jonathon, Commented Sep 21, 2016 at 16:24
Thanks. That query looks right. Which tells me that it's possible not looking at the right database. Are you running your webserver using a VM like vagrant? — Jonathon
– Jonathon, Commented Sep 21, 2016 at 16:53

phaberest · Accepted Answer · 2016-09-21 19:12:17Z

2

Remove the static keyword from your method. Scopes shouldn't be static.

public function scopeAge($query)
{
    return $query->where('scholar_age', '>=', 5);
}

I'm guessing you would like to provide 5 as a parameter to the scope rather than hard-coding it. In which case you can do:

public function scopeAge($query, $age)
{
    return $query->where('scholar_age', '>=', $age);
}

And call it like

Scholar::age(5)->get();

edited Sep 21, 2016 at 19:12

phaberest

3,2203 gold badges35 silver badges42 bronze badges

answered Sep 21, 2016 at 18:44

Jonathon

16.4k12 gold badges78 silver badges98 bronze badges

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

Comments

phaberest · Accepted Answer · 2016-09-21 19:53:50Z

0

Try this:

public function scopeAge($query)
{
    return $query->where('scholar_age', '>=', 5);
}

edited Sep 21, 2016 at 19:53

phaberest

3,2203 gold badges35 silver badges42 bronze badges

answered Sep 21, 2016 at 17:05

5a494d

1

Collectives™ on Stack Overflow

Why is my model scope not working and returning an empty array?

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