Alternative to pg_connect() for PostgreSQL database in PHP running as Apache Module

Question

This is a peculiar requirement

I am doing this on a vendor router so I do not have much control over things. I can not load my own PHP or modify php.ini etc.

Addition:

Actually PHP is running just as a Apache Module. What options do i have to connect to PostgreSQL database. Though PHP version is PHP Version 5.3.2 - Its is extremely stripped down version of it.

Requirement:

There is a PostgreSQL database on this router and I need to access it using the barebones PHP that is available on the router.

Is there a way I can add the PostgreSQL libraries along with my own files and connect to the PostgreSQL database ??

Thanks in advance!

ajreal · Accepted Answer · 2011-12-06 10:30:09Z

3

You can use PDO if your PHP has compiled and enabled with this module.
By default is included since PHP 5.1

edited Dec 6, 2011 at 10:30

answered Dec 6, 2011 at 10:09

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

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

5 Comments

AJ. Over a year ago

I tried this but seems like PostgreSQL PDO driver is also not installed. Getting this error: Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in

ajreal Over a year ago

hmm...I guess you are stuck. No choice, you have to find a way to get postgres module or the Postgres PDO driver loaded into PHP.

AJ. Over a year ago

common there has to be some way of doing this :(

ajreal Over a year ago

You can however use external postgres client (meaning use bash), but that's again depend on your vendor server. If there is no postgres client, you are stuck again.

AJ. Over a year ago

Can you tell me more about this approach?

Michael Krelin - hacker · Accepted Answer · 2011-12-06 10:13:38Z

0

Theoretically, if you can get the postgres module (.so) for this version of php and if php.ini would allow you to do so (not likely) you can dynamically load it.

answered Dec 6, 2011 at 10:13

Michael Krelin - hacker

144k25 gold badges200 silver badges177 bronze badges

2 Comments

AJ. Over a year ago

No this is not possible. Actually there is no php.ini also on the device. Just a PHP executable.

Michael Krelin - hacker Over a year ago

Then it most likely doesn't even support dynamic loading. Well, I've never heard of pure-php implementation of postgres protocol.

Collectives™ on Stack Overflow

Alternative to pg_connect() for PostgreSQL database in PHP running as Apache Module

2 Answers 2

5 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related