Php 5 + Sqlite On Redhat9, Need help with SQLite support in

[wkuk74]

I have installed apache 2 and php 5 with the sqlite support (--with-sqlite).
However when i try to execute sqlite_open ("database_name") or new SQLiteDatabase("database_name") from the php page i get the following errors:

"Database could not be opened" or "database is encrypted or not found".

The phpinfo(); works just fine but it seems like i can't get or call any sqlite commands.
Can anyone help me getting php 5 with SQLite to work on Redhat 9.
I have also tried installing SQLite from a source and specifying the library during php build (--with-sqlite=/usr/local/sqlite3/lib) to no avail. I don't use php.ini as i understand is not needed.
Any help is appreciated.
Thank you,
Wesley

[swirlee]

PHP needs to have write permission to the directory where you're putting your database file (so that it can create the database file).

Also, for security purposes, make sure that your SQLite database file is either above your document root (i.e. not under htdocs/ or public_html/) or it's behind htaccess password protection so that it cannot be accessed by malicious users.

[wkuk74]

Great, it worked.
I can't believe i spent 2 days installing php thinking i had no sqlite support.