/** Get all guests by pagenum, per_page*/
public static function get_all($orderby = 'email', $order = 'asc', $pagenum = 1, $per_page = 15)
{
global $wpdb;
$limit = ($pagenum - 1) * $per_page;
$query = 'SELECT * FROM ' . self::table_name . ' ';
$query .= 'ORDER BY ' . $orderby . ' ' . $order . ' ';
$query .= 'LIMIT ' . $limit . ',' . $per_page . ';';
$results = $wpdb->get_results($query, ARRAY_A);
self::$found_count = self::get_count_element();
if (!is_array($results)) {
$results = array();
return $results;
}
return $results;
}
