Add SqLite to PHP5

Question

I'm using Ubuntu 14.04 64 bit and installed the php5 package from the repositories which brought Apache with it. Php itself works but when I try to use new SQLiteDatabase([...]), the error

Fatal error: Class 'SQLiteDatabase' not found in [...] on line [...]

is printed.

The php.ini in use is /etc/php5/apache2/php.ini (according to phpinfo() (link to the website it prints)). I noticed that in the php.ini the block

[sqlite]
; http://php.net/sqlite.assoc-case
;sqlite.assoc_case = 0

[sqlite3]
;sqlite3.extension_dir =

doesn't set an extension directory. I tried finding files called sqlite3 on my system and putting a path to their directories in there, but it didn't work (and I restarted my machine after changing the php.ini).

The package php5-sqlite3 doesn't exist for Ubuntu 14.04 but php5-sqlite does and I installed it before trying anything else. I then also installed the packages sqlite3 and sqlite, but again: I doesn't work.

can you find information about sqlite ext in your phpinfo() ? — Sergio Ivanuzzo
– Sergio Ivanuzzo, Commented Oct 17, 2015 at 22:09
@SergioIvanuzzo Do you mean sqlite3.extension_dir? If so: Both Local Value and Master Value are set to "no value". Otherwise: I added the website phpinfo() prints to my question: dl.dropboxusercontent.com/u/9402513/phpinfo%28%29.html — UTF-8
– UTF-8, Commented Oct 17, 2015 at 22:13
have you restarted your apache server after sqlite installing? — Sergio Ivanuzzo
– Sergio Ivanuzzo, Commented Oct 17, 2015 at 22:17
Yes, I did. (Some more characters so I can post this comment.) — UTF-8
– UTF-8, Commented Oct 17, 2015 at 22:22
well, I have same error after trying to install.. I will testing and answer to you, when find a solution — Sergio Ivanuzzo
– Sergio Ivanuzzo, Commented Oct 17, 2015 at 22:42

Sergio Ivanuzzo · Accepted Answer · 2015-10-17 23:07:04Z

1

I have found a solution. So, according to http://stevenclark.info/wp/fatal-error-class-sqlitedatabase-not-found-in/

As of PHP 5.4 the SQLiteDatabase class was removed to make way for SQLite 3.

So, you need to use this:

$db=new SQLite3("db.sqlite");

answered Oct 17, 2015 at 23:07

Sergio Ivanuzzo

1,9225 gold badges36 silver badges67 bronze badges

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

1 Comment

UTF-8 Over a year ago

That would've been it? Oo It works, thank you! PDO also works!

Collectives™ on Stack Overflow

Add SqLite to PHP5

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related