How to use PHP array in Postgres select

Question

I try to use a php array in a postgres select statement.

I tried:

$sql = "SELECT * FROM some_table WHERE string_field IN ($1) AND other_field = $2;";

$result = pg_query_params($conn, $sql, array(implode(',', $my_arr), $other_field));

But when i run it nothing returns. (when I hardtype everything in postgres, something will be returned)

What "doesn't work" about it? What is the specific error you receive? — random_user_name, May 02 '16 at 14:19
See http://stackoverflow.com/questions/31643297/pg-query-result-contains-strings-instead-of-integer-numeric#31740990 for an example with proper array content escaping and PHP conversion. — greg, May 04 '16 at 12:50

score 1 · Accepted Answer · answered May 02 '16 at 14:20

1

Strings needs single quotes as I know. Concat the elements of array like this:

$data = ['a','b','c','d'];
$x = "'" . implode("','", $data) . "'";
var_dump($x);

Result:

'a','b','c','d'

answered May 02 '16 at 14:20

vaso123

12,347
4
34
64

anyway, first let's check, are there values in your array! – vaso123 May 02 '16 at 14:35
Until there is a quote in your array value strings… – greg May 04 '16 at 12:51
OP should handle this in `$my_arr` with an `array_map` for escape. I just told him how to join the pieces for strings. – vaso123 May 04 '16 at 13:01

How to use PHP array in Postgres select

1 Answers1