how to prepare a query to json postgresql field in php

Question

I am having a problem creating a query in PHP to retrieve a json value from a postgresql database.

The problem is within the json WHERE clause of the following simple query

select * from json_data where jsonfield ? 'roottag';

if i use the PDO prepare:

$query->prepare($sqlSelect);

PDO will translate the ? (postgres json operator to see if the json field starts with a specific tag) to $1.

How do i write a sql statement similar to the one above to be used within php PDO?

How about read the docs first? php.net/manual/en/pdo.prepare.php — Felippe Duarte
– Felippe Duarte, Commented Jan 27, 2017 at 18:07
@FelippeDuarte Apologies, i did read that page, but have not understand how to avoid that prepare() translates the "?" — Alienpenguin
– Alienpenguin, Commented Jan 27, 2017 at 18:15

david.wosnitza · Accepted Answer · 2017-07-09 00:07:27Z

2

To safe other people some time: A PATCH IS ON THE WAY! (at the time of writing)

answered Jul 9, 2017 at 0:07

david.wosnitza

7634 silver badges10 bronze badges

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

1 Answer 1