A working query returning null when run through laravel

Question

I am trying to use a simple query with laravel but its not returning any data. but when I run same query in phpmyadmin it returns 3 rows.

This is code in laravel.

 $pages = DB::table('static_pages')
     ->where('slug','=','(select slug from static_pages where id='.$id.')')
         ->get();

this is the query it makes.

  select * from `static_pages` where `slug` = (select slug from static_pages where id=2)

Can you tell me what could be the reason?

@AjayKumar I am new to laravel. I have worked in CI earlier. in CI it was very easy to use models. but here I was only able to make a class and there i put the table name. using just like this : CLASS::where()->get(); — Rohit Thakur
– Rohit Thakur, Commented Sep 21, 2017 at 11:58
you can make model using artisan command like php artisan make:model StaticPage and it will be in app\StaticPage linked to static_pages table the you can access it like StaticPage::where(...)->get() and it's very easy to use instead of using DB — Ajay Kumar
– Ajay Kumar, Commented Sep 21, 2017 at 12:02
but why you are trying to get a page by its slug that you are getting it by its id why not you get the page by its id directly??!! slug and id are unique, so you can get the page by id also?? — HSLM
– HSLM, Commented Sep 21, 2017 at 12:02

omitobi · Accepted Answer · 2017-09-21 13:22:26Z

3

If what you refer to is the relationship between two tables then you might want to look at Laravel Model Relationship, however if you want to retrieve all records having the same slug of the record with id = 2 then you can also do it without using two DB:raw:

DB::table('static_pages')->where('slug', function ($query) {
        return $query->from('static_pages')->where( 'id', '2')->select('slug');
    })->get();

If you want to inspect the sql query it generates then use toSql() instead of ->get()

One evil thing to anticipate is if your inner query returns a collections of values then your comparison might become questionable. However since the field you use to make the query is unique, then this should not be a problem.

Hope this is useful.

edited Sep 21, 2017 at 13:22

answered Sep 21, 2017 at 12:24

omitobi

7,3543 gold badges39 silver badges55 bronze badges

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

Comments

Rohit Thakur · Accepted Answer · 2017-09-21 11:55:21Z

1

It worked by changing from this

 $pages = DB::table('static_pages')->where('slug','=','(select slug from static_pages where id='.$id.')')->get();

to this

$pages = DB::table('static_pages')->where('slug','=',DB::table('static_pages')->where('id','=',$id)->pluck('slug'))->get();

thanks to jishad

answered Sep 21, 2017 at 11:55

Rohit Thakur

215 bronze badges

1 Comment

HSLM Over a year ago

or as simple as: $pages = DB::table('static_pages')->where('slug','=',DB::raw('(select slug from static_pages where id='.$id.')'))->get(); so just ad raw to your code

Gaurav Gupta · Accepted Answer · 2017-09-21 11:53:09Z

0

try this one

DB::table('static_pages')->whereRaw("`slug` = (select slug from static_pages where id=2)")->get();

hope it will help you!

answered Sep 21, 2017 at 11:53

Gaurav Gupta

1,7332 gold badges16 silver badges22 bronze badges

Comments

HSLM · Accepted Answer · 2017-09-21 11:54:13Z

0

you can do this

 $pages = DB::table('static_pages')->where('slug','=',DB::raw('(select slug from static_pages where id='.$id.')'))->get();

answered Sep 21, 2017 at 11:54

HSLM

2,06217 silver badges27 bronze badges

Collectives™ on Stack Overflow

A working query returning null when run through laravel

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related