PHP html_show_spider_calendar 예제들

예제 #1

파일: calendar_functions.php 프로젝트: andripriyanto/WebTKJ-BPI

function show_spider_calendar()
{
    global $wpdb;
    $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 = ($_POST['page_number'] - 1) * 20;
        } else {
            $limit = 0;
        }
    } else {
        $limit = 0;
    }
    if (isset($_POST['search_events_by_title'])) {
        $search_tag = $_POST['search_events_by_title'];
    } else {
        $search_tag = "";
    }
    if ($search_tag) {
        $where = ' WHERE title LIKE "%' . $search_tag . '%"';
    } else {
        $where = ' ';
    }
    // get the total number of records
    $query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "spidercalendar_calendar" . $where;
    $total = $wpdb->get_var($query);
    $pageNav['total'] = $total;
    $pageNav['limit'] = $limit / 20 + 1;
    $query = "SELECT * FROM " . $wpdb->prefix . "spidercalendar_calendar" . $where . " " . $order . " " . " LIMIT " . $limit . ",20";
    $rows = $wpdb->get_results($query);
    // display function
    html_show_spider_calendar($rows, $pageNav, $sort);
}

예제 #2

파일: calendar_functions.php 프로젝트: fnguyen20/CECS-300-Genesis-Site

function show_spider_calendar()
{
    global $wpdb;
    $order = " ORDER BY title ASC";
    $sort["default_style"] = "manage-column column-autor sortable desc";
    $sort["sortid_by"] = "title";
    $sort["custom_style"] = "manage-column column-title sorted asc";
    $sort["1_or_2"] = "2";
    if (isset($_POST['page_number'])) {
        if (isset($_POST['order_by']) && esc_html($_POST['order_by']) != '') {
            $sort["sortid_by"] = esc_sql(esc_html(stripslashes($_POST['order_by'])));
        }
        if (isset($_POST['asc_or_desc']) && esc_html($_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 (isset($_POST['page_number']) && esc_html($_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 "%%' . like_escape($search_tag) . '%%"';
    } else {
        $where = ' ';
    }
    // Get the total number of records.
    $query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "spidercalendar_calendar" . str_replace('%%', '%', $where);
    $total = $wpdb->get_var($query);
    $pageNav['total'] = $total;
    $pageNav['limit'] = $limit / 20 + 1;
    $query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "spidercalendar_calendar" . $where . " " . $order . " " . " LIMIT  %d,20", $limit);
    $rows = $wpdb->get_results($query);
    // display function
    html_show_spider_calendar($rows, $pageNav, $sort);
}