Level 70
May be you can think of it by the help of parentid.
Check it out this link - http://stackoverflow.com/questions/31623575/database-design-categories-and-sub-categories
I am doing an E-commerce project. During the add product form I have this form
<form class="form-horizontal adminex-form" method="post" action="{{ route('coupons.addSubmit') }}">
<div class="form-group">
<label class="col-sm-2 col-sm-2 control-label">Product Name</label>
<div class="col-sm-10">
<input type="text" name="name" class="form-control" value="{{ old('name') }}">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label col-lg-2" for="inputSuccess">Category</label>
<div class="col-lg-10">
<select id="category" class="form-control m-bot15">
<option value="">Select a category</option>
@forelse ($categories as $cat)
<option value="{{ $cat->id }}">{{ $cat->category }}</option>
@empty
<option value="">No categories found.</option>
@endforelse
</select>
</div>
</div>
<div id="subcat">
</div>
@include('products::extras')
<div class="form-group">
<label class="col-sm-2 col-sm-2 control-label">Price</label>
<div class="col-sm-10">
<input type="text" name="price" class="form-control" value="{{ old('price') }}">
</div>
</div>
/*-- Other General Fields --*/
</form>
In my extras view, which is rendered on the basis of the subcategory, I have static fields like this..
{{-- Clothing --}}
<div id="30" class="extras" style="display:none;">
</div>
{{-- Shoes --}}
<div id="24" class="extras" style="display:none;">
</div>
/*-- Other divs --*/
How do I setup my database for my extra attributes..
Please or to participate in this conversation.