Re: : small question php/postgreSQL

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

 



Is your server configured to display errors? Try adding this at the top of
your script:

ini_set('display_errors',true);

It won't catch syntax errors, but it should help. Also, try adding this to
the top of your script:

echo 'test';

If you still get a blank page, then it's probably not a problem with your
actual script. Maybe your configuration.

Tony


On 11/7/06 8:38 AM, "Desmond Coughlan" <coughlandesmond@xxxxxxxx> wrote:

> 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



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

  Powered by Linux