vendredi 23 juin 2017

Laravel Search not working with error massage

What i need is use this search which has a selectable dropdown.see the following screenshot.

enter image description here 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.

enter image description here

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