public function update($id) { /* ->firstOrFail is the only method used which supports throwing Exception, so I've used botb try...catch * and if conditions for error checking */ $success = true; $error = ""; $venues = Venues::all(); if (!$venues) { $venues = 'none'; } try { $venue = Venues::where('id', '=', $id)->firstOrFail(); } catch (Illuminate\Database\Eloquent\ModelNotFoundException $e) { $success = false; $error = 'Unable to save this venue: <br />' . $e->getMessage() . '). <br />'; } if ($success == true) { $venue->name = Input::get('name'); $venue->address = Input::get('address'); $venue->city = Input::get('city'); $venue->state = Input::get('state'); $venue->zip = Input::get('zip'); $venue->phone = Input::get('phone'); $venue->website = Input::get('website'); $venue->update(); return Redirect::to('admin/venues/' . $venue->category . '/'); } else { return View::make('admin.venues.edit')->with(['id' => $id, 'status' => 'save_failed', 'venue' => $venue, 'venues' => $venues, 'venues' => Venues::all(), 'error' => $error]); } }
public function category($category) { //$venues = \Venues::on('sqlite')->whereCategory(\Input::get('category'))->get(); $venues = Venues::where('category', $category)->get(); //dd($venues); return View::make('venues', ['venues' => $venues]); }