Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- global $wpdb;
- $data = $wpdb->get_results($wpdb->prepare("SELECT * FROM `wp_gj73yj2g8h_hills_school_data` " . $where_query_text . ";"));
- $rows_per_page = 7;
- $current = (intval(get_query_var('paged'))) ? intval(get_query_var('paged')) : 1;
- $data = $wpdb->get_results($wpdb->prepare("SELECT * FROM `wp_gj73yj2g8h_hills_school_data` " . $where_query_text . ";"));
- global $wp_rewrite;
- $pagination_args = array(
- 'base' => @add_query_arg('paged','%#%'),
- 'format' => '',
- 'total' => ceil(sizeof($data)/$rows_per_page),
- 'current' => $current,
- 'show_all' => false,
- 'type' => 'plain',
- );
- if( $wp_rewrite->using_permalinks() )
- $pagination_args['base'] = user_trailingslashit( trailingslashit( remove_query_arg('s',get_pagenum_link(1) ) ) . 'page/%#%/', 'paged');
- if( !empty($wp_query->query_vars['s']) )
- $pagination_args['add_args'] = array('s'=>get_query_var('s'));
- $output_string = '';
- $output_string .= paginate_links($pagination_args);
- $start = ($current - 1) * $rows_per_page;
- $end = $start + $rows_per_page;
- $end = (sizeof($data) < $end) ? sizeof($data) : $end;
- $output_string .= '<br>';
- $output_string .= '<div class="clearfix row">';
- $output_string .= '<div class="columns small-12 large-12">';
- $output_string .= '<h2 class="school-heading"><em>Schools</em></h2>';
- $output_string .= '<div class="horizontalLine"></div>';
- $output_string .= '</div>';
- $output_string .= '</div>';
- for($i=$start;$i < $end; ++$i)
- {
- $rows = $data[$i];
- /*Displays the Content*/
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement