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.
Pdo ( Portable Data Object ) needs to be installed if it is not done before. For windows platform go to control panel > Add remove program ( or Programs and features ) > Select your PHP installation and click Change. If you are installing PHP fresh then in the setup wizard you can select PDO from Extensions link.
Introduction ¶ PDO_SQLITE is a driver that implements the PHP Data Objects (PDO) interface to enable access to SQLite 3 databases. Note: PDO_SQLITE allows using strings apart from streams together with PDO::PARAM_LOB .
The latest SQLite extension is known as sqlite3 extension that is included in PHP 5.3+. The sqlite3 extension provides an interface for accessing SQLite 3. The sqlite3 includes class interfaces to the SQL commands. In addition, it allows you to create SQL functions and aggregate using PHP.
Go to your php.ini
file and search for "sqlite". These are probably commented:
extension=php_pdo_sqlite.dll
extension=php_sqlite.dll
Uncomment them, and restart Apache.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With