public function show($id) { $event = \App\Event::where('id', $id)->get()->toArray(); if (empty($event)) { App: abort(404); } $event = $event[0]; $media = \App\Media::join('event_media', 'media.id', '=', 'event_media.mediaID')->where('event_media.eventID', $id)->get()->toArray(); return view('show/event')->with(['event' => $event, 'media' => $media]); }
public function editForm() { $eventNames = \App\Event::get()->pluck('name', 'id')->toArray(); $mediaNames = \App\Media::get()->pluck('name', 'id')->toArray(); $eventIDs = \App\Event::get()->pluck('id')->toArray(); $mediaIDs = \App\Media::get()->pluck('id')->toArray(); $mediaToEvents = array(); $eventToMedia = array(); foreach ($eventIDs as $eventID) { $eventToMedia[$eventID] = \App\Media::join('event_media', 'media.id', '=', 'event_media.mediaID')->where('event_media.eventID', $eventID)->get()->pluck('name', 'id')->toArray(); } foreach ($mediaIDs as $mediaID) { $mediaToEvents[$mediaID] = \App\Event::join('event_media', 'events.id', '=', 'event_media.eventID')->where('event_media.mediaID', $mediaID)->get()->pluck('name', 'id')->toArray(); } return view('forms/editRelationships')->with(['eventNames' => $eventNames, 'mediaNames' => $mediaNames, 'eventToMedia' => $eventToMedia, 'mediaToEvents' => $mediaToEvents]); }