foreach (explode(',', $val) as $s) {
if (isset($datas[$s])) {
$days = isset($_GET['last']) ? $_GET['last'] : 1000;
$last_tms = time() - $days * 24 * 60 * 60;
$storage = new storage($s);
$storage->conn->query("delete from {$s} where tms > {$last_tms}");
echo "Erased all articles from {$s}<br><br>\n\n";
}
}
};
$cmd['t'] = "Create table.";
$func['t'] = function ($val) use($datas) {
foreach (explode(',', $val) as $s) {
if (isset($datas[$s])) {
$storage = new storage($s);
$storage->create_table();
echo "Created table {$s}<br><br>\n\n";
}
}
};
$cmd['r'] = "Read articles.";
$func['r'] = function ($val) use($datas) {
foreach (explode(',', $val) as $name) {
if (isset($datas[$name])) {
$storage = new Storage($name);
if (!isset($_GET['link'])) {
echo "<div style='margin:auto;width:700px;'><h1>" . $datas[$name]()->title . "</h1>";
$days = isset($_GET['days']) ? $_GET['days'] : 2;
foreach ($storage->last_articles($days) as $art) {
echo "<a href='retrieve.php?r={$name}&link=" . urlencode($art->link) . "'>{$art->title}, by {$art->author}</a><br>";
}