PostgreSql All returning results are "Array"

Question

I have this piece of code

<?

    $db = pg_connect("host=h port=p dbname=dbn user=usr password=pass");

    if ($db) {
        echo 'Connection attempt succeeded.' . '<br>' . '<br>';
    }
    else{   
        echo 'Connection attempt failed.' . '<br>' . '<br>';   
    }

    $query = "SELECT column1 FROM table";  
    $result = pg_query($db, $query);
    while ($row = pg_fetch_array($result)) echo $row. '<br>'. '<br>';

    echo pg_dbname($db). '<br>' ;
    echo pg_get_pid($db);
?>

The result should be three numeric values. When I run it, all I get are three strings "Array".

Connection attempt succeeded.

Array

Array

Array

dbname

pid

Can anyone help, please?

use echo $row['column1'] and don't echo the array use instead print_r/var_dump functions — Tamil Selvan C
– Tamil Selvan C, Commented Mar 1, 2014 at 14:32

Adam · Accepted Answer · 2013-10-04 11:34:05Z

3

DO:

while ($row = pg_fetch_all($result)) echo $row['column1']. '<br>'. '<br>';

OR debug:

while ($row = pg_fetch_all($result)) var_dump($row) . '<br>'. '<br>';

answered Oct 4, 2013 at 11:34

Adam

1,3712 gold badges11 silver badges12 bronze badges

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

1 Comment

Adam Over a year ago

Super. I'm glad I can help :)

Collectives™ on Stack Overflow

PostgreSql All returning results are "Array"

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related