PHP PDO Exception - Only when run from terminal

Question

I am developing PHP and have a simple file to test various functionality. To facilitate this I would like to run this file from the command line. This is causing a problem and I'm not sure what it is.

The code makes use of PDO. I have a Database class that acts as a PDO wrapper and enforces a singleton design patter. The class is very simple. Here is some of the relevant code:

// instance of PDO
private static $db = null;

//connection related fields
const dsn = "mysql:dbname=mydb;host=localhost";
const user = "myuser";
const password = "mypass";

//get access to the PDO instance
public static function get_instance()
{
    if(!self::$db)
    {
        self::$db = new PDO(self::dsn,self::user,self::password);
        self::$db->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
        self::$db->exec("set names utf8");
    }

    return self::$db;

}

Now when I create a test file with the following:

$db = Database::get_instance();

and run it from the command line like so:

php5 ./testing.php

I get an exception: PDOException' with message 'could not find driver' this is caused by the line above that instantiates a new PDO object.

HOWEVER if I navigate to this file via my browser and it is served by my web server it runs fine, the object works as expected.

This appears to be an issue with running a PHP file from the terminal. I don't think this is an issue in code. Could anyone suggest what could be causing this? Any advice or help would really be appreciated. Thanks.

hakre · Accepted Answer · 2012-04-14 19:04:08Z

3

The commandline version of PHP can have a different configuration than the web-version. Locate the proper PHP configuration file, setup the database drivers and you should be fine.

answered Apr 14, 2012 at 19:04

hakre

200k55 gold badges454 silver badges865 bronze badges

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

Comments

Fad · Accepted Answer · 2012-09-24 15:46:24Z

2

/usr/local/php/bin/php -> /usr/bin/php

/usr/bin/php is commandline version of PHP, /usr/local/php/bin/php is web version

try ln command

edited Sep 24, 2012 at 15:46

Fad

9,8683 gold badges48 silver badges65 bronze badges

answered Sep 6, 2012 at 8:26

mien

211 bronze badge

Collectives™ on Stack Overflow

PHP PDO Exception - Only when run from terminal

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related