Convert SQL to Eloquent Query Builder : Laravel5.5

Question

How can I convert this SQL to Laravel5.5 Eloquent format

select * from 'arm_articles' where ('article_tag' like '%standard%' or 'article_topic' like '%standard%' or 'article_details' like '%standard%' or 'article_type' like '%standard%') and ( ('id' between 287 and 296) and 'article_active' = 1) order by 'id' desc

Please observer the braces in the SQL

This is the one i wrote that returns a different sql when i tested the output using ->toSql

$post= PostModel::where('article_tag','like','%'.$contributor_id.'%')->orWhere('article_topic','like','%'.$contributor_id.'%')->orWhere('article_details','like','%'.$contributor_id.'%')->orWhere('article_type','like','%'.$contributor_id.'%')->whereBetween('id', [$end, $start-1])->where('article_active',1)->orderBy('id', 'desc')->take(10)->get();

Find the SQL output from the query above

select * from 'arm_articles' where 'article_tag' like ? or 'article_topic' like ? or 'article_details' like ? or 'article_type' like ? and 'id' between ? and ? and 'article_active' = ? order by 'id' desc limit 10

This output looks like the needed SQL, but the different is the braces on the SQL. so one coin the Eloquent Query Builder to come out with the braces on the query ?

You can also use this online tool in oder to convert your raw SQL into Laravel Builder: midnightcowboycoder.com — Hackerman
– Hackerman, Commented Feb 26, 2018 at 17:16

Alexey Mezenin · Accepted Answer · 2018-02-26 17:14:36Z

5

Use the where() closure for parameter grouping:

PostModel::where(function($q) use($contributor_id) {
        $q->where('article_tag', 'like', '%' . $contributor_id . '%')
          ->orWhere('article_topic', 'like', '%' . $contributor_id . '%')
          ->orWhere('article_details', 'like', '%' . $contributor_id . '%')
          ->orWhere('article_type', 'like', '%' . $contributor_id . '%');
    })
    ->whereBetween('id', [$end, $start - 1])
    ->where('article_active', 1)
    ->orderBy('id', 'desc')
    ->take(10)
    ->get();

answered Feb 26, 2018 at 17:14

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

1 Comment

Ahmed Shams Over a year ago

stackoverflow.com/questions/48975428/… can you see my ques.?

Unai Susperregi · Accepted Answer · 2018-02-26 17:18:49Z

3

Try with this

$post = PostModel::where(function ($query) use ($contributor_id) {              
          $query->orWhere('article_topic','like','%'.$contributor_id.'%')
          ->orWhere('article_details','like','%'.$contributor_id.'%')
          ->orWhere('article_type','like','%'.$contributor_id.'%')
          ->orwhere('article_tag','like','%'.$contributor_id.'%');
        })->whereBetween('id', [$end, $start-1])
        ->where('article_active',1)
        ->orderBy('id', 'desc')
        ->take(10)
        ->get();

Alexey Mezenin did it before me.

answered Feb 26, 2018 at 17:18

Unai Susperregi

4045 silver badges18 bronze badges

Collectives™ on Stack Overflow

Convert SQL to Eloquent Query Builder : Laravel5.5

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related