PHP get_category_catの例

コード例 #1

ファイル: category_list.php プロジェクト: BackupTheBerlios/core-svn

<?php

$query = sprintf("\r\n    SELECT\r\n        category_id, \r\n        category_parent_id, \r\n        category_name\r\n    FROM \r\n        %1\$s \r\n    WHERE \r\n        category_parent_id = '0' \r\n    ORDER BY \r\n        category_order \r\n    ASC", TABLE_CATEGORY);
$db->query($query);
while ($db->next_record()) {
    $cat_id = $db->f("category_id");
    $cat_parent_id = $db->f("category_parent_id");
    $cat_name = $db->f("category_name");
    if ((bool) $rewrite) {
        $cat_link = '1,' . $cat_id . ',4,item.html';
    } else {
        $cat_link = 'index.php?p=4&amp;id=' . $cat_id . '';
    }
    $ft->assign(array('CAT_NAME' => replace_amp($cat_name), 'CAT_LINK' => $cat_link, 'CLASS' => "cat_parent", 'PARENT' => ''));
    $ft->define_dynamic("category_row", $assigned_tpl);
    $ft->parse('CATEGORY_ROW', ".category_row");
    // funkcja pobieraj±ca rekurencyjnie strony dziedzicz±ce::child
    get_category_cat($cat_id, 2);
}

コード例 #2

ファイル: main_lib.php プロジェクト: BackupTheBerlios/core-svn

function get_category_cat($cat_id, $level)
{
    global $ft, $rewrite;
    $query = sprintf("\r\n        SELECT \r\n            category_id, \r\n            category_parent_id, \r\n            category_name \r\n        FROM \r\n            %1\$s \r\n        WHERE \r\n            category_parent_id = '%2\$d' \r\n        ORDER BY \r\n            category_id \r\n        ASC", TABLE_CATEGORY, $cat_id);
    $db = new DB_SQL();
    $db->query($query);
    while ($db->next_record()) {
        $cat_id = $db->f("category_id");
        $cat_parent_id = $db->f("category_parent_id");
        $cat_name = $db->f("category_name");
        $cat_link = (bool) $rewrite ? '1,' . $cat_id . ',4,item.html' : 'index.php?p=4&id=' . $cat_id . '';
        $ft->assign(array('CAT_NAME' => $cat_name, 'NEWS_CAT' => $cat_id, 'CLASS' => "cat_child", 'PARENT' => str_repeat('  ', $level), 'CAT_LINK' => $cat_link));
        $ft->parse('CATEGORY_ROW', ".category_row");
        get_category_cat($cat_id, $level + 2);
    }
}