How to process array returned from pgsql?

Question

in php i get an array from pgsql:

$res = $db
    ->query( "SELECT myarray FROM arrays WHERE array_name=smth" )
    ->fetchRow();
exit (json_encode($res));

Type in pgsql is integer[]

But in JS I get JSON with one string "{1,2,3,...,}" How to get in 'array-way' this data?

bobflux · Accepted Answer · 2011-05-02 17:00:43Z

2

PDO does not do any kind of type translation, everything is returned as strings. So you will have to parse the string using explode() and build a PHP array yourself.

answered May 2, 2011 at 17:00

bobflux

11.6k3 gold badges31 silver badges33 bronze badges

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

Comments

zod · Accepted Answer · 2011-05-02 16:59:04Z

1

json_encode Returns a JSON encoded string on success.

Assign the values returned by fetchrow() to a variable and try to print it before json_encode . it will be an array!!!

answered May 2, 2011 at 16:59

zod

12.5k25 gold badges74 silver badges107 bronze badges

Comments

Pedro M. Silva · Accepted Answer · 2011-05-02 17:04:07Z

1

If you want to get the JSON decoded to an array in JavaScript, you can simply use the function eval(). But first you should make sure it is a JSON string. See more: http://json.org/js.html

answered May 2, 2011 at 17:04

Pedro M. Silva

1,2982 gold badges12 silver badges23 bronze badges

2 Comments

Eugene Over a year ago

problem is that php get not array() from pgsql but string. I want to get php array and that json_encode will do everything for me without eval

Pedro M. Silva Over a year ago

Why don't you serialize the variable before insert it into the database, and then you just have to reverse it. Check serialize() and unserialize(). If you don't want to do that, you'll need to parse them manually.

Eugene Manuilov · Accepted Answer · 2011-06-26 12:26:12Z

0

You can use something like this:

$php_array = json_decode( str_replace( 
    array( '[',      ']',      '{', '}' ), 
    array( '\u005B', '\u005D', '[', ']' ), 
    $your_pgsql_array 
) );

answered Jun 26, 2011 at 12:26

Eugene Manuilov

4,3598 gold badges35 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to process array returned from pgsql?

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related