public static function list_all($limit = 10, $offset = 0)
{
global $mysqli;
$config = new Config();
$sql = "SELECT `id` FROM `{$config->database->{$config->site_identifier}->prefix}likes` ORDER BY `date` DESC";
// Limit string
$limit = sanitize_input($limit);
$sql .= " LIMIT {$limit}";
// Offset string
$offset = sanitize_input($offset);
$sql .= " OFFSET {$offset}";
// Get likes
$query = mysqli_query($mysqli, $sql);
// Loop through likes, fetching objects
$likes = array();
while ($query && ($result = mysqli_fetch_assoc($query))) {
$likes[] = Like::get_by_id($result['id']);
}
return $likes;
}
public function likes($limit = 10, $offset = 0)
{
global $mysqli;
$config = new Config();
$sql = "SELECT `id` FROM `{$config->database->{$config->site_identifier}->prefix}likes` WHERE `item_id` = {$this->id}";
// Limit string
$limit = sanitize_input($limit);
$sql .= " LIMIT {$limit}";
// Offset string
$offset = sanitize_input($offset);
$sql .= " OFFSET {$offset}";
$query = mysqli_query($mysqli, $sql);
$likes = array();
while ($query && ($result = mysqli_fetch_assoc($query))) {
$likes[$result['id']] = Like::get_by_id($result['id']);
}
return $likes;
}
