Trying to connect PDO on a local server

Question

I am trying to connecting PDO on my local server. I'm using Windows 7 Professional 64-bit and have AppServ installed. In a php document I use the following code for connection:

<?php
$dbh = new PDO('mysql:host=localhost;dbname=test', 'root', 'password');
?>

But the code turns out to be an error: Fatal error: Uncaught exception 'PDOException' with message 'could not find driver' in C:\AppServ\www\a.php:2

I checked phpinfo() and it shows that sqlite and sqlite2 are the only two databases installed in PDO. So how can I install MySQL PDO?

You don't have PDO installed. Try with and see if you have PDO — bksi, Oct 07 '13 at 18:07
your PHP install is missing the mysql driver. that's the long and short of it. either it's not activated, or simply not present. — Marc B, Oct 07 '13 at 18:08
[How to install pdo_mysql on Windows](http://www.tothepointsolution.com/site-blog/article/how-to-install-pdomysql-on-windows) — Bill Karwin, Oct 07 '13 at 18:11
Take a look at http://stackoverflow.com/questions/15231676/how-to-enable-pdo-on-appserv-on-windows. — SamV, Oct 07 '13 at 18:11
@bksi: if pdo wasn't installed, then you'd get an unknown object error. — Marc B, Oct 07 '13 at 18:13
Have a look at this post http://stackoverflow.com/questions/15231676/how-to-enable-pdo-on-appserv-on-windows — Corey, Oct 07 '13 at 18:18

score 1 · Accepted Answer · answered Oct 07 '13 at 21:06

1

Thank you all. I just removed the semicolon in the php.ini file for MySQL and it works! The default location of php.ini file is in C:/Windows/.

answered Oct 07 '13 at 21:06

HQXU85

153
3
14

Trying to connect PDO on a local server

1 Answers1