function show_theme() { global $wpdb; $order = ""; $where = ''; $sort["sortid_by"] = ''; $order = ''; $sort["custom_style"] = ''; $sort["1_or_2"] = ''; $search_tag = ''; $sort["default_style"] = "manage-column column-autor sortable desc"; if (isset($_POST['page_number'])) { if ($_POST['asc_or_desc']) { $sort["sortid_by"] = $wpdb->escape($_POST['order_by']); if ($_POST['asc_or_desc'] == 1) { $sort["custom_style"] = "manage-column column-title sorted asc"; $sort["1_or_2"] = "2"; $order = "ORDER BY " . $sort["sortid_by"] . " ASC"; } else { $sort["custom_style"] = "manage-column column-title sorted desc"; $sort["1_or_2"] = "1"; $order = "ORDER BY " . $sort["sortid_by"] . " DESC"; } } if ($_POST['page_number']) { $limit = ((int) $_POST['page_number'] - 1) * 20; } else { $limit = 0; } } else { $limit = 0; } if (isset($_POST['search_events_by_title'])) { $search_tag = esc_html($_POST['search_events_by_title']); } else { $search_tag = ""; } if ($search_tag) { $where = ' WHERE title LIKE "%' . $search_tag . '%"'; $where .= " AND `id` NOT IN (" . get_option('contact_form_themes', 0) . ")"; } else { $where = " WHERE `id` NOT IN (" . get_option('contact_form_themes', 0) . ")"; } if ($order == "") { $order = "ORDER BY `title` ASC"; } // get the total number of records $query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "formmaker_themes" . $where; $total = $wpdb->get_var($query); $pageNav['total'] = $total; $pageNav['limit'] = $limit / 20 + 1; $query = "SELECT * FROM " . $wpdb->prefix . "formmaker_themes" . $where . " " . $order . " " . " LIMIT " . $limit . ",20"; $rows = $wpdb->get_results($query); html_show_theme($rows, $pageNav, $sort); }
function show_theme() { global $wpdb; $sort["default_style"] = "manage-column column-autor sortable desc"; $sort["custom_style"] = 'manage-column column-autor sortable desc'; $sort["1_or_2"] = 1; $where = ''; $order = ''; $search_tag = ''; $sort["sortid_by"] = 'title'; if (isset($_POST['page_number'])) { if ($_POST['asc_or_desc']) { $sort["sortid_by"] = esc_sql(esc_html(stripslashes($_POST['order_by']))); if ($_POST['asc_or_desc'] == 1) { $sort["custom_style"] = "manage-column column-title sorted asc"; $sort["1_or_2"] = "2"; $order = "ORDER BY " . $sort["sortid_by"] . " ASC"; } else { $sort["custom_style"] = "manage-column column-title sorted desc"; $sort["1_or_2"] = "1"; $order = "ORDER BY " . $sort["sortid_by"] . " DESC"; } } if ($_POST['page_number']) { $limit = (esc_sql(esc_html(stripslashes($_POST['page_number']))) - 1) * 20; } else { $limit = 0; } } else { $limit = 0; } if (isset($_POST['search_events_by_title'])) { $search_tag = esc_sql(esc_html(stripslashes($_POST['search_events_by_title']))); } else { $search_tag = ""; } if ($search_tag) { $where = ' WHERE title LIKE "%' . $search_tag . '%"'; } // get the total number of records $query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "Spider_Video_Player_theme" . $where; $total = $wpdb->get_var($query); $pageNav['total'] = $total; $pageNav['limit'] = $limit / 20 + 1; $query = "SELECT * FROM " . $wpdb->prefix . "Spider_Video_Player_theme" . $where . " " . $order . " " . " LIMIT " . $limit . ",20"; $rows = $wpdb->get_results($query); html_show_theme($rows, $pageNav, $sort); }