如何在php中启用sqlite3的PDO驱动程序？

Question

My SQLite is version 3.4.0: image

However my phpinfo's PDO support for SQLitev3 is not enabled/listed: image

How can I enable it? I installed my web server via XAMPP.

Answer 1

I think that the PDO driver for sqlite3 is called 'sqlite', so you already have it installed. The sqlite2 driver is older.

PDO_SQLITE is a driver that implements the PHP Data Objects (PDO) interface to enable access to SQLite 3 databases.

In PHP 5.1, the SQLite extension also provides a driver for SQLite 2 databases; while it is not technically a part of the PDO_SQLITE driver, it behaves similarly, so it is documented alongside it. The SQLite 2 driver for PDO is provided primarily to make it easier to import legacy SQLite 2 database files into an application that uses the faster, more efficient SQLite 3 driver. As a result, the SQLite 2 driver is not as feature-rich as the SQLite 3 driver.

From http://php.net/manual/en/ref.pdo-sqlite.php