Fatal error: Class 'SQLite3' not found in....

**4partee** · August 16th, 2008

Running 8.04 64bit desktop w/LAMP added and would like to try out SQLite3 with PHP.

I get the error when running the example from:
http://us.php.net/manual/en/sqlite3.open.php

as follows:

root@voyager:/var/www/foliofn# cat example.php; php example.php
<?php
$db = new SQLite3('mysqlitedb.db');

$db->exec('CREATE TABLE foo (bar STRING)');
$db->exec("INSERT INTO foo (bar) VALUES ('This is a test')");

$result = $db->query('SELECT bar FROM foo');
var_dump($result->fetchArray());
?>

Fatal error: Class 'SQLite3' not found in /var/www/foliofn/example.php on line 2
root@voyager:/var/www/foliofn#

I have used synaptic to install anything I could find related to SQLite/SQLite3.

Any Ideas?

John

**anjanesh** · October 12th, 2008

Same here. I have SQLITE3 extension enabled with version 3.4.2 and yet this doesnt work !
I did sudo apt-get install php5-sqlite php5-slite3

**pldaniels** · October 13th, 2008

Likewise here. I've installed all the php-sqlite packages and accessories for it (yes, and php5-sqlite3 etc) to no avail (restarted apache).

Hope there's a fix for this

**anjanesh** · October 13th, 2008

The installation section http://php.net/manual/en/sqlite3.installation.php doesnt have anything in it !
Is this still in development ?

**wsams** · January 23rd, 2009

These instructions should get the SQLite3 class installed.

Code:

$ sudo apt-get install php5-cli php5-dev make
$ sudo apt-get install libsqlite3-0 libsqlite3-dev
$ sudo apt-get install php5-sqlite3
$ sudo apt-get remove php5-sqlite3
$ cd ~
$ wget http://pecl.php.net/get/sqlite3-0.6.tgz
$ tar -zxf sqlite3-0.6.tgz
$ cd sqlite3-0.6/
$ sudo phpize
$ sudo ./configure
$ sudo make
$ sudo make install
$ sudo apache2ctl restart

Thanks again Anthony.

**Spoom** · October 2nd, 2009

Note that this doesn't actually get PHP to load the extension, so once you've compiled the SQLite3 extension as shown above:

Code:

cd /etc/php5/conf.d
sudo nano sqlite3.ini

...and insert this into the file:

Code:

# configuration for php SQLite3 module
extension=sqlite3.so

Save and then restart Apache:

Code:

sudo /etc/init.d/apache2 restart

And the SQLite3 class should be available in PHP.

By the way, currently there is no installation candidate for php5-sqlite3 in Jaunty, so don't worry if the install complains about that; just continue on, since you're compiling it from source anyway.

**4partee** · October 22nd, 2009

Thanks wsams and Spoom;

John

**kyouren** · March 6th, 2010

Apparently a change of method to PDO, see comment by user pomax in http://www.php.net/manual/en/intro.sqlite3.php

The PDO (PHP Data Object) is documented here - http://www.php.net/manual/en/book.pdo.php

I successfully used:

<?php

/* create new database (OO interface) */
$db2 = new PDO('sqlite:/my_folder/db_php.sqlite');
/* $db2 = new SQLite3("/my_folder/db_php.sqlite"); */
/* create table foo and insert sample data */
$db2->exec("BEGIN;
CREATE TABLE foo (name);
INSERT INTO foo (name) VALUES('Ilia');
INSERT INTO foo (name) VALUES('Ilia2');
INSERT INTO foo (name) VALUES('Ilia3');
COMMIT;");
/* execute a query */

$sql = "SELECT name FROM foo";
foreach ($db2->query($sql) as $row) {
print $row['name'] . "\t";

}
/* not generally needed as PHP will destroy the connection */
$db2 = null;

?>

PS When I tried the sqlite_open, I got a Sqlite 2 file