query display particular subcategory for a particular category

If you get you correctly, you can use relationships. A category has many sub category.

For dropdown menu, I think you have to use any standard JS library to synchronize that.

Hi, if you have just on level of dropdown, then is pretty easy.

$categories = DB::table('categories')->select('name')->where('parent_id', '=', NULL)->get();
$subcategories = DB::table('categories')->select('name')->where('parent_id', '!=', NULL)->get();

and in your views

@foreach ($categories as $category)

    {{ $category->name }}

    @foreach ($subcategories as $subcategory)

        @if ( $subcategory->parent_id == $category->id )

            {{ $subcategory->name }}

        @endif

    @endforeach 

@endforeach 

p.s. I didn't test this)

@Sergiu17 shows me error but that property exists in the database

Undefined property: stdClass::$parent_id

@tisuchi according to your solution i need to use two different table for categories and subcategories ??

@Sergiu17 It was wrong in the query that i have tried sir

$categories = DB::table('categories')->select('*')->where('parent_id', '=', NULL)->get();
$subcategories = DB::table('categories')->select('*')->where('parent_id', '!=', NULL)->get();

but the results not show properly if i try to hover on Elect it shows me Refrigi not was not expected. expected was Smart Phone and Tablets

@Shawdow

Not really. Of course, you can make relationships in the same table.

Read this discussion- https://laracasts.com/discuss/channels/eloquent/relationships-with-column-in-same-table

@tisuchi thank you sir i have tried your solution that works with the tinker also.but can you give the description how should i implement for my solution for displaying sub-categories for a particular category!!

@tisuchi i have tried like below when the users over the categories name it should show the list of subcategories for a particular category name

but the results not show properly if i try to hover on Elect it shows me Refrigi not was not expected. expected was Smart Phone and Tablets

<style>


.show-on-hover:hover > ul.dropdown-menu {
    display: block;
  
}

</style>


 <div class="container">
            <div class="row">
            <div class="btn-group show-on-hover">    
@foreach ($categories as $category)
              <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
               {{ $category->name }} <span class="caret"></span>
              </button>
            
    @foreach ($subcategories as $subcategory)
              <ul class="dropdown-menu" role="menu">
                              @if ( $categories->parent_id == $subnames->id )
                <li><a href="">{{ $subcategory->name }}</a></li>
                @endif
              </ul>
                        @endforeach
        @endforeach
            </div>
                    </div>
                 </div>