RE : RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



X-No-Archive: true
   
  That doesn't work, either.  Still the blank page.  Hmm ... the file is in the right place../usr/local/www/data ... 'cos all of the other files (*.html one an d all) are served from there, and they're available to the outside world.
   
  D.

Bastien Koert <bastien_k@xxxxxxxxxxx> a écrit :
  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']."
";
echo "blah ".$row['code_livre']."
";
}else{
echo "No rows found";
}


bastien


>From: JeRRy 
>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" To: "php" 

> 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 ....
>
> > 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']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> (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:
>
> > 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']."
";
>echo "blah ".$row['code_livre']."
";
>}
> ?>
>
> 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



 		
---------------------------------
 Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses.

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux