Postgres query in php with a date variable

Question

Can you please help me on below query?

php code://

$countdate='2017-01-03';
$countsql='SELECT rucid,"databaseType","countLoggedOn","prodCount","nprodCount","countType" FROM "ru_countLog" WHERE "countLoggedOn"=$countdate';

--> It's giving syntax error

syntax error at or near "$" LINE 1: ...untType" FROM "ru_countLog" WHERE "countLoggedOn"=$countdate

syntax error at or near "$" LINE 1: ...untType" FROM "ru_countLog" WHERE "countLoggedOn"=$countdate — Sampad Das
– Sampad Das, Commented Jan 4, 2017 at 10:02

Seth Difley · Accepted Answer · 2017-01-04 15:44:21Z

1

Remove the internal double quotes from your query:

$countsql = "SELECT rucid, databaseType, countLoggedOn,
             prodCount, nprodCount, countType
             FROM ru_countLog
             WHERE countLoggedOn = $countdate";

Note that this query is vulnerable to SQL injection. Consider parametrizing $countdate. With http://php.net/manual/en/function.pg-query-params.php , this would become

$countsql = 'SELECT rucid, databaseType, countLoggedOn,
         prodCount, nprodCount, countType
         FROM ru_countLog
         WHERE countLoggedOn = $1';

$result = pg_query_params($dbconn, $countsql, array($countdate));

where $dbconn is your database connection

edited Jan 4, 2017 at 15:44

answered Jan 4, 2017 at 15:41

Seth Difley

1,3301 gold badge24 silver badges33 bronze badges

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

1 Comment

ceejayoz Over a year ago

$countdate will not be interpreted in your first code sample, as it's within a single-quoted string.

gobliggg · Accepted Answer · 2017-01-04 15:37:24Z

0

Maybe you should try like this

$countdate='2017-01-03';
$countsql='SELECT rucid,"databaseType","countLoggedOn","prodCount","nprodCount","countType" FROM "ru_countLog" WHERE "countLoggedOn"='.$countdate;

Hope this help

answered Jan 4, 2017 at 15:37

gobliggg

2472 silver badges13 bronze badges

Collectives™ on Stack Overflow

Postgres query in php with a date variable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related