Cant connect to Postgres from php ->Call to undefined function pg_connect()

Question

I posting this question as answers in previews posts didn't help me. i am trying to connect to DB postgres which is located on remote server from my local computer. I am using Xampp and Netbeans IDE.

below is the code i am trying to run :

        //attempt a connection
    $dbh = pg_connect("host=server_name port=5432 dbname=prototype1 user=leonidz password=****");
    if (!$dbh) {
    die("Error in connection: " . pg_last_error());
               }

This is the error msg:

Fatal error: Call to undefined function pg_connect() in C:\xampp\htdocs\PhpProject1\index.php on line 10

in php.ini I uncommitted: extension=php_pgsql.dll and extension=php_pdo_pgsql.dll

i also mapped the extension_dir = "C:\xampp\php\ext\" and restarted the Apache server after the change.

I don't know what else i should do, please help.

What does PHP info tell you of the loaded extensions? What error does apache log give you when restarting? — dbf
– dbf, Commented Mar 30, 2013 at 19:05
I have any error in the Apache error log, PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\xampp\\php\\ext\\php_pdo_pgsql.dll' - The specified module could not be found.\r\n in Unknown on line 0 when i try to run the function to connect to the DB i am getting: PHP Fatal error: Call to undefined function pg_connect() in C:\\xampp\\htdocs\\PhpProject1\\index.php on line 10 PHP INFO: there is no results when i try to find "pgsql" string in php info — Leon83
– Leon83, Commented Mar 31, 2013 at 20:52
what OS are you using? is it Linux or Windows environment? what version are you using, x86 or x64? Which php.ini did you edit? remember it's the one from xampp/apache/bin/ Hope you answer all my questions so we can help you better. Cheers — Alberto Juliao O.
– Alberto Juliao O., Commented Apr 10, 2013 at 10:08

RyanNerd · Accepted Answer · 2019-11-05 11:29:30Z

15

In the C:\xampp\php\php.ini , uncomment these:

extension=php_pdo_pgsql.dll
extension=php_pgsql.dll

After Done this Need to restart your xampp

edited Nov 5, 2019 at 11:29

RyanNerd

3,2291 gold badge24 silver badges28 bronze badges

answered May 18, 2016 at 11:30

Sáskya Gurgel

1511 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

raosaeedali Over a year ago

Worked like a charm.

Gurjeet Singh Over a year ago

I am facing the same problem but couldn't find the above lines in php.ini file.

user5781320 Over a year ago

THANK YOU! I was able to configure xampp in 5 minutes to learn other 10 minutes PostgreSQL .. but remember: in php 7 php.ini there are line 905- extension=pdo_pgsql and line 907-extension=pgsql

Anjan Biswas Over a year ago

I am using xampp 5.6.38, and it was in line no. 908 and 910. But why these lines are commented by default?

Filomat Over a year ago

AND extension="pgsql.so" in case of running xampp on linux

Ayan Bhattacharjee · Accepted Answer · 2019-12-06 15:15:25Z

6

Go to PHP dir oepn php.ini file, there you will find these two lines, just remove the semicolon from the left hand side, save the file. Next, stop you xampp server and restart it again it will works fine

;extension=pdo_pgsql
;extension=pgsql

answered Dec 6, 2019 at 15:15

Ayan Bhattacharjee

1153 silver badges10 bronze badges

Comments

sebtucknott · Accepted Answer · 2018-09-03 11:25:12Z

5

In php.ini you need to uncomment

extension=php_pdo_pgsql.dll

extension=php_pgsql.dll

AND

extension="pgsql.so"

answered Sep 3, 2018 at 11:25

sebtucknott

2593 silver badges4 bronze badges

Comments

Atomzwieback · Accepted Answer · 2020-07-22 19:48:58Z

Fatal error: Uncaught Error: Call to undefined function pg_connect() in C:\xampp\htdocs\postgresql_dbcon\connection1.php:5 Stack trace: #0 C:\xampp\htdocs\postgresql_dbcon\view.php(4): include() #1 {main} thrown in C:\xampp\htdocs\postgresql_dbcon\connection1.php on line 5

connection1.php file

<?php
    $db = pg_connect("host=localhost port=5432 dbname=db_test user=postgres password=123abc");//line 5
    if($db){
        echo "Connected\n";
    } else {
        echo "Error NotConnected\n";
    }
?>

view.php file

<?php include "connection1.php";?>
<?php 
    $query = 'Select * FROM table2';
    $result = pg_query($db, $query);
    if (!$result) {
  echo "An error occurred.\n";
  exit;
}
while ($row = pg_fetch_row($result)) {
  $dbdata[]=$row;
}
$myJSON = json_encode($dbdata);
    echo $myJSON;
?>

If you are using XAMPP in Windows Operating System then go to directory where you have installed XAMPP. Follow the path i.e xampp/php/php.ini . Open php.ini file in your editor and search for ";extension=pdo_mysql" and replace it with "extension=pdo_mysql" and also replace ";extension=pdo_pgsql" with "extension=pdo_mysql". Then save the file and restart your XAMPP.

Collectives™ on Stack Overflow

Cant connect to Postgres from php ->Call to undefined function pg_connect()

4 Answers 4

5 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related