pixxet/laravel-geoip-world-cities

Laravel GeoIP World Cities provides MaxMind Free World Cities Database for laravel applications.

laravel-geoip-world-cities (Laravel 5)

![Software License][ico-license] , _(*1)

Laravel GeoIP World Cities is package that provides MaxMind Free World Cities Database support for laravel applications., _(*2)

Contents

• Introduction
• Before installing
• Installation
• Table structure
• Example
• Troubleshooting
• Changelog
• Contributing
• Credits
• License

Introduction

Includes city, region, country, latitude and longitude. This database doesn't contain any IP addresses. It's simply a listing of all the cities in the world., _(*3)

This package simply loads the data provided in worldcitiespop.txt.gz file by MaxMind into a database and provides a City model to query the table., _(*4)

Before installing

If you are looking for the Laravel 4 version, take a look Branch 1.0., _(*5)

Installation

Note: This package is a bit large, ~40MB, installing and seeding the data could take a while., _(*6)

Add pixxet/laravel-geoip-world-cities to composer.json:, _(*7)

"pixxet/laravel-geoip-world-cities": "2.*"

for the last stable version, or, _(*8)

"pixxet/laravel-geoip-world-cities": "dev-master"

for the latest version., _(*9)

Run composer update to pull down laravel-geoip-world-cities., _(*10)

Edit config/app.php and add the provider, _(*11)

    'providers' => [
        Pixxet\LaravelGeoIPWorldCities\LaravelGeoIPWorldCitiesServiceProvider::class,
    ]

Optionally add the alias., _(*12)

    'aliases' => [
        'Cities' => Pixxet\LaravelGeoIPWorldCities\Facade::class,
    ]

Configure MySQL and PDO, insert the following code in config/database.php:, _(*13)

    'mysql' => [
        'options'   => [PDO::MYSQL_ATTR_LOCAL_INFILE => true],
    ],

Publishing the configuration file, this is where you can change the default table name, _(*14)

php artisan vendor:publish

Publishing the migration and seeder files, _(*15)

php artisan cities:migration
php artisan cities:seeder

To make sure the data is seeded insert the following code in seeds/DatabaseSeeder.php, _(*16)

    // Seeding the cities
    $this->call(CitiesTableSeeder::class);
    $this->command->info('Seeded the cities table ...'); 

You may now run:, _(*17)

php artisan migrate --seed

After running this command the filled cities table will be available, _(*18)

Table structure

Example

The package provides a City model which can be used to query the data, _(*19)

    \Pixxet\LaravelGeoIPWorldCities\City::whereCity('Khartoum')->first();

Troubleshooting

If you are getting a ReflectionException when trying to seed, _(*20)

    [ReflectionException]                   
    Class CitiesTableSeeder does not exist 

run:, _(*21)

    composer dump-autoload

and try again., _(*22)

Change log

Please see CHANGELOG for more information on what has changed recently., _(*23)

Contributing

Please see CONTRIBUTING and CONDUCT for details., _(*24)

Credits

• MaxMind
• Khalid Pixxet
• MCMatters

License

MaxMind WorldCities License., _(*25)

The MIT License (MIT). Please see License File for more information., _(*26)