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\'];
 }
?>