PHP option_sub_cat Examples

Example #1

File: mod_params.php Project: mul14/FiyoCMS

function option_sub_cat($parent_id, $cat, $pre)
{
    $db = new FQuery();
    $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id} AND id!={$_REQUEST['id']}");
    while ($qr = mysql_fetch_array($sql)) {
        $s = multipleSelected($cat, $qr['id']);
        echo "<option value='{$qr['id']}' {$s}>{$pre} |_ {$qr['name']}</option>";
        option_sub_cat($qr['id'], $cat, $pre . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
    }
}

Example #2

File: field_article.php Project: mul14/FiyoCMS

" style="min-width:120px;" required="required">
				<option value=""></option>
					<?php 
$_GET['id'] = 0;
$db = new FQuery();
$db->connect();
$sql = $db->select(FDBPrefix . 'article_category', '*', 'parent_id=0');
while ($qrs = mysql_fetch_array($sql)) {
    if ($qrs['level'] >= $_SESSION['USER_LEVEL']) {
        if ($qr['category'] == $qrs['id']) {
            $s = "selected";
        } else {
            $s = "";
        }
        echo "<option value='{$qrs['id']}' {$s}>{$qrs['name']}</option>";
        option_sub_cat($qrs['id'], '');
    }
}
?>
				</select></td>
			</tr>			
			<tr>
				<td class="row-title" title="<?php 
echo Active_Status;
?>
">Status</td>
				<td>
				<?php 
if ($qr['status'] or $_GET['act'] == 'add') {
    $status1 = "selected checked";
    $status0 = "";

Example #3

File: sys_menu.php Project: mul14/FiyoCMS

function option_sub_cat($parent_id, $pre)
{
    $db = new FQuery();
    $db->connect();
    $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id} AND id!={$_REQUEST['id']}");
    while ($qr = mysql_fetch_array($sql)) {
        //select article 'info'rmation
        $sql2 = $db->select(FDBPrefix . 'article', '*', "id={$_REQUEST['id']}");
        $at = mysql_fetch_array($sql2);
        //select article category 'info'rmation
        $sql3 = $db->select(FDBPrefix . 'article_category', '*', "id={$_REQUEST['id']}");
        $pd = mysql_fetch_array($sql3);
        if ($pd['parent_id'] == $qr['id'] or $at['category'] == $qr['id']) {
            $s = "selected";
        } else {
            $s = "";
        }
        echo "<option value='{$qr['id']}' {$s}>{$pre} |_ {$qr['name']}</option>";
        option_sub_cat($qr['id'], $pre . "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
    }
}

Example #4

File: sys_article.php Project: mul14/FiyoCMS

function option_sub_cat($parent_id, $pre)
{
    $db = new FQuery();
    $db->connect();
    if (!isset($_REQUEST['id']) or $_REQUEST['act'] == 'add') {
        $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id}");
    } else {
        $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id} AND id != {$_REQUEST['id']}");
    }
    while ($qr = @mysql_fetch_array($sql)) {
        if ($qr['level'] >= $_SESSION['USER_LEVEL']) {
            $scat = $pcat = 0;
            if (isset($_REQUEST['id'])) {
                $scat = oneQuery('article', 'id', $_REQUEST['id'], 'category');
                $pcat = oneQuery('article_category', 'id', $scat, 'parent_id');
            }
            if ($pcat == $qr['id'] or $scat == $qr['id']) {
                $s = "selected";
            } else {
                $s = "";
            }
            echo "<option value='{$qr['id']}' {$s}>{$pre}|_ {$qr['name']}</option>";
            option_sub_cat($qr['id'], $pre . "&nbsp;&nbsp;&nbsp;&nbsp;");
        }
    }
}

Example #5

File: add_category.php Project: mul14/FiyoCMS

?>
"><?php 
echo Parent_category;
?>
</span></td>
					<td><select name="parent_id" class="parents" data-placeholder="<?php 
echo Choose_category;
?>
" style="min-width:125px;">
					<option value=''></option>
					<?php 
$level = $row['level'];
$sql2 = $db->select(FDBPrefix . 'article_category', '*', 'parent_id=0');
while ($row2 = mysql_fetch_array($sql2)) {
    echo "<option value='{$row2['id']}'>{$row2['name']}</option>";
    option_sub_cat($row2['id'], "");
}
?>
					</select></td>
				</tr>
				<tr>
					<td class="row-title"><span class="tips" title="<?php 
echo Category_level;
?>
"><?php 
echo Access_Level;
?>
</span></td>
					<td><select name="level" >
						 <?php 
$sql2 = $db->select(FDBPrefix . 'user_group');

Example #6

File: app_params.php Project: mul14/FiyoCMS

			<tr class="category">
				<td class="row-title">Category</td>
				<td>
					<select id="cat">
					<?php 
$db = new FQuery();
$db->connect();
$sql = $db->select(FDBPrefix . 'article_category', '*', 'parent_id=0');
while ($qrs = mysql_fetch_array($sql)) {
    if ("?app=article&view=category&id={$qrs['id']}" == $qr['link']) {
        $s = "selected";
    } else {
        $s = "";
    }
    echo "<option value='{$qrs['id']}' {$s}>{$qrs['name']}</option>";
    option_sub_cat($qrs['id'], '', $qr['link']);
}
?>
					</select>
				</td>
			</tr>	
	
					
			<tr class="item" >
				<td class="row-title">Article</td>
				<td>
					<input type="hidden" value="?app=article&view=item&id=<?php 
echo $id;
?>
" id="pgs" size="20" readonly /> 
					<input type="text" value="<?php