how to install PHP_MYSQL driver?

[Aman Grover]

I tried the following script:

 

<?php

 

try {

$user='root';

$pass='mysqlmysqli';

$dbh = new PDO ('mysql:hos=localhost;dbname=test',$user,$pass);

 

foreach ($dbh->query('SELECT * FROM albums')as $row) {

print_r($row);

}

 

$dbh=null;

}

catch(PDOException $e) {

print "Error: ". $e->getMessage()."<br />";

die();

}

?>

 

but it shows "error: could not find driver".

I think it is the PHP_MYSQL driver. How can I install it? I looked for it on the net but couldn't find anything. I am just a beginner in PHP. Please help.

[melloorr]

How did you install php? Through xampp or a similar program?

[Aman Grover]

I didn't use any application like XAMPP or any other app. , I simply installed PHP, MySQL , and Apache .

I tried the phpinfo(); script , and it showed : PDO driver : enabled sqlite2.

[DWilliams]

I don't know if this works on every platform, but in my particular Linux distro I just had to uncomment "extension=pdo_mysql.so" in php.ini

[Aman Grover]

But I couldn't find any "extension=pdo_mysql.so"  or anything like that.

[gork4life]

If you don't see it then just add it and restart your server.

[Aman Grover]

Thanks a lot, I just found it and uncommented it