How to Bind parameters to a Raw Query?

Do this,

DB::select('select * from test where mid=? and created>? where id=5 group by type', [$member, $from] )

not sure what you are trying to do. Hopefully this will help you

Hi petrit,

Thanks for your answer. Actually what I've pasted there is just 10% of the query that I'm using now. So I need my above syntax, can't change that.

Is there any way that I can use named bindings with my above syntax?

Cheers.

It has to be

$this->select('name',
     DB::raw("(
        SELECT  COUNT(id)
        FROM    test 
        WHERE   mid = :member AND created > :from AND created < :to
        ) as numbers", ["member" => $member, "from" => $from, "to" => $to])
)
->where('id', '=', '5')
->groupBy('type');

Notice the array passed with values. It has to be without :

it still shows the error for me

    $Schedule = \DB::select(DB::raw("SELECT * FROM schedule where from_datetime <=:cd AND to_datetime >=:cd AND status = 1 AND id IN (SELECT MAX(id) FROM schedule WHERE is_deleted = 0 AND from_datetime <=:cd AND to_datetime >=:cd AND status = 1 GROUP BY display_serial,type ) ORDER BY id DESC"),['cd'=>$current_date]);

DB::raw doesn't have a parameter for bindings so ["member" => $member, "from" => $from, "to" => $to] will be ignored.

To use bindings you can try selectRaw() as suggested in Laravel Docs, the only downside is thatselectRaw doesn't allow named parameters.

$this->selectRaw('name, (
        SELECT  COUNT(id)
        FROM    test 
        WHERE   mid = ? AND created > ? AND created < ?
    ) as numbers', [$member, $from, $to])
)
->where('id', '=', '5')
->groupBy('type');