PHP get_categs_tree示例

示例#1

文件： functions.php 项目： smcaleer/scriptmind-links

function get_categs_tree($id = 0)
{
    global $db, $tables;
    static $categs = array("0" => "[Top]");
    static $level = 0;
    $level++;
    $rs = $db->Execute("SELECT `ID`, `TITLE` FROM `{$tables['category']['name']}` WHERE `STATUS` = '2' AND `PARENT_ID` = " . $db->qstr($id) . " AND `SYMBOLIC` <> 1 ORDER BY `TITLE`");
    while (!$rs->EOF) {
        if (empty($_SESSION['user_id']) || $_SESSION['is_admin']) {
            $categs[$rs->Fields('ID')] = str_repeat('|&nbsp;&nbsp;&nbsp;', $level - 1) . '|___' . $rs->Fields('TITLE');
        } else {
            if (in_array($rs->Fields('ID'), $_SESSION['user_permission_array'])) {
                $categs[$rs->Fields('ID')] = str_repeat('|&nbsp;&nbsp;&nbsp;', $level - 1) . '|___' . $rs->Fields('TITLE');
            }
        }
        get_categs_tree($rs->Fields('ID'));
        $rs->MoveNext();
    }
    $level--;
    return $categs;
}

示例#2

文件： email_send_and_add_link.php 项目： smcaleer/scriptmind-links

                }
            } else {
                $tpl->assign('sql_error', $db->ErrorMsg());
            }
        } else {
            $tpl->assign('send_error', true);
        }
    }
}
$rs = $db->Execute("SELECT `ID`, `TITLE` FROM `{$tables['email_tpl']['name']}` WHERE `TPL_TYPE` = '3'");
$tpls = $rs->GetAssoc();
$tpl->assign('tpls', $tpls);
$tpl->assign($full_data);
$tpl->assign('EMAIL_TPL_ID', $_REQUEST['EMAIL_TPL_ID']);
$tpl->assign('IGNORE', $_REQUEST['IGNORE']);
$categs = get_categs_tree(0);
$tpl->assign('categs', $categs);
$content = $tpl->fetch('email_send_and_add_link.tpl');
$tpl->assign('content', $content);
//Clean whitespace
$tpl->loadFilter('output', 'trimwhitespace');
//Make output
echo $tpl->fetch('main.tpl');
function check_email($value, $empty, &$params, &$form)
{
    global $db, $tpl, $tables;
    $rs = $db->Execute("SELECT `ID`, `TITLE`, `URL` FROM `{$tables['link']['name']}` WHERE `URL` = " . $db->qstr($form['URL']) . " OR `TITLE` = " . $db->qstr($form['TITLE']));
    $err['dir'] = array();
    while (!$rs->EOF) {
        if (strcasecmp($rs->Fields('URL'), $form['URL']) == 0) {
            $err['dir'][] = 'URL';

示例#3

文件： dir_links_edit.php 项目： smcaleer/scriptmind-links

     }
     break;
 case 'E':
     if (empty($_REQUEST['submit'])) {
         $data = $db->GetRow("SELECT * FROM `{$tables['link']['name']}` WHERE `ID` = " . $db->qstr($id));
     }
 case 'N':
 default:
     if ($action == 'N') {
         $data['STATUS'] = 2;
         $data['RECPR_REQUIRED'] = REQUIRE_RECIPROCAL;
         if (FTR_ENABLE == 1) {
             $data['FEATURED'] = isset($_REQUEST['f']) && $_REQUEST['f'] == 1 ? 1 : 0;
         }
     }
     $categs = get_categs_tree($db, 0);
     $tpl->assign('categs', $categs);
     if (empty($_REQUEST['submit'])) {
         SmartyValidate::connect($tpl);
         SmartyValidate::register_form('dir_links_edit', true);
         SmartyValidate::register_criteria('isValueUnique', 'validate_unique', 'dir_links_edit');
         SmartyValidate::register_criteria('isNotEqual', 'validate_not_equal', 'dir_links_edit');
         SmartyValidate::register_validator('v_TITLE', 'TITLE', 'notEmpty', false, false, 'trim', 'dir_links_edit');
         SmartyValidate::register_validator('v_TITLE_U', "TITLE:link:{$id}:CATEGORY_ID", 'isValueUnique', false, false, null, 'dir_links_edit');
         SmartyValidate::register_validator('v_URL', 'URL', 'isURL', false, false, 'trim', 'dir_links_edit');
         SmartyValidate::register_validator('v_URL_U', 'URL:link:' . $id . (ALLOW_MULTIPLE ? ':CATEGORY_ID' : ''), 'isValueUnique', false, false, null, 'dir_links_edit');
         SmartyValidate::register_validator('v_CATEGORY_ID', 'CATEGORY_ID:0', 'isNotEqual', true, false, null, 'dir_links_edit');
         SmartyValidate::register_validator('v_RECPR_URL', 'RECPR_URL', 'isURL', true, false, 'trim', 'dir_links_edit');
         SmartyValidate::register_validator('v_OWNER_NAME', 'OWNER_NAME', 'notEmpty', true, false, 'trim', 'dir_links_edit');
         SmartyValidate::register_validator('v_OWNER_EMAIL', 'OWNER_EMAIL', 'isEmail', true, false, 'trim', 'dir_links_edit');
         SmartyValidate::register_validator('v_EXPIRY_DATE', 'EXPIRY_DATE', 'isDate', true, false, 'trim', 'dir_links_edit');