diff options
Diffstat (limited to 'status')
| -rw-r--r-- | status/index.php | 52 | ||||
| -rw-r--r-- | status/post.php | 84 |
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 |
