You should turn on display_errors in your php.ini file. That would make it a
lot easier to track down the error.
Tony
On 11/7/06 9:27 AM, "Desmond Coughlan" <coughlandesmond@xxxxxxxx> wrote:
> X-No-Archive:
>
>
> Curious. I put this in a file...
>
>
>
> <?php
>
> echo '<p>Hello World</p>'
>
> ?>
>
> Bingo.
>
>
>
> I then take the *same* file, I don't rename it, I just open it in vi. I copy
> a single occurrence of 'pg_connect' etc...
>
>
>
> And the 'hello world' disappears.
>
>
>
> D.
>
>
>
> Tony Grimes <thelist@xxxxxxxxxxxxxx> a écrit :
>
>> 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" 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 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
> <http://fr.rd.yahoo.com/evt=42054/*http://fr.answers.yahoo.com> .
