<?php
define('ISITSAFETORUN', TRUE);
$databasename ='mydatabase.sqlite';
$stylesheet = '';
$javascript ='';
$mycss='';
$pagetitle = 'Extract data from Table';
$days = filter_input(INPUT_POST, 'number');



require 'html5head.php';
require 'opendatabase.php';

if (substr($days, 0, 1) !== '-') {
  $days = "+".$days;
}

echo "<p>Database opened. Now reading some data back from the database to confirm it is working</p>";
$sql = "SELECT * FROM events WHERE Eventdate BETWEEN date('now') AND date('now', '$days day')";
echo "<p>Running query</p>";
echo $sql;

sqlite_query($sql);
///////////
///
$result = $db->query($sql) or die('Query failed');
echo "<p>associative array: array uses named fields<p>";
while ($row = $result->fetchArray())
{
    echo "<p></p>associative array:" . htmlspecialchars($row['sessionID']) . " : " . htmlspecialchars($row['Meetingpoint'])."</p>";
    echo "<p>Direct dump of the array:";/*Array uses named fields */
    htmlspecialchars(print_r($row, true));
    echo "</p>";
}
?>