List of doors
busyTimeout(60000);//60 seconds
$db->query('PRAGMA journal_mode = WAL;');
$db->query('PRAGMA busy_timeout = 60000;');
$db->query('PRAGMA cell_size_check = ON;');
$db->query("PRAGMA encoding = 'UTF-8';");
$db->query("PRAGMA foreign_keys = ON;");
$select_query = $db->prepare("SELECT * FROM doors;");
$select_query_result = $select_query->execute();
$array_return= array();
if( is_a($select_query_result, 'SQLite3Result' ) ) {
if ( is_array($array_return) === true)
//no need for count, empty arrays not return
{
while($arrayrow = $select_query_result->fetchArray(SQLITE3_ASSOC) ){
$array_return[]=$arrayrow;
}
}
}
$db->close();
foreach($array_return as $door) {
echo "Hello World!".$door['door_id'];
}
?>