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; }
<?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); }
<?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();
$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>