This time i am going to give you a very useful database that is countries, states and cities data of world in sql.
Every time when we plan to create a registration form then we stuck on one point that is how can we get list of all Countries, States and Cities of world.
So don’t worry i have solution, I have created mapped database of Countries, States and Cities So now you can easily get mapped .sql file of countries, states and cities from here and can add on your web page as per your requirement.
DOWNLOAD
|
SQL Files
|
Copy and paste below script to add city state country list in your website
<select name="country" class="countries" id="countryId"> <option value="">Select Country</option> </select> <select name="state" class="states" id="stateId"> <option value="">Select State</option> </select> <select name="city" class="cities" id="cityId"> <option value="">Select City</option> </select> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <script src="https://iamrohit.in/lab/js/location.js"></script>
Note: The support of above script has been closed due to heavy load, Please download full source code and configure it locally in your project..
*This free database dose not guarantee for the complete list of world countries, states and cities.
*You can manually change the spelling mistakes, or add edit any records, which are not correct.
10+ FREE PHP MySql City State Country Dropdown
Following are the list of popular top rated hand picked PHP MySql City State Country Dropdown.
- php_ajax_country_state_city_dropdown:- php and ajax based dropdown list of country, state and city
- Dynamic-Dropdown-:- A Dynamic Dropdown of Country, State and City using Ajax, jQuery and PHP. See Wiki for more info and Demo
- Dependent-Dropdown-in-PHP:- Dependent-Dropdown-in-PHP with Database of Country,State,Cities in Mysql For Beginners
- angular-country-state-city-dropdown-directive:- In this project i create directive for Country, State and City Dropdown. If you need to integrate them in your form, …
- Dropdown-demo:- Country State City demo
- country-state-city-dropdown:- Demo of 3 dropdowns of country, state and city dependent on each other
- CountryStateCity:- Implementation of Cascading Dropdown list of Countries, States and Cities using Nonfactor Datalist.
- country-state-city-Dropdown-Django:- # A simple Django based country state city Dropdown list which displays data on the same page without getting page re…
- Country-State-City:- Create responsive Country-State-City dropdown using PHP
- country-state-city-drop-down:- Country State City drop down using JavaScript and jQuery