function recursiveMenu($id_cha)
{
    $sql = DB::select("SELECT * FROM categories WHERE parent_id='{$id_cha}'");
    foreach ($sql as $cat) {
        echo "<tr>";
        $arr = "<td>";
        for ($i = 0; $i < $cat->level; $i++) {
            $arr .= '&nbsp&nbsp&nbsp';
        }
        $arr .= ' ' . $cat->name . '</td>';
        echo $arr;
        $url_edit = 'categories/' . $cat->id . '/edit';
        echo "<td><a class='btn btn-primary' href='{$url_edit}'>EDIT</a></td>";
        $haveChild = haveChild($cat->id);
        $url = 'categories/delete/' . $cat->id;
        if ($haveChild > 0) {
            ?>
          <td><a class='btn btn-danger' href='' onclick="return confirm('You can not delete this item. Please delete subcategory first.')">DELETE</a></td>
        <?php 
            recursiveMenu($cat->id);
        } else {
            echo "<td><a class='btn btn-danger' href='{$url}' >DELETE</a></td>";
        }
        echo "</tr>";
    }
}
function recursiveMenu($id_cha)
{
    $categories = DB::table('categories')->where('parent_id', '=', $id_cha)->get();
    ?>
    	<ul class="dropdown2">
    	<?php 
    $word = array();
    foreach ($categories as $category) {
        $numOfWord = str_word_count($category->name);
        $word = explode(' ', $category->name);
        $link = '';
        if ($numOfWord > 1) {
            for ($i = 0; $i < $numOfWord; $i++) {
                $link .= $word[$i];
            }
        } else {
            $link = $category->name;
        }
        echo "<li value='{$category->id}'><a href='http://localhost/HungNH/public/{$link}'>";
        $name = '';
        $name .= '' . $category->name;
        echo $name;
        echo "</a></li>";
        $haveChild = haveChild($category->id);
        if ($haveChild > 0) {
            recursiveMenu($category->id);
        }
    }
    ?>
		</ul>
		<?php 
}
function recursiveMenu($id_cha)
{
    $categories = DB::table('categories')->where('parent_id', '=', $id_cha)->get();
    foreach ($categories as $category) {
        echo "<option value='{$category->id}'>";
        $name = '';
        for ($i = 0; $i < $category->level; $i++) {
            $name .= '&nbsp&nbsp';
        }
        echo $name;
        echo "</option>";
        $haveChild = haveChild($category->id);
        if ($haveChild > 0) {
            recursiveMenu($category->id);
        }
    }
}