summaryrefslogtreecommitdiff
path: root/status
diff options
context:
space:
mode:
Diffstat (limited to 'status')
-rw-r--r--status/index.php52
-rw-r--r--status/post.php84
2 files changed, 136 insertions, 0 deletions
diff --git a/status/index.php b/status/index.php
new file mode 100644
index 0000000..13d5405
--- /dev/null
+++ b/status/index.php
@@ -0,0 +1,52 @@
+<?php
+include_once $_SERVER['DOCUMENT_ROOT'] . '/lib/time.php';
+$db = new PDO("sqlite:{$_SERVER['DOCUMENT_ROOT']}/database.db");
+
+if (isset($_GET['id']) && !empty(trim($_GET['id']))) {
+ $stmt = $db->prepare('SELECT * FROM statuses WHERE id = ?');
+ $stmt->execute([$_GET['id']]);
+
+ $status = $stmt->fetch(PDO::FETCH_ASSOC) ?: null;
+} else {
+ $stmt = $db->query('SELECT id, title, posted_at FROM statuses ORDER BY posted_at DESC');
+ $statuses = $stmt->fetchAll(PDO::FETCH_ASSOC);
+}
+?>
+<!DOCTYPE html>
+<html>
+
+<head>
+ <title>statuses - ilt.su</title>
+ <meta name="description" content="my statuses.">
+ <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
+ <link rel="stylesheet" href="/static/style.css">
+ <link rel="shortcut icon" href="favicon.ico" type="image/x-icon">
+ <meta name="robots" content="noindex, nofollow">
+</head>
+
+<body>
+ <main>
+ <p><a href="/">ilt.su</a> - <a href="/status/">statuses</a></p>
+ <?php if (isset($status)): ?>
+ <h1><?= $status['title'] ?? '<i>No title.</i>' ?></h1>
+ <div>
+ <?= $status['contents'] ?? '<i>No contents.</i>' ?>
+ </div>
+ <p><i>Posted <?= format_timestamp(time() - strtotime($status['posted_at'])) ?> ago</i></p>
+ <?php endif; ?>
+
+ <?php if (isset($statuses)): ?>
+ <h1>Statuses</h1>
+ <ul>
+ <?php foreach ($statuses as $s): ?>
+ <li><a href="/status/?id=<?= $s['id'] ?>"><?= $s['title'] ?></a>
+ <i><?= format_timestamp(time() - strtotime($s['posted_at'])) ?>
+ ago</i>
+ </li>
+ <?php endforeach; ?>
+ </ul>
+ <?php endif; ?>
+ </main>
+</body>
+
+</html> \ No newline at end of file
diff --git a/status/post.php b/status/post.php
new file mode 100644
index 0000000..064d86f
--- /dev/null
+++ b/status/post.php
@@ -0,0 +1,84 @@
+<?php
+include_once $_SERVER['DOCUMENT_ROOT'] . '/lib/time.php';
+
+function str_safe(string $s, int|null $max_length, bool $remove_new_lines = true): string
+{
+ $output = $s;
+
+ if ($remove_new_lines) {
+ $output = str_replace(PHP_EOL, "", $output);
+ }
+
+ $output = htmlspecialchars($output);
+ $output = strip_tags($output);
+
+ if ($max_length) {
+ $output = substr($output, 0, $max_length);
+ }
+
+ $output = trim($output);
+
+ return $output;
+}
+
+$db = new PDO("sqlite:{$_SERVER['DOCUMENT_ROOT']}/database.db");
+
+if ($_SERVER['REQUEST_METHOD'] == 'POST') {
+ $title = str_safe($_POST['title'], 500, true) ?: null;
+ $contents = str_safe($_POST['contents'], null, false) ?: null;
+
+ $db->prepare('INSERT INTO statuses(title, contents) VALUES (?, ?)')
+ ->execute([$title, $contents]);
+
+ $id = $db->lastInsertId();
+
+ header("Location: /status/?id=$id");
+ exit;
+}
+
+if (isset($_GET['id']) && !empty(trim($_GET['id']))) {
+ $stmt = $db->prepare('SELECT * FROM statuses WHERE id = ?');
+ $stmt->execute([$_GET['id']]);
+
+ $status = $stmt->fetch(PDO::FETCH_ASSOC) ?: null;
+} else {
+ $stmt = $db->query('SELECT id, title, posted_at FROM statuses ORDER BY posted_at DESC');
+ $statuses = $stmt->fetchAll(PDO::FETCH_ASSOC);
+}
+?>
+<!DOCTYPE html>
+<html>
+
+<head>
+ <title>new status - ilt.su</title>
+ <meta name="description" content="my statuses.">
+ <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
+ <link rel="stylesheet" href="/static/style.css">
+ <link rel="shortcut icon" href="favicon.ico" type="image/x-icon">
+ <meta name="robots" content="noindex, nofollow">
+</head>
+
+<body>
+ <main>
+ <p><a href="/">ilt.su</a> - <a href="/status/">statuses</a></p>
+ <h1>post a new status</h1>
+ <form action="/status/post.php" method="post">
+ <table>
+ <tr>
+ <th>title:</th>
+ <td><input type="text" name="title" required></td>
+ </tr>
+ <tr>
+ <th>contents:</th>
+ <td><textarea name="contents" placeholder="Can be empty"></textarea></td>
+ </tr>
+ <tr>
+ <th></th>
+ <td><button type="submit">post</button></td>
+ </tr>
+ </table>
+ </form>
+ </main>
+</body>
+
+</html> \ No newline at end of file