Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. global $wpdb;
  2. $data = $wpdb->get_results($wpdb->prepare("SELECT * FROM `wp_gj73yj2g8h_hills_school_data` " . $where_query_text . ";"));
  3. $rows_per_page = 7;
  4. $current = (intval(get_query_var('paged'))) ? intval(get_query_var('paged')) : 1;
  5.  
  6.  
  7. $data = $wpdb->get_results($wpdb->prepare("SELECT * FROM `wp_gj73yj2g8h_hills_school_data` " . $where_query_text . ";"));
  8.  
  9. global $wp_rewrite;
  10. $pagination_args = array(
  11. 'base' => @add_query_arg('paged','%#%'),
  12. 'format' => '',
  13. 'total' => ceil(sizeof($data)/$rows_per_page),
  14. 'current' => $current,
  15. 'show_all' => false,
  16. 'type' => 'plain',
  17. );
  18.  
  19.  
  20.  
  21. if( $wp_rewrite->using_permalinks() )
  22. $pagination_args['base'] = user_trailingslashit( trailingslashit( remove_query_arg('s',get_pagenum_link(1) ) ) . 'page/%#%/', 'paged');
  23.  
  24. if( !empty($wp_query->query_vars['s']) )
  25. $pagination_args['add_args'] = array('s'=>get_query_var('s'));
  26.  
  27. $output_string = '';
  28.  
  29. $output_string .= paginate_links($pagination_args);
  30.  
  31. $start = ($current - 1) * $rows_per_page;
  32. $end = $start + $rows_per_page;
  33. $end = (sizeof($data) < $end) ? sizeof($data) : $end;
  34.  
  35. $output_string .= '<br>';
  36.  
  37. $output_string .= '<div class="clearfix row">';
  38. $output_string .= '<div class="columns small-12 large-12">';
  39. $output_string .= '<h2 class="school-heading"><em>Schools</em></h2>';
  40. $output_string .= '<div class="horizontalLine"></div>';
  41. $output_string .= '</div>';
  42. $output_string .= '</div>';
  43. for($i=$start;$i < $end; ++$i)
  44. {
  45. $rows = $data[$i];
  46. /*Displays the Content*/
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement