public function ScrapeDestinations($scrapecity) { //so far haveing vienna, berlin, munich $dbcolumn = $scrapecity . '_operated'; //viennadestinations is from https://www.google.cz/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=direct%20flights%20from%20vienna $url = 'http://www.prague-airport.com/' . $scrapecity . 'destinations'; // single curl request $fetch = parent::SingleCurl($url); //$fetch[EXE] is html, $fetch[INF] is info about scrape $dataArray = parent::ExtractWithXpath($fetch['EXE'], $this->CityCountryPatterns, 'text', 'multiple'); //update vienna_operated //set all to false DB::table('cities')->update(array($dbcolumn => 0)); foreach ($dataArray as $raw_input) { //update operated column $address = Address::has('city')->where('raw_input', $raw_input)->first(); if (!empty($address)) { $address->city->{$dbcolumn} = 1; $address->push(); } else { Address::firstOrCreate(['raw_input' => $raw_input]); } } }