public function geocodeCitiesAndAddToTable($cities) { $geocoderInstance = new geocoder($cities); $result = $geocoderInstance->geocode(); //return $result; foreach ($result as $object) { if ($object->existance == 1) { $query = "INSERT INTO {$this->schemaForGeocodingTable}.{$this->geocodingTableName} ({$this->geocodingNameColumn},{$this->geocodingLatColumn},{$this->geocodingLonColumn}) VALUES ('{$object->name}',{$object->lat},{$object->lon});"; //echo $query; $this->doQuery($query); } } }