function prepare_items() { /** * First, lets decide how many records per page to show */ $per_page = 25; $album_id = 0; $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); $this->_column_headers = array($columns, $hidden, $sortable); $this->process_bulk_action(); global $wpdb; $album_table = WPPG_TBL_ALBUM; /* -- Ordering parameters -- */ //Parameters that are going to be used to order the result isset($_GET["orderby"]) ? $orderby = strip_tags($_GET["orderby"]) : ($orderby = ''); isset($_GET["order"]) ? $order = strip_tags($_GET["order"]) : ($order = ''); $orderby = !empty($_GET["orderby"]) ? esc_sql($_GET["orderby"]) : 'id'; $order = !empty($_GET["order"]) ? esc_sql($_GET["order"]) : 'ASC'; $orderby = WP_Photo_Gallery_Utility::sanitize_value_by_array($orderby, $sortable); $order = WP_Photo_Gallery_Utility::sanitize_value_by_array($order, array('DESC' => '1', 'ASC' => '1')); $data = $wpdb->get_results("SELECT * FROM {$album_table} ORDER BY {$orderby} {$order}", ARRAY_A); $current_page = $this->get_pagenum(); $total_items = count($data); $data = array_slice($data, ($current_page - 1) * $per_page, $per_page); $this->items = $data; $this->set_pagination_args(array('total_items' => $total_items, 'per_page' => $per_page, 'total_pages' => ceil($total_items / $per_page))); }
function prepare_items() { /** * First, lets decide how many records per page to show */ $per_page = 25; $gallery_id = 0; $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); $this->_column_headers = array($columns, $hidden, $sortable); $this->process_bulk_action(); global $wpdb; $gallery_items_table = WPPG_TBL_GALLERY; //Let's get the gallery id if (isset($_GET['wppg_gallery_id'])) { $gallery_id = strip_tags($_GET['wppg_gallery_id']); } /* -- Ordering parameters -- */ //Parameters that are going to be used to order the result isset($_GET["orderby"]) ? $orderby = strip_tags($_GET["orderby"]) : ($orderby = ''); isset($_GET["order"]) ? $order = strip_tags($_GET["order"]) : ($order = ''); $orderby = !empty($_GET["orderby"]) ? esc_sql($_GET["orderby"]) : 'id'; $order = !empty($_GET["order"]) ? esc_sql($_GET["order"]) : 'DESC'; $orderby = WP_Photo_Gallery_Utility::sanitize_value_by_array($orderby, $sortable); $order = WP_Photo_Gallery_Utility::sanitize_value_by_array($order, array('DESC' => '1', 'ASC' => '1')); $data = $this->fetch_gallery_images($gallery_id, $orderby, $order); $current_page = $this->get_pagenum(); $total_items = count($data); $data = array_slice($data, ($current_page - 1) * $per_page, $per_page); $this->items = $data; $this->set_pagination_args(array('total_items' => $total_items, 'per_page' => $per_page, 'total_pages' => ceil($total_items / $per_page))); }