$sth->bindParam('is_satellite_provider', $values['is_satellite_provider'], \PDO::PARAM_INT); $sth->execute(); }); Importer::csvRead($files['GeoLite2-Country-Locations-en.csv'], function ($values) use($dbh) { $sth = $dbh->prepare(' INSERT INTO country_locations ( geoname_id, locale_code, continent_code, continent_name, country_iso_code, country_name ) VALUES ( :geoname_id, :locale_code, :continent_code, :continent_name, :country_iso_code, :country_name ) '); $sth->bindParam('geoname_id', $values['geoname_id'], \PDO::PARAM_INT); $sth->bindParam('locale_code', $values['locale_code'], \PDO::PARAM_STR); $sth->bindParam('continent_code', $values['continent_code'], \PDO::PARAM_STR); $sth->bindParam('continent_name', $values['continent_name'], \PDO::PARAM_STR); $sth->bindParam('country_iso_code', $values['country_iso_code'], \PDO::PARAM_STR); $sth->bindParam('country_name', $values['country_name'], \PDO::PARAM_STR); $sth->execute(); }); } catch (\Exception $e) { echo $e->getMessage() . "\n"; exit(1);