PHP Data Objects (PDO) defines a lightweight and consistent interface for accessing databases.

learn more… | top users | synonyms

1
vote
2answers
806 views

php pdo connection cannot be established, but mysql command line client can

situation as follows: php script on server a, run by user 'web' (nginx + php-fpm) should access mysql on server b via pdo library, but gets SQLSTATE[HY000] [2003] Can't connect to MySQL server on '...
1
vote
1answer
55 views

MySQL server experiencing high stress/max connections

The Short: We're hitting max connections and seeing very poor performance from MySQL during peak business hours and cannot determine if it is a load problem or a configuration problem. The Long: To ...
1
vote
1answer
2k views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
1
vote
1answer
304 views

mysql server freezes on inserts on a InnoDB table

CREATE TABLE IF NOT EXISTS `music_batch_song` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `music_batch_id` bigint(20) DEFAULT NULL, `song_id` bigint(20) DEFAULT NULL, `comment` varchar(10) ...
1
vote
1answer
898 views

Can't get php+sqlite working

I'm struggling all morning to make php work with an sqlite database. Here is a piece of php code that I try to execute: #less /var/www/html/test.php <?php $db=new PDO("sqlite:/var/www/test....
0
votes
1answer
240 views

Let php PDO work with newest version of PostgreSQL (Debian/Ubuntu)

I installed PostgreSQL and the php PDO driver on my 14.04 Ubuntu like this: sudo apt-get install postgresql postgresql-contrib sudo apt-get install php5-pgsql Which installed PostgreSQL 9.3 and ...
0
votes
1answer
169 views

PDO to AWS RDS Connection Issue

We have a website written in PHP hosted on AWS EC2 instance, talking to AWS RDS database. When high traffic on the site, some users are experiencing 503 error on pages and we can see these errors on ...
0
votes
1answer
254 views

Error installing php-mysqlnd

I've been trying to install phpmysqlnd, but I'm not sure what's going wrong. This is on a CentOS system. I run the commands: yum remove php-mysql yum install php-mysqlnd The first one is a ...
0
votes
1answer
237 views

Activating Informix variables on Apache2/Debian

I'm working on adding PDO for Informix on my Debian server. I have a strong set of instructions from a gentleman who has set this up to run on suse, I'm trying to figure out how to add these ...
0
votes
1answer
688 views

Enabling PDO for CLI in vagrant box precise64 (Ubuntu server 12.04 LTS)

I have vagrant box (precise64) utilizing Ubuntu server 12.04. I have installed manually (no use of LAMP) on the server the following: MySql server / MySql client - Server version: 5.5.31-0ubuntu0.12....
0
votes
1answer
2k views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
0
votes
1answer
2k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
0
votes
1answer
371 views

Proper Linux environment for php5.3?

I use CentOS 5.5 64bits, and I'd strongly prefer running php5.3 there (please focus on this), but if you have a safe recipe to run it on another distribution, I'll take it into consideration. My ...
-1
votes
1answer
738 views

Installing PDO and other PHP extensions for magento

I have a server and i was using php files on it. For some reason i had to reinstall apache on it. My files and my SQL database is still there. Now after fresh installation of Apache, when i run my ...
1
vote
0answers
3k views

phpinfo reports no value for PDO MySQL driver

As per the title I'm having problems with PHP 5.2.10 and getting PDO MySQL to be recognised. My configure command contains '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-...
0
votes
0answers
15 views

Server auto disabling pdo

PDO mysql plugin wasn't enabled by default in my server , so i added a line extension=pdo_mysql.so to a php.ini file i created, and it works fine , but every once in a while it is ...
0
votes
0answers
87 views

Unable to load dynamic library pdo.so, pdo_sqlite, pdo_mysql

After writing a huge article in my blog, I've got a blank page on the articles page, and when I checked the log, look what I found: [29-Dec-2015 19:53:20 America/Sao_Paulo] PHP Warning: PHP Startup: ...
0
votes
0answers
178 views

How do I install PDO drivers for PHP on Windows?

I installed Apache, PHP 5.6 and MySQL 5.7 on a Windows server. In php.ini, I enabled the following: extension=php_mysql.dll extension=php_mysqli.dll extension=php_oci8_12c.dll extension=...
0
votes
0answers
40 views

odbc - codegniter - 2 databases but connects only 1 database

we have a huge problem with database.php to azure database. 1 application run already. codeigniter to azure database in / 2 application : /development same files, same database.php only database is ...
0
votes
0answers
166 views

Upgrade SQLite Library for php 5.4

My php version is 5.4 This is what I get in phpinfo pdo_sqlite PDO Driver for SQLite 3.x enabled SQLite Library 3.6.20 I really need to update this driver. On PHP 5.3 you could do this with ...