Call to undefined function pg_connect()

[louis_coetzee]

Call to undefined function pg_connect()

I enabled the php_pgsql, but get this error when calling pg_connect()

 

function db_connect()
{
$conn_string = 'host=localhost port=5432 dbname=db user=user password=passw';
$dbconn = pg_connect($conn_string);
}

[MadTechie]

Check for PostgreSQL in phpinfo();

[louis_coetzee]

Check for PostgreSQL in phpinfo();

PHP.ini Configuration, found nothing searching phpinfo();

[PostgresSQL]
; Allow or prevent persistent links.
pgsql.allow_persistent = On

; Detect broken persistent links always with pg_pconnect().
; Auto reset feature requires a little overheads.
pgsql.auto_reset_persistent = Off

; Maximum number of persistent links.  -1 means no limit.
pgsql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
pgsql.max_links = -1

; Ignore PostgreSQL backends Notice message or not.
; Notice message logging require a little overheads.
pgsql.ignore_notice = 0

; Log PostgreSQL backends Noitce message or not.
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0

[MadTechie]

No no, i mean

create a new file called

phpinfo.php

and put this in it

<?php
phpinfo();
?>

now open it, this will give you lots of info about your PHP setup, look to see if you can find PostgreSQL

[louis_coetzee]

yeh, I am using wamp server, dit use phpinfo().

Did'nt find anything on postgresql

[MadTechie]

Okay postgresql is not loading,

 

1. check your editing the correct php.ini (in phpinfo look for "Loaded Configuration File") then open that file and check it.

2. check the extension exists (in phpinfo find "extension_dir" open that folder and check their for the extension)

3. restart apache (WAMP)

[louis_coetzee]

Have done that.

 

when I try this: echo extension_loaded('pgsql'); ---->> Nothing

 

echo extension_loaded('mysql'); ------->> 1

[MadTechie]

So does it appear in PHPINFO now ?

 

see here  http://www.php.net/manual/en/pgsql.setup.php

[louis_coetzee]

So does it appear in PHPINFO now ?

 

see here  http://www.php.net/manual/en/pgsql.setup.php

 

nope! But when I go to look at wamp extentions, in wamp. it appears to be enabled.

[MadTechie]

try the php User Contributed Notes