int (only for list_rows), 'name' => string, 'message' => string, 'email' => ?string, 'website' => ?string, 'timestamp' => string (or DateTimeInterface for list_rows)] // message is pre-escaped at insert time. // timestamp is DateTimeInterface::ISO8601_EXPANDED format. abstract class Database { public function append_row(string $name, string $message, ?string $email = NULL, ?string $website = NULL) { $timestamp = date(DATE_ISO8601_EXPANDED); $this->_append_row(compact('name', 'message', 'email', 'website', 'timestamp')); } public function list_rows(): array { $data = $this->_list_rows(); foreach($data as &$row) { $row['timestamp'] = DateTime::createFromFormat(DATE_ISO8601_EXPANDED, $row['timestamp']); } return $data; } public function delete_row(int $id): bool { return $this->_delete_row($id); } abstract protected function _append_row(array $db_row); abstract protected function _list_rows(): array; abstract protected function _delete_row(int $id): bool; } // notes: `id` is not stable final class JsonDatabase extends Database { private string $file; private array $data; public function __construct(string $file) { if (file_exists($file)) $this->data = json_decode(file_get_contents($file), associative: true); else $this->data = array(); $this->file = $file; } private function save() { file_put_contents($this->file, json_encode($this->data)); } protected function _append_row(array $db_row) { array_unshift($this->data, $db_row); $this->save(); } protected function _list_rows(): array { $data = $this->data; foreach($data as $id => &$row) { $row['id'] = $id; } return $data; } protected function _delete_row(int $id): bool { if (!isset($this->data[$id])) return false; unset($this->data[$id]); $this->data = array_values($this->data); $this->save(); return true; } }