postgresql error

Anon

Hi. I am having an error and I don\'t know what\'s wrong with the code. The code is:

while($row=pg_fetch_array($sql_result)) {
//this is line 14

$full_name=$rwo[\"Full_Name\"];
$birth_date=$row[\"Birth_date\"];
$fave_color=$row[\"Fave_color\"];

I am getting the following warning:
warning: wrong parameter count for pg_fetch_array() in /home/httpd/html/randall/firstdb.php3 on line 14

pnoeric

Hi Randall, the docs at php.net show that you need two parameters for pg_fetch_array...

array pg_fetch_array (int result, int row [, int result_type])

When in doubt, RTFM :-)

best,
Eric Mueller

smarlowe

Close, but you need to add an incrementing counter to your while loop to make it loop, or use a for next loop.

For next style:

$rows=pg_numrows($sql_result);
for ($i=0;$i<$rows;$i++){
$row=pg_fetch_array($sql_result,$i);
do something here...
}

While loop with increment:

$count=0;
while ($row=pg_fetch_array($sql_result,$i)){
do something with $row here
$count++;
}

tim_perdue

This is one of the things I hate about PHP - why does every database have its own API? I can't think of a good reason why the pg API has to be subtly different than MySQL's.

Anon

Have you looked at some of the database abstraction layers out there? They make it VERY easy to switch from one database to another. ADODB I think was one. Just do a search for database abstraction and php on sourceforge to find a few more.

gmiyano

Yeah, but I always feel like I'm hit with performance penalty when you use another layer on top of a native API. Also if your db contains multi-byte characters, its behaviour will be very difficult to anticipate.

smarlowe

TANSTAAFL. Everything's a tradeoff. If you need every ounce of speed out of an old P100 that is being beaten into the ground, maybe using the native interface will make just enough difference, but probably not.

On the other hand, for most applications, the time it takes for the gif/png buttons to transfer out and display is thousands of times more than the difference between using an abstraction layer and natively accessing the database.