Forum Bind parameter on DB::select(DB::raw())

qlixes

posted 2 years ago

Requests Laravel Eloquent

Last updated 10 months ago.

tvbeek

replied 2 years ago

moderator Solution

The raw method doesn't have a second parameter, see: https://laravel.com/api/8.x/Illuminate/Database/Query/Builder.html#method_raw

I think you can use the whereRaw function:

        $response = DB::table('user_score_events')
            ->whereRaw("score_daily = '?'", [$request->start_date]))
            ->get()
            ;

See the documentation for more raw options: https://laravel.com/docs/8.x/queries#raw-expressions

qlixes

replied 2 years ago

Yes, you're right Sir. I'm sorry for my bad.it's already solved. Thank you a lot

Your banner here too?

qlixes qlixes Joined 11 Sep 2019

Moderators

driesvints Joined 16 Dec 2013
joedixon Joined 23 Jun 2014
tvbeek Joined 8 Jan 2018
tomhatzer Joined 28 Oct 2021

We'd like to thank these amazing companies for supporting us

Your logo here?

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

Twitter GitHub

The community

Laravel

Laravel News

Laracasts

Laravel Podcast