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;
}
}
