PHP display_category_row Examples

Example #1

File: display-category.php Project: laiello/cartonbank

function display_categories($id = null, $level = 0)
{
    global $wpdb, $category_data;
    if (is_numeric($id)) {
        $category_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `active`='1' AND `category_parent` = '" . $id . "' ORDER BY `id`";
        $category_list = $wpdb->get_results($category_sql, ARRAY_A);
    } else {
        $category_sql = "SELECT * FROM `" . $wpdb->prefix . "product_categories` WHERE `active`='1' AND `category_parent` = '0' ORDER BY `id`";
        $category_list = $wpdb->get_results($category_sql, ARRAY_A);
    }
    if ($category_list != null) {
        foreach ($category_list as $category) {
            display_category_row($category, $level);
            display_categories($category['id'], $level + 1);
        }
    }
}

Example #2

File: display-groups.page.php Project: BGCX261/zombie-craft-svn-to-git

function display_categories($group_id, $id = null, $level = 0)
{
    global $wpdb, $category_data;
    if (is_numeric($id)) {
        $category_sql = "SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `group_id` IN ('{$group_id}') AND `active`='1' AND `category_parent` = '" . $id . "' ORDER BY `id`";
        $category_list = $wpdb->get_results($category_sql, ARRAY_A);
    } else {
        $category_sql = "SELECT * FROM `" . WPSC_TABLE_PRODUCT_CATEGORIES . "` WHERE `group_id` IN ('{$group_id}') AND `active`='1' AND `category_parent` = '0' ORDER BY `id`";
        $category_list = $wpdb->get_results($category_sql, ARRAY_A);
    }
    if ($category_list != null) {
        foreach ($category_list as $category) {
            display_category_row($category, $level);
            display_categories($group_id, $category['id'], $level + 1);
        }
    }
}