public static function get_by_id($id) { global $mysqli; $config = new Config(); $id = sanitize_input($id); $sql = "SELECT `id`, `user_id`, `title`, `content`, `image`, `date` FROM `{$config->database->{$config->site_identifier}->prefix}items` WHERE `id` = {$id} ORDER BY `id` DESC"; $query = mysqli_query($mysqli, $sql); $result = mysqli_fetch_assoc($query); if (!is_array($result)) { return $item; } else { $item = new Item($result); $item->date = date('c', strtotime($item->date)); $item->user = $item->user(); $item->comments = $item->comments(); $item->likes = $item->likes(); unset($item->user->password); return $item; } }