Connect to an SQLite database and read data php

Question

Connect to an SQLite database and read data php

Answer

<?php
class MyDB extends SQLite3
{
    function __construct()
    {
        $this->open('my-book.db');
    }
}

$db = new MyDB();

$result = $db->query('SELECT * FROM titles');

?>

<?php 
 while($row = $result->fetchArray(SQLITE3_ASSOC)){
        $title = $row['title'];
        $pageNo = $row['pageNo'];
 }
?>