pg_query_params returning false

Asked Oct 01 '17 at 12:22

Active Oct 01 '17 at 12:22

Viewed 228 times

I am using this code to check if an email already exists in the DB, but it returns 'false' everytime (it's working on another website).

pg_query_params("SELECT * FROM a_user WHERE LOWER(user_email) = $1", $params);

After the execution of query, value of $params is changing, not sure how.

asked Oct 01 '17 at 12:22

d3corator

Do you have the logs of the database server to check what happens on the DB server side ? – greg Oct 01 '17 at 12:34
2017-10-01 12:39:49 UTC [18136-1] postgres@asif_online ERROR: syntax error at or near "=" at character 29 – d3corator Oct 01 '17 at 12:44
2017-10-01 12:39:49 UTC [18136-2] postgres@asif_online STATEMENT: SELECT * FROM a_user WHERE = $1 – d3corator Oct 01 '17 at 12:44
@greg Here you go. LOWER(user_email) is getting cut out of the statement. – d3corator Oct 01 '17 at 12:45

0 Answers0