postgresql query

Anon

Why doesn't this work?

<?php
$database = pg_connect ("dbname=sam.db");
$izpis = pg_exec ($database, "SELECT * FROM test");
print "$izpis";

    if (!$database) die("something's gone horribly wrong.");
    else print "<P>Connect successful</P>";

    pg_ErrorMessage();
    pg_close()

All i get is:

Resource id #2

Connect successful

Please Help!

Thanks

Anon

Hi Matej,

The text you have been given is a pointer used by PHP to track the result of your SQL query. You need to break up the results by using one of the pg_fetch_.. commands (choose from array, object or row) to manipulate the data.

Look at it like this - say you queried the database to return 100 records, but you wanted to but the different fields in HTML table cells, just printing the SQL result would just do a dump (if it was allowed by PHP) of the data in no particular format!

Take a peek at the postgreSQL pages in the manual for more advice!

http://www.php.net/manual/en/ref.pgsql.php

Kind Regards,

David Grant

haji_hill

The result of your query is simply a pointer to where the information is in memory. To get the value you have to use the function pg_fetch_array to get the value and sort them according to fields. Then you can pluck values out as you will.

See here for more details:
http://www.php.net/manual/en/function.pg-fetch-array.php

I hope this helps...
-Haji Hill
Linux Sys Admin / $X
AOSS, Inc.

Anon

Thanke you very much David !

That works:
<?php
$database = pg_connect ("dbname=sam.db");
$rezultat = pg_exec ($database, "SELECT * FROM test");

    if (!$database) die("something's gone horribly wrong.");
    else print "<P>Connect successful</P>";

    echo "<TABLE border='1'>";

    for($i=0; $row = @pg_fetch_array($rezultat,$i); $i++)
    {
     echo "<TR><TD>";
     echo $row["id"]; echo "<TD>";
     echo $row["ime"]; echo "<TD>";
     echo $row["priimek"]; 
    }

    echo "</TABLE>";

    pg_ErrorMessage();
    pg_close();

Anon

Thanks it help a lot!

Now i have:

<?php
$database = pg_connect ("dbname=sam.db");
$rezultat = pg_exec ($database, "SELECT * FROM test");

    if (!$database) die("something's gone horribly wrong.");
    else print "<P>Connect successful</P>";

    echo "<TABLE border='1'>";

    for($i=0; $row = @pg_fetch_array($rezultat,$i); $i++)
    {
     echo "<TR><TD>";
     echo $row["id"]; echo "<TD>";
     echo $row["ime"]; echo "<TD>";
     echo $row["priimek"]; 
    }

    echo "</TABLE>";

    pg_ErrorMessage();
    pg_close();