Friday, March 31, 2017

Laravel user input form to query database

been trying to create a laravel form with several fields that the user can enter text/number into a field and it takes the field with data and performs a database query. Now the form works with just one field but when i add more fields it only returns data for the final query, not for the other two.

perfumes controller

class perfumescontroller extends Controller
{
  public function index()
 {
   $pstoreNum = request('pstoreNum');


   $result = perfumes::where('StoreNumber','=',$pstoreNum)
        ->get();

    return view('perfumes',compact('result'));


   }

   public function perfWeekSearch()
    {
   $weekNum = request('perfWeekNum');


   $result = perfumes::where('WeekNumber','=',$weekNum)
        ->get();

    return view('perfumes',compact('result'));


    }


    }

Route::get('/perfumes', 'perfumescontroller@index'); Route::get('/perfumes', 'perfumescontroller@perfWeekSearch');

Blade:

<form action="perfumes" method="get">
            
              <div class="input-group">
                <input type="text" class="form-control" name="perfWeekNum"                     placeholder="Type in Store Number"> 
                  <span class="input-group-btn"> 
                    <button type="submit" class="btn btn-default">
                      <span class="glyphicon glyphicon-search"></span>
                    </button>
                  </span>
              </div>
          </form>

Do i need to use some sort of check if not null method? or is there an easier way??

Thanks



via PA060

Advertisement