Installing SQLite2 on Linux

Print

Here's how to take advantage of SQLite with PHP4 under linux!

Here I will skip installing the extension using packet!
It is now available whatever your distribution. (RedHat, Mandrake, Debian ..)

 

First download the extension source SQLite-1.0.3.tgz
If you installed PEAR is very simple, you just open a console and execute the command:

pear install SQLite-1.0.3.tgz


If you have not activated PEAR and that, like me! you do not want to do, run the following commands:
tar xzf SQLite-1.0.3.tgz
cd SQLite-1.0.3 /
If you install PHP with RPM
Export PHP_PREFIX = "/ usr"
$ PHP_PREFIX / bin / phpize
If you install PHP from source
Export PHP_PREFIX = "/ usr / local"
$ PHP_PREFIX / bin / phpize
. / configure
make
make install

Verify that the extension 'sqlite.so is well within her repertoire: PHP_PREFIX / lib / php / extensions.
To verify the location of the directory containing the extensions, view your phpinfo () and search for 'extension_dir'

SQLiteManager dynamically load this extension.
If you have disabled dynamic loading (dl), or if you need this extension all the time, you must specify in your php.ini to load extension to START.

To locate your php.ini, look at the line 'Configuration File (php.ini) Path' in your phpinfo ().

open your php.ini, find the loading of extensions by searching the lines in which there 'extension =', then add a line:

extension = sqlite.so

restart your web server.

View your phpinfo () you should see the SQLite