How can I use join and where together - Laravel?

Question

I want to establish a relationship between two tables. So I want to bring blogs with status = 1. How can I do that. My categories table looks like

id|category_name|status|
1 |Animals      |   0     
2 |Education    |   1     
3 |Water        |   0

My blogs table looks like

id|category_id|title      | description         |
1 |   1       |New Post 1 | Post description 1  |
2 |   2       |New Post 2 | Post description 1  |
3 |   3       |New Post 3 | Post description 1  |
4 |   2       |New Post 4 | Post description 1  |

How do I list blogs provided that where('status', 1) from categories table? Please help me. thanks for your help.

mean you want blog list which category status=1..?

Karan
– Karan

2020-01-11 05:00:55 +00:00
Commented Jan 11, 2020 at 5:00 — Karan
– Karan, Commented Jan 11, 2020 at 5:00
Yes like you said. below solution was provided thanks :)

ufuk
– ufuk

2020-01-11 05:07:43 +00:00
Commented Jan 11, 2020 at 5:07 — ufuk
– ufuk, Commented Jan 11, 2020 at 5:07

ufuk · Accepted Answer · 2020-01-11 08:01:22Z

1

Hi you can write query with query builder in Laravel, Please see below code


$whereData= [
  ['categories.status',1]
];

$getData = Blog::join("categories",'categories.id', '=', 'blogs.category_id')
->where($whereData)
->get();

Above code is tested and worked.

I hope it will help you.

Thanks.

edited Jan 11, 2020 at 8:01

ufuk

3713 silver badges20 bronze badges

answered Jan 11, 2020 at 5:02

Vinit Joshi

915 bronze badges

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

3 Comments

ufuk Over a year ago

$getData = Blog::join("categories",'categories.id', '=', 'blogs.category_id') ->where('categories.status',1) ->orderBy('id', 'desc')->take(6)->get(); This is how I can get the last 6 . This code is giving an error.

Vinit Joshi Over a year ago

i think issue is in " orderBy('id', 'desc') " , you should try categories.id or blogs.id instead of 'id' in orderBy

ufuk Over a year ago

$getData = Blog::join("categories",'categories.id', '=', 'blogs.category_id') ->where('categories.status',1) ->orderBy('blogs.id', 'desc')->take(6)->get(); Thanks for trying it corrected this way.

vaishali tilala · Accepted Answer · 2020-01-11 05:36:36Z

0

$data = DB::table('categories')
->join('blog', 'blog.category_id', '=','categories.id')
->select('blog.*', 'categories.category_name')->where('categories.status',1)->get();

Above code may help you.

answered Jan 11, 2020 at 5:36

vaishali tilala

1

Collectives™ on Stack Overflow

How can I use join and where together - Laravel?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related