date_default_timezone_set("GMT+2");
$dbfile = 'epg/db/EPG.db';
$dbdate = date ('d M Y H:i', filemtime($dbfile));
$db = new SQLite3($dbfile);
$sql_sName = 'SELECT sName, idEpg FROM epg';
$result = $db->query($sql_sName);
$channel_array = array();
$i = 0;
while($res = $result->fetchArray(SQLITE3_ASSOC)) {
if(!isset($res['sName'])) continue;
$res['sName'] = preg_replace('/\ HD/','',$res['sName']);
$channel_array[$i]['sName'] = $res['sName'];
$channel_array[$i]['idEpg'] = $res['idEpg'];
$i++;
}
print_r($channel_array);
echo $dbdate;
$db->close();
foreach ($channel_array as $entry) {
echo "<input type=\"button\" name=\"" .$entry[idEpg]. "\" value=\"" .$entry['sName']. "\">";
}