Compiling SQLite 3.4.2 with PHP 5.2.4 on RHEL4

[zash]

Anyone successfully using SQlite 3.4.2 with PHP?

 

I tried compiling PHP with the SQlite source (sqlite-3.4.2.tar.gz ) and the preprocessed source (sqlite-source-3_4_2.zip) . PHP can't find the sqlite 3 files in either approach during the ./configure command.

 

using --enable-pdo=shared --with-pdo-sqlite=shared,/usr/local/sqlite

 

I can't compile SQlite itself, as it gives me errors.

 

Does SQLite need to be compiled first before PHP can compile it as external module?

 

Are there any other sources required besides the sqlite-3.4.2.tar.gz to compile it with PHP?

 

The bundled SQlite 3.3.16 has 2 bugs with can cause corruption of the database in case you wonder why I bother... Spent many hours so far with no luck at all. But having the right documentation is not having luck, it's having knowledge... :-)