Home / server / Questions / 117617
Accepted
Roman
Asked: 2010-03-01 03:50:31 +0800 CST

What should I change in php.ini to enable usage of sqlite from PHP?

  • 772

At the moment I cannot use sqlite from PHP. Probably I need to change something in my php.ini file. In my php.ini file I found 2 lines containing "sqlite":

[sqlite]
;sqlite.assoc_case = 0

Does semicolon in front of the line means that line is commented? Should I uncomment the second line? Should I change the value of the "sqlite.assoc_case" from 0 to something else?

P.S. I have 2 php.ini files:
/etc/php5/apache2/php.ini
/etc/php5/cli/php.ini
which one should I change?

php php.ini sqlite

1 Answers

  1. Best Answer

    Have you tried my suggestion in your other question to install the php5-sqlite package?

    What you're looking for in php.ini once this package is installed is a line similar to extension=sqlite.so (the module name may be slightly different.)

    The options in the [sqlite] section just change the options when SQLite is in use correctly.

    Yes a ; in front of a line is a comment.

    The file you want to change is the one Apache is using (if you're using accessing your PHP script through a web browser.)

    • 1