PDO is good way to connect with database in PHP
PDO construct connect to SQLite , argument should be database file name
$db = new PDO('sqlite.db');
if you use 'sqlite::memory:' instead of file name . it use SQLite memory . data will flushed at every run . so its can be temporary use.
$db = new PDO('sqlite::memory:');
exec function is used to execute the query .
$db->exec("CREATE TABLE strings(a)");
will create a table
you can also prepare statement and run it when data ready
$insert = $db->prepare('INSERT INTO strings VALUES ("abc")');
$insert->execute();
how to fetch data in SQLite with PHP
$db->exec("CREATE TABLE strings(a)");
final code ::
sqlite.php
$db = new PDO('sqlite::memory:');
$db->exec("CREATE TABLE strings(a)");
$insert = $db->prepare('INSERT INTO strings VALUES ("abc")');
$insert->execute();
print_r($db->query('SELECT a from strings')->fetchAll());