Thread: PostgreSQL and PHP

To those of you who use PHP with PostgreSQL,

I'm trying to do a simple select inside a ".php3" script. The php3 script
simply says something like (the linux machine is not turned on so I can't
grab it exactly):

<?php
$database = pg_connect("","","","mydb");
pg_exec($database, "select * from mytable");
echo "whatever"
?>

and all I get is (in the resulting web page):

whatever

In other words, it doesn't print out on the web page the query that I just
made. Now have added the "nobody" web user to the list of authorised people
and I have granted permission for nobody to do anything he likes to mydb.

Other things work however such as the echo command above and the "info" php
command.

Any ideas?

James

James Macken wrote:
> 
> To those of you who use PHP with PostgreSQL,
> 
> I'm trying to do a simple select inside a ".php3" script. The php3 script
> simply says something like (the linux machine is not turned on so I can't
> grab it exactly):
> 
> <?php
> $database = pg_connect("","","","mydb");
> pg_exec($database, "select * from mytable");
> echo "whatever"
> ?>
> 
> and all I get is (in the resulting web page):
> 
> whatever
> 

I guess you have more lines in your php script, 
have you lines like these:


$result = pg_Exec ($database, $sqlStr); 
if (!$result) {   echo "An error occured.\n";   exit;
}


for($i=0; $i<pg_NumRows($result); $i++)
{ $row = pg_Fetch_array($result, $i); echo $row[1];
}

???

if not, please RTFM.
if you have written down these lines (or cut&pasted from the manual), 
and still it doesn't work, feel free to contact me.

stefano

Did you really read the manual ?

>From the php postgresSQL manual (pg_fetch_array)

Example 1. PostgreSQL fetch array

<?php 
$conn = pg_pconnect("","","","","publisher");
if (!$conn) {   echo "An error occured.\n";   exit;
}

$result = pg_Exec ($conn, "SELECT * FROM authors");
if (!$result) {   echo "An error occured.\n";   exit;
}

$arr = pg_fetch_array ($result, 0);
echo $arr[0] . " <- array\n";

$arr = pg_fetch_array ($result, 1);
echo $arr["author"] . " <- array\n";
?>



Prev

James Macken wrote:
> 
> To those of you who use PHP with PostgreSQL,
> 
> I'm trying to do a simple select inside a ".php3" script. The php3 script
> simply says something like (the linux machine is not turned on so I can't
> grab it exactly):
> 
> <?php
> $database = pg_connect("","","","mydb");
> pg_exec($database, "select * from mytable");
> echo "whatever"
> ?>
> 
> and all I get is (in the resulting web page):
> 
> whatever
> 
> In other words, it doesn't print out on the web page the query that I just
> made. Now have added the "nobody" web user to the list of authorised people
> and I have granted permission for nobody to do anything he likes to mydb.
> 
> Other things work however such as the echo command above and the "info" php
> command.
> 
> Any ideas?
> 
> James
> 
> ************

-- 
Best Regards
----------------------------
Ing. Giampiero Raschetti
Sistemi Innovativi
Banca Popolare di Sondrio
----------------------------