Printing all rows from a Postgres database array

Question

I'm trying to do a simple query from my postgres database, then try to manipulate the data.

Script I made goes as following;

function connectLocalDB() {

    $dbconnection = pg_connect("host=192.168.97.120 port=1337 dbname=x user=x password=x") or die("Unable to connect to Postgres");


    // INPUT table from userDB
    $userINPUTresult = pg_query($dbconnection, "SELECT * FROM \"INPUT\"");
    if (pg_num_rows($userINPUTresult)>0) {

        $userINPUTArray = pg_fetch_array($userINPUTresult);
        print_r($userINPUTArray);

        echo "INPUT CHAIN RULES LOADED \n";

    } else {

        echo ("NO INPUT CHAIN RULES \n");
    }

Now everything goes fine, except the printing only prints out the first row of the Database result set, while I have 3 rows in my database. What am I missing here?

The docs (php.net/pg_query) show you how to iterate a resultset. — Anthony Sterling
– Anthony Sterling, Commented Dec 18, 2013 at 11:46

Dinesh · Accepted Answer · 2013-12-18 11:58:15Z

3

pg_fetch_array() returns an array that corresponds to the fetched row (record) if you have more than 1 record in table you should use while loop

as:

if (pg_num_rows($userINPUTresult)>0) {

        while($userINPUTArray = pg_fetch_array($userINPUTresult))
        {
        print_r($userINPUTArray);

        echo "INPUT CHAIN RULES LOADED \n";
        }
    } else {

        echo ("NO INPUT CHAIN RULES \n");
    }

answered Dec 18, 2013 at 11:58

Dinesh

4,1145 gold badges24 silver badges35 bronze badges

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

1 Comment

MichaelP Over a year ago

Thank you loads. I have to read the documentation on PHP.net more carefully next time.

Collectives™ on Stack Overflow

Printing all rows from a Postgres database 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