Has anyone ever installed PHP5 with SQLiteDatabase class support in CentOS 4.3? I have to run a program with this class for a core feature. But unfortunately, both the php 5.0.4 package in centosplus and a SRPM build from FC5 will not work with this class. With the error "undefined class SQLiteDatabase"!
And there *IS* the "pdo_sqlite.so" extension in my php.d/pdo.ini file, as well as the "pdo.so" class. But when I testing the SQLite support with:
dl("pdo_sqlite.so"); sqlite_open(xxx); new SQLiteDatabase(xxx);
The result is the "dl" line will give out a warning showing that the "pdo_sqlite.so" is already loaded. The "sqlite_open" line will give out a message showing that no function such like "sqlite_open".
All the solutions by Google cannot solve this. Is there anyone can explain this? Or can anyone use SQLite in PHP5?
dl("pdo_sqlite.so"); sqlite_open(xxx); new SQLiteDatabase(xxx);
The result is the "dl" line will give out a warning showing that the "pdo_sqlite.so" is already loaded. The "sqlite_open" line will give out a message showing that no function such like "sqlite_open".
You're loading the pdo version of SQLite, but trying to use the old non-pdo functions.
See docs: http://us2.php.net/manual/en/ref.pdo-sqlite.php
j
-- Jason Bradley Nance What would you cry for? aitrus@tresgeek.net Swallow your pride for? Tres Geek What would you go wild for? http://tresgeek.net/ -Poe, "Wild" --
You're loading the pdo version of SQLite, but trying to use the old non-pdo functions.
These docs, too:
http://us2.php.net/manual/en/ref.pdo.php
j
-- Jason Bradley Nance What would you cry for? aitrus@tresgeek.net Swallow your pride for? Tres Geek What would you go wild for? http://tresgeek.net/ -Poe, "Wild" --
o, thanks a lot!!!!! But is that possible to use both the old SQLite apis and new PDO apis at the same time? I must run an old program on it. Are there any solutions?
On 7/20/06, Jason Bradley Nance aitrus@tresgeek.net wrote:
dl("pdo_sqlite.so"); sqlite_open(xxx); new SQLiteDatabase(xxx);
The result is the "dl" line will give out a warning showing that the "pdo_sqlite.so" is already loaded. The "sqlite_open" line will give out a message showing that no function such like "sqlite_open".
You're loading the pdo version of SQLite, but trying to use the old non-pdo functions.
See docs: http://us2.php.net/manual/en/ref.pdo-sqlite.php
j
-- Jason Bradley Nance What would you cry for? aitrus@tresgeek.net Swallow your pride for? Tres Geek What would you go wild for? http://tresgeek.net/ -Poe, "Wild" -- _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
But is that possible to use both the old SQLite apis and new PDO apis at the same time? I must run an old program on it. Are there any solutions?
Yes, you can have both pdo and non-pdo database extensions enabled at the same time, just enable the correct extension (php_sqlite.so).
j
-- Jason Bradley Nance What would you cry for? aitrus@tresgeek.net Swallow your pride for? Tres Geek What would you go wild for? http://tresgeek.net/ -Poe, "Wild" --
-
Jason Bradley Nance -
Wei Yu