PHP get_sub_category示例

示例#1

文件： menu.php 项目： nolines/TinyCms

function get_sub_category($id="0"){
	global $siteUrl;
	$con = "";
	$ul_class = "ul_submenu";
	$li_class_ = "li_owner";
	$qq = mysql_query("SELECT*FROM `categories` WHERE `Parent`='".$id."' ORDER BY `Order` ASC;");
	if(mysql_num_rows($qq)==0)
		return;
	if ($id == "0"){
		$ul_class = "ul_menu";
	}
	$con .= "<ul class=\"".$ul_class."\">";
	$con .= "<li".(($k==0)?(""):(" class=\"".$li_class."\""))."><a href=\"".$siteUrl."\">Home Page</a>";
		while($t = mysql_fetch_array($qq)){
			$k = mysql_num_rows(mysql_query("SELECT*FROM `categories` WHERE `PARENT`='".$t["ID"]."';"));
			$con .= "<li".(($k==0)?(""):(" class=\"".$li_class."\""))."><a href=\"".$siteUrl."content/".$t["URL_TIPI"].".html\">".$t["Category"]."</a>";
			$con .= get_sub_category($t["Id"]);
			$con .= "</li>";
		}
	$con .= "</ul>";
	return $con;
}

示例#2

文件： get_form_details.php 项目： VNOME/lims_new

<?php

/**
 * Created by PhpStorm.
 * User: Sharmal VAIO
 * Date: 6/2/14
 * Time: 10:16 PM
 */
include '../connection/connection.php';
if (isset($_GET['get_category'])) {
    get_category();
} elseif (isset($_GET['get_SubCategory'])) {
    get_sub_category();
} elseif (isset($_GET['get_SpecimenType'])) {
    get_Specimen_Type();
} elseif (isset($_GET['get_SelectSpecimenRetentionTyp'])) {
    get_Select_Specimen_Retention_Typ();
}
function get_category()
{
    $query = mysql_query("SELECT * FROM lab_testcategory ORDER BY category_ID ASC") or die(mysql_error());
    $c = 1;
    while ($row = mysql_fetch_array($query)) {
        $arr1['category_ID'] = $row['category_ID'];
        $arr1['category_IDName'] = $row['category_IDName'];
        $arr1['category_Name'] = $row['category_Name'];
        $category[$c] = $arr1;
        $c++;
    }
    echo json_encode($category);
}

示例#3

文件： include.php 项目： hkulekci/TinyCms

<?php

//include.php
include_once "constants.php";
include_once "errormessages.php";
include_once "func.php";
include_once "connect.php";
include_once "settings.php";
include_once "db_funcs.php";
include_once "seo.php";
//opsiyonel//
include_once "menu.php";
$MetaTitle = meta_title_info($contenID);
$CMSContent = get_content_end($contenID, $contentType);
$CMSCategoryMenu = get_sub_category();

示例#4

文件： header.php 项目： alaaelgndy/almotamiz

$main_cats->execute();
require 'helpers/functions.php';
while ($main_cat = $main_cats->fetch(PDO::FETCH_OBJ)) {
    echo '<li class="dropdown megamenu-80width "><a  class="dropdown-toggle" href="main_cat.php?id=' . $main_cat->id . '">
                                        ' . $main_cat->cat_name_ar . '<b class="caret"> </b> </a>
                                        ';
    $titles = $conn->prepare("SELECT DISTINCT title_ar FROM menu_menu WHERE menu_id = ?");
    $titles->bindValue(1, $main_cat->id, PDO::PARAM_INT);
    $titles->execute();
    echo '<ul class="dropdown-menu"><li class="megamenu-content">';
    while ($title = $titles->fetch(PDO::FETCH_OBJ)) {
        echo '<ul style="float:right;" class="col-lg-2  col-sm-2 col-md-2  unstyled noMarginLeft">';
        echo '<li>
                                           <p><strong> ' . $title->title_ar . ' </strong></p>
                                           </li>';
        echo get_sub_category($main_cat->id, $title->title_ar);
        echo '</ul>';
    }
    echo '</li>';
    echo '</ul>';
    echo '
                                       </li>';
}
?>




                               </ul>

                        </div>