Array variable inside DB::raw query laravel

Question

I want to predifine $processingStatus array and use it inside Laravel DB::raw query but this gives me the following error-

Syntax error or access violation: 1064 You have an error in your SQL syntax

My query is a large one so I am only pasting the fragment which I guess is causing the error-

DB::raw("COUNT(CASE WHEN (status_change_log.status in $processingStatus) THEN 1 END) AS processing")

My processingStatus variable contains [0 => "S2", 1 => "S13", 2 => "S21"]

Anyone help me out with proper format?

sgClaudia98 · Accepted Answer · 2020-06-09 04:32:04Z

4

Concatenate the string with the php variable

DB::raw("COUNT(CASE WHEN (status_change_log.status in ".$processingStatus.") THEN 1 END) AS processing")

answered Jun 9, 2020 at 4:32

sgClaudia98

2565 silver badges14 bronze badges

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

4 Comments

Raju Ahmed Over a year ago

This doesnt work as it gives Array to string conversion error.

sgClaudia98 Over a year ago

that means the $processingStatus variable is an Array, could you give me more info on what you need from that variable? what field, or print in console that variable, so you see what is it, you need it to be a string to use that value in an SQL statement.

Raju Ahmed Over a year ago

Yes of course. There are some status stored in that variable and the query has to run dynamically. Thats why I have to use a variable. I have edited my qstn and mentioned the elements of the array. Hope that helps.

Raju Ahmed Over a year ago

I needed to convert the array to string and after that it worked. Thanks for your suggestion.

Collectives™ on Stack Overflow

Array variable inside DB::raw query laravel

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related