The code does need to know what the fields are...I think a more likely issue
is the query for some reason, also change the $query to result in the query
statement
try
$result=pg_query($query) or die(pg_error()); //to see if there are any
errors with the query
while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no']."<br />";
echo "blah ".$row['code_livre']."<br />";
}else{
echo "No rows found";
}
bastien
From: JeRRy <jusa_98@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: re: small question php/postgreSQL (basic question, not
small)
Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)
Date: Tue, 7 Nov 2006 10:38:18 +0100 (CET) From: "Desmond
Coughlan" <coughlandesmond@xxxxxxxx> To: "php" <php-db@xxxxxxxxxxxxx>
Subject: small question php/postgreSQL
Hi,
I've been trying to get a small DB up and working with PhP. It's a
library, and so far, I can't get past the stage of displaying a page. I
try the 'hello world' example, and it displays. I then populate a DB
and can access it via psql ..
cdi=> SELECT * FROM stock ;
-[ RECORD 1 ]-+-------------------------------
stock_ids | 1
isbn_no | 10101010
code_livre | 23455
titre | toto goes to Hollywood
editeur | editions toto
collection | collection toto
auteur_nom | smith
auteur_prenom | john
matiere | ang
media_type | li
-[ RECORD 2 ]-+-------------------------------
stock_ids | 2
isbn_no | 10536278
code_livre | 24874
titre | toto comes back from Hollywood
editeur | editions baba
collection | collection toto
auteur_nom | martin
auteur_prenom | peter
matiere | fre
media_type | dvd
OK, I then write the following script ....
<?php
pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
Connect: ".pg
_last_error());
$query="SELECT * FROM stock";
$query=pg_query($query);
// start the output
while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no']."<br />";
echo "blah ".$row['code_livre']."<br />";
}
?>
(sorry not to put that in italics or whatever...)
... and put it in the document root of my webserver, under
php_experimental.
I get a blank page. The apache weblogs look like ...
192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET
/php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible;
MSIE 6.0;
Windows NT 5.0)"
There's something obvious that I'm missing. Any ideas ..?
Thanks.
D.
------
re:
<?php
pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't
Connect: ".pg
_last_error());
$query="SELECT * FROM stock";
$query=pg_query($query);
// start the output
while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no']."<br />";
echo "blah ".$row['code_livre']."<br />";
}
?>
Simple, isbn_no and code_livre need to be "defined" in your code.
Otherwise PHP don't know what your looking for.
There is PLENTY of docs online to show you how to display items in a DB.
Hello World is basic, too basic to use as an example and is a poor one to
use. If your nerw you have to go a bit more into it than Hello World code.
(which in my opinion gets you know-where) been there done that.
Google how to display items in a DB in PHP and shoot you get some handy
things.
I just feel this question is not required here when google has all the
answers like this.
Jerry
_________________________________________________________________
Ready for the world's first international mobile film festival celebrating
the creative potential of today's youth? Check out Mobile Jam Fest for your
a chance to WIN $10,000! www.mobilejamfest.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
