Re: [PHP-DB] small question php/postgreSQL
Desmond Coughlan wrote:
X-No-Archve: true
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());
If that doesn't work - then you don't have the php-postgres library
installed.
Check your phpinfo page for "postgresql" - if it's not there, then
that's your problem.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB]: small question php/postgreSQL
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" <[EMAIL PROTECTED]> wrote:
> X-No-Archive:
>
>
> Curious. I put this in a file...
>
>
>
>
> echo 'Hello World'
>
> ?>
>
> 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 <[EMAIL PROTECTED]> 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@lists.php.net
>> Subject: [PHP-DB] 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.
>>
>> The
[PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL
X-No-Archive:
Curious. I put this in a file...
Hello World'
?>
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 <[EMAIL PROTECTED]> 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@lists.php.net
>> Subject: [PHP-DB] 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
Re: [PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL
Alright, now try commenting out all the script except for the ini_set and
echo 'test' at the top. There still might be a syntax error in the code.
Essentially, you want to do whatever you can to get the page to display a
simple message. Then, work backwards until you get the error/blank page.
If you can't get a message to display, try copying the script from hello.php
to right into your new script. That should give you enough to troubleshoot.
Tony
On 11/7/06 9:00 AM, "Desmond Coughlan" <[EMAIL PROTECTED]> wrote:
> X-No-Archive: true
>
> OK, that gives a blank page, too... which is puzzling, 'cos I tried
> 'hello.php' before getting into the db 'thang', and I saw the text on the
> screen.
>
> Well .. back to the drawing board...
>
> D.
>
> Tony Grimes <[EMAIL PROTECTED]> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE : Re: [PHP-DB]: small question php/postgreSQL
X-No-Archive: true
OK, that gives a blank page, too... which is puzzling, 'cos I tried
'hello.php' before getting into the db 'thang', and I saw the text on the
screen.
Well .. back to the drawing board...
D.
Tony Grimes <[EMAIL PROTECTED]> 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@lists.php.net
>> Subject: [PHP-DB] 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
--
Des Coughlan
[EMAIL PROTECTED]
"Un client de plus, c'est un relou de plus..."
Re: [PHP-DB]: small question php/postgreSQL
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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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@lists.php.net
>> Subject: [PHP-DB] 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
