How to write custom query in model Laravel?

Question

I tried to write custom query in model as local scope:

public function scopeLastSync($query)
    {

        return DB::table('clients')
            ->select(DB::raw(
                "select COUNT(*) as total, (SELECT created_at FROM clients ORDER BY created_at DESC LIMIT 1)"
            ))->get();
    }

But it does not work. How to use easy: DB::query("native SQL query")? I tried:

return DB::raw("select COUNT(*) as total, (SELECT created_at AS date_modify FROM clients ORDER BY created_at DESC LIMIT 1)");

Sagar Chamling · Accepted Answer · 2017-06-10 07:46:10Z

4

May be you are searching for this, Write Custom query in laravel 5

For Select --> DB::select('your query here.....');
For Insert --> DB::insert('your query here.....');
For Update --> DB::update('your query here.....');
For Delete --> DB::delete('your query here.....');
For General -->  DB::statement( 'your query here....' );

You don't have to write select inside select(DB::raw(...)). Try:

return DB::table('clients')
            ->select(DB::raw(
                "COUNT(*) as total, (SELECT created_at FROM clients ORDER BY created_at DESC LIMIT 1)"
            ))->get();
    }

But why to do you want to write query of your own if there is powerful Eloquent Model.

edited Jun 10, 2017 at 7:46

answered Jun 10, 2017 at 7:39

Sagar Chamling

1,0682 gold badges12 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

How to write custom query in model Laravel?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related