How do I enable php to work with postgresql

Question

lt  php  try       dbh   new PDO  pgsql host localhost port 5432 dbname     user     password          echo  PDO connection object created     catch PDOException  e          echo  e- gt getMessage         gt    I get the error message  Could Not Load Driver

User · Answer

I installed PHP on windows IIS using Windows Platform Installer (WP?). WP? creates a "PHP Manager" tool in "Internet Information Services (IIS) Manager" console. I am configuring PHP using this tool.

in http://php.net/manual/en/pdo.installation.php says:

PDO and all the major drivers ship with PHP as shared extensions, and simply need to be activated by editing the php.ini file: extension=php_pdo.dll

so i activated the extension using PHP Manager and now PDO works fine

PHP manager simple added the following two lines in my php.ini, you can add the lines by hand. Of course you must restart the web server.

[PHP_PDO_PGSQL]
extension=php_pdo_pgsql.dll

User · Answer

dbh   new PDO  pgsql host localhost port 5432 dbname     user     password        For PDO type connection uncomment extension php pdo pgsql dll and comment with  extension php pgsql dll  dbh   pg connect  quot host localhost dbname     user     password      quot     For pgconnect type connection comment  extension php pdo pgsql dll and uncomment extension php pgsql dll Both the connections should work

User · Answer

You need to isntall pdo pgsql package

User · Answer

For debian ubuntu install  sudo apt-get install php-pgsql

User · Answer

SO  Windows Linux HTTP Web Server  Apache Programming language  PHP   Enable PHP to work with PostgreSQL in Apache  In Apache I edit the following configuration file  C  xampp php ini  I make sure to have the following lines uncommented   extension php pgsql dll  extension php pdo pgsql dll   Finally restart Apache before attempting a new connection to the database engine     Also  I leave my code that ensures that the connection is unique   private static  pdo   null   public static function provideDataBaseInstance         if  self   pdo    null             dsn    pgsql host     HOST                    port 5432 dbname     DATABASE                    user     POSTGRESQL USER                    password     POSTGRESQL PASSWORD          try               self   pdo   new PDO  dsn             catch  PDOException  exception                 msg    exception- gt getMessage                echo  msg                        Do not forget to enable in the web server the database                    manager for php and in the database instance authorize the                    ip of the server instance if they not in the same                    instance                        return self   pdo      GL

User · Answer

I and many other shave spent way too long on this - this needs a massive improvement   After spending hours  I finally copied php pgsql dll from php s ext directory to Apache24 s root directory  wherever you installed it  and finally Apache was able to get the php pg modules and dlls loaded

User · Answer

just install the database driver      apt-get install php5-pgsql php5-mysql php5-sqlite     and so on       and be happy

User · Answer

Try this   Uncomment the following in php ini by removing the       extension php pgsql dll   Use the following code to connect to a postgresql database server   pg connect  host localhost dbname dbname user username password password       or die  Can t connect to database  pg last error

User · Answer

I have to add in httpd conf this line  Windows    LoadFile  C  Program Files  x86  PostgreSQL 8 3 bin libpq dll

User · Answer

You need to install the pgsql module for php  In debian ubuntu is something like this   sudo apt-get install php5-pgsql   Or if the package is installed  you need to enable de module in php ini  extension php pgsql dll  windows  extension php pgsql so  linux    Greatings

User · Answer

in my case there are 2 php ini  I had to uncomment extension pdo pgsql in both php ini   in php folder in apache folder   both inside in wamp folder

[php] How do I enable php to work with postgresql?

Examples related to php

Examples related to windows

Examples related to postgresql

Examples related to pdo