pdo connection in php file executed in terminal does not work

I have a php file that if executed in the browser works just fine but when I execute it in the terminal,

php /opt/lampp/htdocs/xampp/site_name/update_db.php

the pdo include and connection do not seem to work because I get the error

could not find driverPHP Fatal error: Call to a member function prepare() on a non-object in /opt/lampp/htdocs/xampp/site_name/update_db.php on line 8

update_db.php

include("roc/include/connection.php");
$db = new PDOConnectionFactory();
$conn = $db->getConnection();

//prepare for utf8 characters
$sql = 'SET NAMES utf8';
$stmt = $conn->prepare($sql);
$result=$stmt->execute();

$sql = 'SET CHARACTER SET utf8';
$stmt = $conn-开发者_开发技巧>prepare($sql);
$result=$stmt->execute();
//**************************


 $sql = 'update video SET
status=? WHERE file_name=?';
$stmt6 = $conn->prepare($sql);
$result=$stmt6->execute(array('1','5cca985383047644f51c4f31d906c8f8'));

Anyone have any ideas?

This topic has been Solved. Read Comments.

Sounds like permission issue. When you execute script from the browser, executing user is usually your web server (i.e. Apache) when you execute it from the console - logged-in user is executing it.

Yep, on the command line you need to set a path or use absolute paths.