PHP UrlEncode and UrlDecode are not accepting the word NULL in an SQL String submitted with GUZZLE

34 Views Asked by At

So I'm passing in a Query where there is the condition

where X is NULL

is the condition at the end of the SQL.... it is using

"{"query":"".urlencode($this->query)."","ods":"" . urlencode(serialize($this->ods)) . "","key":"".getenv('ODS_COURSE_INTERNAL_API_KEY').""}"

in the GUZZLE to post the query and some other things to a backend API.

Fails and nothing shows up at the backend but says the call is successful.....

When I remove the NULL it runs fine and returns data. I also ran the query in SQLDeveloper and the query returns data with and without the NULL.....

Thoughts?

0

There are 0 best solutions below