laravel-countries-cities's Introduction

World Countries & Cities

A Laravel package for using world's popular countries and cities.

Features

Add the countries/cities to the database using migration and seeders.
Use the countries/cities directly from the package without using the database.

Installation

Require the package with composer:

composer require alakkad/world-countries-cities

Add the ServiceProvider to the providers array in config/app.php

'Alakkad\WorldCountriesCities\WorldCountriesCitiesServiceProvider',

Copy the package config and migrations files to your local directories with:

php artisan vendor:publish

Usage

Migration

After running php artisan vendor:publish you can directly run:

php artisan migrate

Seeders

In order to seed the migrated tables, you need to edit database/seeds/DatabaseSeeder.php and add the following lines:

public function run()
{
    Model::unguard();

    $this->call('Alakkad\WorldCountriesCities\CitiesSeeder');
    $this->call('Alakkad\WorldCountriesCities\CountriesSeeder');
}

Then run:

php artisan db:seed

Be careful, the seeders files truncate the tables before inserting, to prevent any duplication.

Direct usage

To be implementated.

Credits

The data is based on MySQL's world database example.

laravel-countries-cities's People

Contributors

Stargazers

Watchers

laravel-countries-cities's Issues

Migrate error

i try to migrating city and country, but i got this error

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key (SQL: create
table cities (id int unsigned not null auto_increment primary key, name varchar(35) not null, country_code varchar(3) not null, district varchar(20) not
null, population int unsigned not null auto_increment primary key) default character set utf8 collate utf8_unicode_ci engine = InnoDB)

can you help me how to fix it?

Cannot Install alakkad/world-countries-cities

Package is not available in when do the composer require alakkad/world-countries-cities as per the instruction.

Is this still being worked on?

Is this still being developed? How comprehensive is the list of cities Mr. Al Akkad?

getting error on php artisan migrate

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it
must be defined as a key (SQL: create table cities (id int unsigned not null auto_increment primary key, name varchar
(35) not null, country_code varchar(3) not null, district varchar(20) not null, population int unsigned not null auto_
increment primary key) default character set utf8 collate utf8_unicode_ci engine = InnoDB)

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it
must be defined as a key

Recommend Projects