I have a PHP script that does the following in the order presented:
- Connect to a MySQL database
- Retrieve a single row of data
- Close the MySQL database connection
- Connect to a SQLite database on the local file system
- Insert the row of data into the SQLite database
- Close the SQLite database connection
I'm using PDO as the vehicle for both MySQL and SQLite. Here is the code for the insert:
$sqlite = new PDO['sqlite:activity.sqlite'];
$sqlite->setAttribute[ PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ];
$lite =