Example #1
0
function fetchCategoryTree($parent = 0, $spacing = '', $user_tree_array = '')
{
    global $connection;
    if (!is_array($user_tree_array)) {
        $user_tree_array = array();
    }
    $sql = "SELECT `cat_unid`, `cat_name`, `par_cat` FROM `website_categories` WHERE 1 AND `par_cat` = {$parent} ORDER BY cat_unid ASC";
    $query = mysql_query($sql, $connection);
    if (mysql_num_rows($query) > 0) {
        while ($row = mysql_fetch_object($query)) {
            $user_tree_array[] = array("id" => $row->cat_unid, "name" => $spacing . $row->cat_name, "parent" => $row->par_cat);
            $user_tree_array = fetchCategoryTree($row->cat_unid, $spacing . '   ', $user_tree_array);
        }
    }
    return $user_tree_array;
}
Example #2
0
  <div class="main-container">
    <div class="container">
      <div class="row">
        <div class="col-md-9 page-content">
          <div class="inner-box category-content">
            <h2 class="title-2 uppercase"><strong> <i class="icon-docs"></i> Post a Free Classified Ad</strong> </h2>
            <div class="row">
              <div class="col-sm-12">
                <form class="form-horizontal">
                  <fieldset>
                    <!-- Select Basic -->
                    <div class="form-group">
                      <label class="col-md-3 control-label" >Category</label>
                      <div class="col-md-8">
					  <?php 
$categoryList = fetchCategoryTree();
?>
<select name="category-group" id="category-group" class="form-control">
<?php 
foreach ($categoryList as $cl) {
    if ($cl["parent"] == 0) {
        ?>
  <option value="<?php 
        echo $cl["id"];
        ?>
" style="background-color:#E9E9E9;font-weight:bold;" disabled="disabled"><?php 
        echo $cl["name"];
        ?>
</option>
<?php 
    } else {