What i need is use this search which has a selectable dropdown.see the following screenshot.
These selected data are comes under trainee_division which is in registerdetails data table.here is the controller function i`m developing.
$query = $request->search;
$queryType = $request->institute;
$items = DB::table('registerdetails');
if($queryType == 'Operation' || $queryType == 'operation' ){
$items = $items->where('Operation', '=',"%$queryType%");
}
$items = $items->get();
return view('registeredusers.admindivisiondetails')->with('items',$items);
Relevant view is like this
<form action="divisiondetailsSearch" method="post" class="form-inline">
<select name="institute" id="institute">
<option selected="selected" value="Operation">Operation</option>
<option value="NPA">NPA</option>
<option value="BTS-Kurunegala">BTS-Kurunegala</option>
<option value="INOC">INOC</option>
<option value="RNO">RNO</option>
<option value="Implementation">Implementation</option>
<option value="RAN">RAN</option>
<option value="CEE">CEE</option>
<option value="BTS-Jaffna">BTS-Jaffna</option>
<option value="BTS-Colombo">BTS-Colombo</option>
<option value="Transmission">Transmission</option>
<option value="BTS-Rathnapura">BTS-Rathnapura</option>
<option value="IBS">IBS</option>
<option value="NS">NS</option>
<option value="PCN">PCN</option>
<option value="SQ">SQ</option>
<option value="Pro-Transmission">Pro-Transmission</option>
<option value="BTS-Kandy">BTS-Kandy</option>
</select>
<input type="hidden" value="" name="_token" />
<input type="submit" name="submit" value="Search">
</form>
i`m getting this error.
can anyone help me to get solved this one please.
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2sB4hzA
via IFTTT
Aucun commentaire:
Enregistrer un commentaire