public static function aggregate_films($title) { $films = DB::table('catalog')->leftJoin('omdb', 'catalog.title', '=', 'omdb.title_id')->select('catalog.title', 'catalog.venue', 'catalog.cinema', 'catalog.time', 'catalog.day', 'catalog.month', 'catalog.year', 'omdb.img', 'omdb.title_id', 'omdb.runtime', 'omdb.genre', 'omdb.imdb_rating', 'omdb.plot', 'omdb.website', 'omdb.tomato_url')->where('catalog.title', '=', $title)->get(); $replace = Selector::replace('_', " ", $films[0]->title); $trailer = DB::table('trailers')->select('trailers.trailer')->where('trailers.title', '=', $title)->get(); $z = 0; $tempArray = []; $aggregateArray[0]['title_id'] = $films[0]->title; $aggregateArray[0]['title'] = $replace; $aggregateArray[0]['marker'] = 'search'; $aggregateArray[0]['trailer'] = $trailer[0]->trailer; $aggregateArray[0]['img'] = $films[0]->img; $aggregateArray[0]['plot'] = $films[0]->plot; $aggregateArray[0]['website'] = $films[0]->website; $aggregateArray[0]['tomato_url'] = $films[0]->tomato_url; $aggregateArray[0]['genre'] = $films[0]->genre; $aggregateArray[0]['runtime'] = $films[0]->runtime; $aggregateArray[0]['imdb_rating'] = $films[0]->imdb_rating; $aggregateArray[0]['runtime'] = $films[0]->runtime; for ($i = 0; $i < count($films); $i++) { if (array_search($films[$i]->venue, $tempArray) === false) { $tempArray[$z] = $films[$i]->venue; $aggregateArray[$z]['venue'] = $films[$i]->venue; $aggregateArray[$z]['cinema'] = $films[$i]->cinema; $z++; } } return $aggregateArray; }