Laravel get sql query with argument bindings

Question

I have build a query which then will be used as subquery. So it is needed to be transfromed to sql. When I call toSql method it shows me such sql query

"select * from `product_variant_values` where 
(`option_id` = ? and `value_id` = ?)
 or (`option_id` = ? and `value_id` = ?) 
or (`option_id` = ? and `value_id` = ?)"

But I want so that instead of ? signs there will be real arguments. How can I do this?

Ezequiel Moreno · Accepted Answer · 2015-12-03 15:42:08Z

2

You cannot obtain the SQL with the prepared values filled. You may use getBindings for obtaining the values and replacing it in your query.

answered Dec 3, 2015 at 15:42

Ezequiel Moreno

2,39822 silver badges28 bronze badges

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

1 Comment

FreeLightman Over a year ago

Very helpful. I know setBindings, but did not think about getBindings. Now i can prepend bindings of subquery with main query and everything works.

Chung · Accepted Answer · 2015-12-04 14:51:40Z

0

just a cheating way.

You can edit your query to get a syntax error. You can see your query with all arguments

answered Dec 4, 2015 at 14:51

Chung

9751 gold badge12 silver badges22 bronze badges

1 Comment

FreeLightman Over a year ago

If I needed to see the query I would use a debugger. But I need to use it as subquery with all bindings. So it is not an answer.

Collectives™ on Stack Overflow

Laravel get sql query with argument bindings

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related