pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: David Cruz <davidcrmail@yahoo.com>
To: pgsql-php@postgresql.org
Subject: Re: Hi!, and a Question
Date: Mon, 7 Jun 2004 23:17:07 -0700 (PDT)
Message-ID: <20040608061707.99638.qmail@web50106.mail.yahoo.com> (raw)
In-Reply-To: <OF8B055BC3.23CD56A0-ON85256EA9.00469000-85256EA9.00470E80@statestr.com>

Hi!, about this, I'm using it local, in the same
server is postgresql and the database and the apache
web server too. I have downloaded the php-pgsql again
and install it again, it was an rpm and i have knoppix
(debian), so I did it with #alien -i, I have this in
my php.ini

------
;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded
automatically, use the following
; syntax:
;
;   extension=modulename.extension
;
; For example, on Windows:
;
;   extension=msql.dll
;
; ... or under UNIX:
;
;   extension=msql.so
;
; Note that it should be the name of the module only;
no directory information
; needs to go here.  Specify the location of the
extension with the
; extension_dir directive above.
extension=pgsql.so

------

I have pgsql.so in /usr/lib/php4/20020429 which is the
place where phpinfo(); says it's searching for
extensions 


-------
and my /etc/postgresql/pg_hba.conf says:

#
# TYPE  DATABASE    USER        IP-ADDRESS       
IP-MASK           METHOD
# Database administrative login by UNIX sockets
local   all         all                               
        trust
#
# All other connections by UNIX sockets
local   all         all                               
             trust
#
# All IPv4 connections from localhost
host    all         all         127.0.0.1        
255.255.255.0   trust
#
# All IPv6 localhost connections
host    all         all         ::1              
ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust
host    all         all         ::ffff:127.0.0.1/128  
             trust
#
# reject all other connection attempts
localhost    all         all         192.168.1.6      
    255.255.255.0           trust

-------
and the phpinfo page shows:

pgsql
PostgreSQL Support	enabled
Active Persistent Links 	0
Active Links 	0

Directive	Local Value	Master Value
pgsql.allow_persistent	On	On
pgsql.auto_reset_persistent	Off	Off
pgsql.max_links	Unlimited	Unlimited
pgsql.max_persistent	Unlimited	Unlimited

-----
I don't know what am I doing but it doesn't work, when
I execute the php web page:

<html>
   <head>
       <title>Ejemplo</title>
   </head>
   <body>

   <?php
    $db = pg_connect("dbname=cdtaller4_3");
$query = "select  *  from empleados";
$result = pg_exec($db, $query);
if (!$result) {
printf ("ERROR");
$errormessage = pg_errormessage($db);
echo $errormessage;
exit;
}
?>
       <a href="index3.php">a index3</a>

   </body>
</html>

It doesn't shows any error or something it stays on
the same page it was, and do nothing...

Thanks...if somebody knows another configuration I'm
forgetting.. (PHP 4, Apache, PostgreSQL 7.4.2, Knoppix
3.4) 

thanks!


--- CGMoller@StateStreet.com wrote:
> 
> Question - You say other php scripts work, do they
> connect to the database
> too?
> 
> I see you have not specified a user to connect to
> the database.  I believe
> the host and port are necessary only if they are not
> local or using a
> different port.
> I use the following format to connect
> 
> $db = pg_connect("dbname=performance user=browser");
> $query = "select  *  from my_table";
> $result = pg_exec($db, $query);
> if (!$result) {
> printf ("ERROR");
> $errormessage = pg_errormessage($db);
> echo $errormessage;
> exit;
> }
> 
> Thanks
> 
> Cameron
> 
> +++++++++++++++++++++++++++++++++++++
> Cameron G. Moller,  Senior Officer
> Technical Project Manager
> SSGM Infrastructure
> State Street Corporation                       ...  
> __o
> Cell:  617-799-9049                              
> ...    -\<,
> Desk:  617-664-4501                            ...
> (_)/(_) ..
> +++++++++++++++++++++++++++++++++++++
> 
> 
> |---------+------------------------------>
> |         |           David Cruz         |
> |         |           <davidcrmail@yahoo.|
> |         |           com>               |
> |         |           Sent by:           |
> |         |           pgsql-php-owner@pos|
> |         |           tgresql.org        |
> |         |                              |
> |         |                              |
> |         |           06/04/2004 01:13 AM|
> |         |                              |
> |---------+------------------------------>
>  
>
>------------------------------------------------------------------------------------------------------------------------------|
>   |                                                 
>                                                     
>                        |
>   |       To:       pgsql-php@postgresql.org        
>                                                     
>                        |
>   |       cc:                                       
>                                                     
>                        |
>   |       Subject:  [PHP] Hi!, and a Question       
>                                                     
>                        |
>  
>
>------------------------------------------------------------------------------------------------------------------------------|
> 
> 
> 
> 
> Hello to everybody!
> 
> I'm David from Colombia.
> 
> I'm learning Postgresql and using PHP. And I'm
> trying
> to connect from my php web page to PostgreSQL, I use
> this function:
> 
>  $connection = pg_connect("host=gatuno port=5432
> dbname=cdtaller4_3");
> 
> and when I look it on the browser it shows:
> 
> Fatal error: Call to undefined function:
> pg_connect()
> in /var/www/index2.php on line 8
> 
> - I have PostgreSQL 7.4 , Apache is working well,
> and
> all other php scripts too. I'm using knoppix and I
> looked at the KPackage and I have php4-pgsql
> installed.
> 
> Does somebody know what could be happening?
> 
> thanks!
> 
> 
> 
> 
> 
> __________________________________
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
>       joining column's datatypes do not match
> 
> 
> 
> 
> 



	
		
__________________________________
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 



view thread (5+ messages)  latest in thread

Message-ID: <20040608061707.99638.qmail@web50106.mail.yahoo.com>
Permalink:  ../20040608061707.99638.qmail@web50106.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040608061707.99638.qmail@web50106.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: davidcrmail@yahoo.com
  Subject: Re: Hi!, and a Question
  In-Reply-To: <20040608061707.99638.qmail@web50106.mail.yahoo.com>
  References: <OF8B055BC3.23CD56A0-ON85256EA9.00469000-85256EA9.00470E80@statestr.com> <20040608061707.99638.qmail@web50106.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox