How do I pass url-array-parameter to pg_execute

Question

I'm sending my parameters using an URL like test.php?id=2,4,5,6,7

And use the following php :

$id_array = $_GET['id'];
$id_array = explode(',', $id_array);

pg_prepare($conn, 'test', 'select 1 from my_test_table where id = ANY ($1)');
pg_execute($conn, 'test', array($id_array);

I keep getting things like

malformed array literal: "["73","123","412"]"

and similar errors. I can't figure out the proper way to pass an array to my pg_execute, but I need to make sure all ids are in the db first before doing an insert.

Specifically, I'm trying to do an insert into an int array in the postgres db.

Can anyone help with this?

I've also tried

json_encode(explode(',', $id_array));

Community · Accepted Answer · 2017-05-23 11:54:07Z

1

Just this should do it :

pg_prepare($conn, 'test', 
    " SELECT 1 
    FROM my_test_table 
    WHERE id = ANY (string_to_array($1, ',')) ");
pg_execute($conn, 'test', array($_GET['id']));

We use the postgresql string_to_array function, as on the top answer there https://stackoverflow.com/a/36930781/5546267

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Apr 12, 2017 at 19:43

Blag

5,8942 gold badges26 silver badges48 bronze badges

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

1 Comment

DJSweetness Over a year ago

The only change I made is that id is an int so I casted the function like so: string_to_array($1, ',')::int[] . Other than that, that's exactly what I was looking for. Thank you!

Collectives™ on Stack Overflow

How do I pass url-array-parameter to pg_execute

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related