print query in laravel

Question

I want to print my query on laravel and my query is DB::table('avt_channel_billing_address')->where('channel_id',$channel_id)->update($channelList) where $channel is an array of values.

I tried using dd(DB::getQueryLog()) and toSql .None print the query.

@imrealashu i tried this DB::table('avt_channel_billing_address')->where('channel_id',$channel_id)->update($channelList)->toSql(); Didnt work — Biswa
– Biswa, Commented Nov 3, 2016 at 12:41
I've posted a answer. Try that once. I've tried locally it worked fine for me. — imrealashu
– imrealashu, Commented Nov 3, 2016 at 12:42

Amit Gupta · Accepted Answer · 2016-11-03 18:04:12Z

9

DB::enableQueryLog();
DB::table('avt_channel_billing_address')->where('channel_id',$channel_id)->update($channelList)
dd(DB::getQueryLog())

Docs

edited Nov 3, 2016 at 18:04

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

answered Nov 3, 2016 at 12:41

imrealashu

5,0994 gold badges18 silver badges28 bronze badges

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

Comments

Abu Sufian · Accepted Answer · 2021-10-07 12:33:29Z

4

$query = User::select("*")->toSql();
dd($query);

Another way:

DB::enableQueryLog();
$users = User::select("*")->get();
$quries = DB::getQueryLog();
dd($quries)

answered Oct 7, 2021 at 12:33

Abu Sufian

4635 silver badges8 bronze badges

Comments

Gijs de Jong · Accepted Answer · 2016-11-03 12:42:26Z

1

You may have to turn it on: DB::enableQueryLog(); and than call DB::getQueryLog()

answered Nov 3, 2016 at 12:42

Gijs de Jong

1,03710 silver badges16 bronze badges

Collectives™ on Stack Overflow

print query in laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related