I'm working my way 'slowly' through the php101 tutorials and have got to number 9, where I need SQLite.
I've got SQLite3 running and can access via the CLI, (see screenshot of a little test DB) but when I try the tutorial scripts in php101, I get a blank browser screen. I now know this is because SQLite3 uses PDO (php101 is based on SQLite v2).
Couldn't post and image so CLI says:
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select * from books;
1|The Lord of the Rings|J.R. Tolkien
Etc Etc
Rather than go backwards, I'm trying to figure out how to enable the SQLite3 PDO driver (which I know is named sqlite) but those who have posted on stackoverflow to date, seems to have the SQLite driver installed and enable already, so driver config was not actually explained.
(sorry could post an image) but phpinfo for PDO says:
PDO
PDO support | enabled
PDO drivers |mysql
pdo_mysql
PDO Driver for MySQL |enabled
Client API version |5.1.49
I've checked on www.phpro.org/tutorials/Introduction-to-PHP-PDO but it is not explained there either.
My System is Linux Ubuntu 10.10
Apache - version 2.2.16
PHP version 5.3.3
SQLite 3.7.2
I'm trying to get this running on localhost as a learning aid initally.
Can someone explain how to install/configure the SQLite3 driver.