You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
87 lines
2.0 KiB
87 lines
2.0 KiB
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<title>lifestream</title>
|
|
<link rel="stylesheet" href="css/styles.css">
|
|
</head>
|
|
<body>
|
|
|
|
<?php
|
|
|
|
require_once('config.php');
|
|
|
|
$dsn = 'mysql:dbname=' . $config['db']['name'] . ';host=' . $config['db']['host'];
|
|
$user = $config['db']['user'];
|
|
$password = $config['db']['password'];
|
|
|
|
try {
|
|
$dbh = new PDO($dsn, $user, $password);
|
|
} catch (PDOException $e) {
|
|
die('Connection failed: ' . $e->getMessage());
|
|
}
|
|
|
|
$sql = 'SELECT DISTINCT type FROM subscription';
|
|
$res = $dbh->query($sql);
|
|
$types = array();
|
|
|
|
$html = '<details><summary>Filters</summary><form>';
|
|
|
|
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
|
|
$types[] = $row['type'];
|
|
}
|
|
|
|
$filters = $_GET['filter'];
|
|
|
|
$where = '';
|
|
|
|
foreach($types as $type) {
|
|
$html .= '<label><input type="checkbox" name="filter[]" value="' . $type . '" ';
|
|
|
|
if (!$filters || in_array($type, $filters)) {
|
|
$html .= "checked";
|
|
|
|
$where .= 'OR subscription.type = "' . $type . '"';
|
|
}
|
|
|
|
$html .= ' "> ' . $type . '</label>';
|
|
}
|
|
|
|
$where = ' WHERE ' . substr($where, 2);
|
|
|
|
$html .= '<input type="submit"></form></details>';
|
|
echo $html;
|
|
|
|
$sql = 'SELECT title, content, published, foreign_url, subscription.type FROM event INNER JOIN subscription ON event.subscription_id = subscription.id' . $where . ' ORDER BY published DESC';
|
|
|
|
$res = $dbh->query($sql);
|
|
$html = '<ol id="list">';
|
|
|
|
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
|
|
$html .= '<li class="' . $row['type'] . '"><figure><figcaption>';
|
|
$html .= $row['title'];
|
|
$html .= '</figcaption>';
|
|
$html .= '<blockquote cite="' . $row['foreign_url'] . '">' . $row['content'] . '</blockquote>';
|
|
$html .= '<footer><a href="' . $row['foreign_url'] . '">' . $row['published'] . '</a></footer>';
|
|
$html .= '</figure></li>';
|
|
}
|
|
|
|
$html .= '</ol>';
|
|
|
|
echo $html;
|
|
|
|
?>
|
|
|
|
<script>
|
|
( function() {
|
|
"use strict";
|
|
|
|
window.ls = {
|
|
"port": <?php echo $config['websockets']['port'] ?>
|
|
}
|
|
}() );
|
|
</script>
|
|
<script src="js/websockets.js"></script>
|
|
|
|
</body>
|
|
</html>
|
|
|