PHP get_nav_cat_one Examples

Example #1

File: admin_nav_fun.php Project: dalinhuang/yy

function get_nav($typeid = NULL)
{
    global $db;
    if ($typeid) {
        $wheresql = " WHERE typeid='" . intval($typeid) . "' ";
    }
    $result = $db->query("SELECT * FROM " . table('navigation') . $wheresql . " order BY display desc,navigationorder desc,id asc");
    while ($row = $db->fetch_array($result)) {
        $category = get_nav_cat_one($row['alias']);
        $row['categoryname'] = $category['categoryname'];
        $row_arr[] = $row;
    }
    return $row_arr;
}

Example #2

File: admin_nav.php Project: source-hunter/74cms

    if (del_nav_cat(intval($_GET['id']))) {
        write_log("删除导航分类", $_SESSION['admin_name'], 3);
        adminmsg("删除成功！", 2);
    } else {
        adminmsg("删除失败！", 0);
    }
} elseif ($act == 'site_navigation_category_edit') {
    get_token();
    $smarty->assign('navlabel', "category");
    $alias = trim($_GET['alias']);
    $smarty->assign('list', get_nav_cat_one($alias));
    $smarty->display('nav/admin_nav_category_edit.htm');
} elseif ($act == 'site_navigation_category_edit_save') {
    check_token();
    $setsqlarr['categoryname'] = trim($_POST['categoryname']) ? trim($_POST['categoryname']) : adminmsg('您没有填写名称！', 1);
    $setsqlarr['alias'] = trim($_POST['alias']) ? trim($_POST['alias']) : adminmsg('您没有填写调用名！', 1);
    if (stripos($setsqlarr['alias'], "qs_") === 0) {
        adminmsg("调用名不能用“qs_”开通", 0);
    } else {
        $info = get_nav_cat_one($setsqlarr['alias']);
        if (empty($info) || $info['alias'] == $setsqlarr['alias']) {
            $link[0]['text'] = "返回列表";
            $link[0]['href'] = "?act=site_navigation_category";
            $wheresql = " id='" . intval($_POST['id']) . "'";
            write_log("修改导航分类", $_SESSION['admin_name'], 3);
            !$db->updatetable(table('navigation_category'), $setsqlarr, $wheresql) ? adminmsg("修改失败！", 0) : adminmsg("修改成功！", 2, $link);
        } else {
            adminmsg("调用名" . $setsqlarr['alias'] . "已经存在！", 0);
        }
    }
}