PHP Data Objects (PDO) defines a lightweight and consistent interface for accessing databases.
1
vote
1answer
27 views
Dynamic column enumeration for preventing SQL injection
I have an application which is completely for internal use but I'm trying to make sure I have my bases covered on SQL injection. Unless someone else has some information to point me otherwise there ...
0
votes
0answers
20 views
Missing Zend/Db/Adapter/Pdo/Mysql.php
So after some long struggling I finaly have the ZendFramework running. Now I'm trying to get it working with my database, but my error file is telling me the following:
PHP Warning: ...
0
votes
0answers
34 views
PDO::__construct(): [2002] Connection refused
My Magento system.log is full of this errors, over and over.
So far I havn't noticed any errors on the websites themselves because of this error, but I think there may be considering the wording on ...
1
vote
0answers
15 views
PDO Driver Update/Replace [duplicate]
How can i update or replace the mysql pdo driver? Replacing or updating to a newer mysqlnd version should fix the problem, because I have another server running on 5.5 and its working. I tryed to ...
1
vote
0answers
44 views
centos update mysqlnd [closed]
I updated my mysql from version 5.0 to version 5.5, but my PDO drive is still mysqlnd 5.0.10. I would like to update the mysql driver to 5.5. How could i do that?
I already tried to recompile apache, ...
0
votes
1answer
17 views
Enable PDO in shared server
My newest client has decided (against my heavy recommendation to use my tried and true host..) to use Webmasters.com to host their site.
This is turning into a nightmare... I finally got the full ...
0
votes
2answers
71 views
PDO ODBC error just resets connection
Trying to write an ODBC PDO driver for CakePHP. Seems like I get closer and closer however whenever a PDO function is called that it doesn't like the connection just gets reset immediately and I'm not ...
-1
votes
1answer
52 views
nginx and running MySQL PDO [closed]
How do you install and run MySQL PDO with nginx/php-fpm?
I moved from using apache and suexec to a more dedicated setup.
Do I just need to download something then compile and add the plugin into the ...
0
votes
1answer
154 views
How enable pdo_mysql
I am trying to install SpaceBukkit. I was wondering how I enable pdo_mysql. When trying to setup the MySQL part I get this error:
The "pdo_mysql" extension is NOT loaded in your `php.ini`!
Make sure ...
0
votes
0answers
105 views
using PDO->fetch-method causes apache Segmentation fault
I cannot use any of the fetching-methods from PDO.
Trying this:
$DBH = new PDO('odbc:Driver=FreeTDS; Server=192.168.2.3; Port=1433; Database=DB; UID=sa; PWD=pw;');
$STH = $DBH->query("SELECT TOP ...
5
votes
0answers
474 views
Php pdo_dblib - cannot find/unable to load freetds
Self-hosted box,
RHEL 6
PHP 5.3.3
PDO installed
freetds installed
pdo_dblib - so far no luck installing
My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate ...
0
votes
0answers
137 views
easyapache PDO on amazon EC2 without using pecl?
I am having problems with my Auth component in an Amazon ec2 linux instance. Apparently the mysql pdo needs to be installed via easy apache rather than PECL. The command I used to instal the mysql pdo ...
-1
votes
1answer
55 views
When and how often to start connection to database in php? [closed]
When and how often is it good practice to start the connection to your database in php?
I'm new to databases, and I'm wondering when I should start by database connection. I'm creating a api with an ...
2
votes
2answers
1k views
AWS RDS connection count
I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that ...
0
votes
1answer
462 views
PHP Fatal error: Class 'PDO' not found
PHP Fatal error: Class 'PDO' not found in /home/bd/public_html/app/webroot/Cake/Model/Datasource/Database/Mysql.php on line 177
PHP INFO:
PDO
PDO support => enabled
PDO drivers => sqlite, ...
0
votes
2answers
1k views
Installing PDO_DBLIB for PHP
I'm trying to get PDO's to work with SQL Server and I'm completely lost. I found this :
http://www.php.net/manual/en/ref.pdo-dblib.php
http://pecl.php.net/package/PDO_DBLIB
and told to try this:
...
0
votes
1answer
541 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
509 views
PHP PDO and cPanel
I've been handled down this project, which is running PHP 5.3.6 with PDO support disabled.
I have a cPanel login to interface with the server. What would be the process to install/enable PDO MysQL ...
0
votes
1answer
2k views
PDO_MYSQL Installation on CentOs6
I have a new CentOS 6 server running PHP 5.3.2. The output of php -v shows
Unable to load dynamic library '/usr/lib64/php/modules/pdo_mysql.so -
/usr/lib64/php/modules/pdo_mysql.so cannot open ...
1
vote
1answer
2k views
How do I install the pdo_mysql driver on Red Hat Enterprise Linux 6.1?
I have a RHEL box running PHP 5.3.3, which was installed using the binary packages provided by yum. I have installed the php-pdo package:
# yum info php-pdo
Loaded plugins: product-id, rhnplugin, ...
0
votes
1answer
531 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 ...
4
votes
3answers
6k views
How do I get PHP 5.3 working on Red Hat Enterprise Linux, with PDO enabled? PHP53 was installed with yum
This problem is complicated, and I'm not an expert at all, so bear with me. My server admin team set me up with a standard RHEL box. It had PHP preinstalled, as well as apache.
I am now trying to ...
0
votes
1answer
346 views
PostgreSQL 9.0 and PHP on Amazon EC2
How can I enable PostgreSQL 9.0 support in PHP on my Amazon EC2 instance? I'm running the free 32 bit Linux Micro instance. I've installed PostgreSQL 9.0 by following these instructions ...
-1
votes
2answers
300 views
PDO not showing in phpinfo() with custom php.ini file [closed]
I have a custom php.ini file which sets my session.save_path=./
With this file in place, my phpinfo() does not show PDO or PDO mysql being enabled. If I rename the php.ini file, the phpinfo() does ...
-1
votes
1answer
113 views
how to install some extensions on my centos (vmware)VPS with Cpanel
I require the following extensions to be installed for a software to work--
* pdo_mysql extension
* curl extension
* zip extension - for automatic updates
* ftp extension - for automatic updates
* ...
1
vote
1answer
106 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) ...
6
votes
3answers
13k views
How can I install mysql PDO driver in Ubuntu 10.04 and PHP 5.3.2
I tried to install mysql PDO driver with this command:
$ sudo pecl install pdo_mysql
but I got the following error:
WARNING: "pecl/PDO_MYSQL" is deprecated in favor of ...
1
vote
0answers
955 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' ...
0
votes
1answer
351 views
Suse11 - How to install pdo_mysql
I am going to install Drupal 7 to my new server, I have installed all stuff that mentioned in the requirement, however I stall get the error message saying that
"...Your web server does not appear ...
0
votes
1answer
828 views
Compiling PHP 5 with PDO MySQL
I want to use Nginx with PHP5-FPM with MySQL PDO on Debian. To get PHP5-FPM on squeeze I need to compile PHP myself. First I tried to
I did:
apt-get install mysql-server libmysqlclient-dev
I ...
0
votes
0answers
208 views
PDO - WHat is it? How do I enable it on shared hosting
I have a shared hosting account and PHP5 is installed and running. When I view phpinfo, I can see that mysql pdo is running. I think I need to "link" to it from the php.ini file. But I dont know for ...
0
votes
1answer
356 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 ...
0
votes
2answers
1k views
0
votes
1answer
2k views
Can't get PDO MySQL driver to work on PHP
Trying to install Vanilla 2 locally using MAMP i got the error:
"You must have the MySQL driver for PDO enabled in order for Vanilla to connect to your database".
When I check phpinfo() I see:
...
0
votes
0answers
260 views
How and from where to install php_pdo_mysql.dll
I want to install the PDO driver for MySQL but have no idea how to. Please tell me from where I can install it. I want to install it by just single clicking a download link.
0
votes
1answer
336 views
How to enable PDO?
I have little server in Slicehost and i installed PHP 5.2.10 with PDO disabled. Now i'd like to enable it. Is there a way to enable it without too much fuzz? I'm not a pro admin :P.
Thanks!
0
votes
1answer
212 views
Installing my mysql adapter properly
I am running on ubuntu 10.04. Can someone tell me how to isntall:
PHP5
MySQL with support for PDO
All tutorials I've found are a bit old.
1
vote
1answer
501 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 ...
0
votes
1answer
336 views
pdo_mysql installation
On my server I'm trying to instal PHProjekt (6). This requires pdo_mysql however. I thought this installation of pdo_mysql would be rather straightforward...
I tried using pecl (pecl install ...
0
votes
1answer
369 views
IIS + PHP Data Objects + MS SQL?
We're migrating an LAOP server to Win 2k8 IIS7 MSSQL and PHP (WIMP?) at work, and I'm using the opportunity to clean up the PHP. Currently it doesn't use PDO, and I'd like to rewrite the PHP to use ...
2
votes
2answers
426 views
Why do I get a PHP 5.2.6 segmentation fault when using PDO_SQlite?
This is an installation on ModWest's shared hosting. I have enabled both PDO and PDO_sqlite on the server and phpinfo() verifies both are running. When I access PDO itself, I'm fine, and getting a ...
0
votes
2answers
12k views
PDO Disabled in PHP… how to enable it?
Sorry I'm still a bit of a novice with dedicated hosting. Anyway, we have a dedicated server running cPanel and WHM. I have full terminal access and all that.
Basically I've tried to install Chive to ...
2
votes
1answer
3k views
How to install PostgreSQL extension for PDO in Linux?
I have the VPS. I can build my PHP version using Easy Apache. I can find the option for PDO support for MySQL, SQLite. But I don't have any option of PDO pgsql driver.
How can I enable that?
It says ...
0
votes
4answers
2k views
getting PHP PDO flavors to work on Mac OS X
I'm running OS X 10.5; it looks like it came with Apache and PHP installed (minus some minor configurations which I turned on per this page; I've used Apache before so I know the basics of how ...
0
votes
1answer
846 views
Compiling PHP 5.1.6 with PDO MySQL
UPDATE
I Asked this over on StackOverflow as I hadn't got any answers on here at the time.
Here's the link to the answers for completeness' sake. I'll like that page back over here once I've tried ...
0
votes
1answer
943 views
Anyone installed php5-pdo_oci on FreeBSD amd64? [closed]
So far I have the followin result:
===> Verifying install for /usr/local/oracle8-client/lib/libclntsh.a in /usr/ports/databases/oracle8-client
===> oracle8-client-0.2.0_1 is only for i386, ...
0
votes
1answer
1k views
Apache won't restart with PDO MySQL enabled
I attempted to install the PDO MySQL driver onto a server with Solaris using the following commands:
$ pecl download pdo_mysql
$ tar xzf PDO_MYSQL-1.0.2.tgz
$ cd PDO_MYSQL-1.0.2
$ phpize
$ ...
3
votes
1answer
402 views
PDO_mysql for mac
Has anybody gotten PDO_mysql working on the default PHP installation on a mac? It works with MAMP but that's inconvenient.
I'm developing for Zend Framework and mysql, and Zend_db uses PDO. The ...
4
votes
4answers
2k views
How do I tell Apache which PHP to use?
I am running Apache2 on a Mac OS X (10.5). I just compiled PHP 5.2.8 and finally got pdo-mysql working (or so I think). My command line "php --version" is showing 5.2.8 and I have the right modules ...