Home > Database > Mysql Tutorial > 6 recommended articles about counties and districts

6 recommended articles about counties and districts

黄舟
Release: 2017-06-14 09:09:36
Original
1259 people have browsed it

Due to the needs of the work project, I needed a city and county data table. I searched online and found that it was basically incomplete, so I spent 3 days sorting it out. ​ The province, city and county data source is Google Maps. (Including 34 provinces, 371 cities, 2824 counties and districts) The code is as follows: /**********Create provincial table*************/ CREATE TABLE T_Province (ProID INT IDENTITY(1,1) PRIMARY KEY, --Province primary key ProName NVARCHAR(50) NOT NULL, --Province name ProSort INT, --Province sort ProRemark NVARCHAR(50) --Description) Go code is as follows: /********Create city-level table*******/ CREATE TABLE T_City (CityID INT IDENTITY(1,1) Primary KEY, --city primary key C

1. The most complete and latest data table for provinces, cities and counties across the country (data source Google)

Introduction: Due to the needs of the work project, I need a city and county data table. I searched online and found that it was basically incomplete, so I spent 3 days sorting it out.

2. No linkage drop-down selection for provinces, cities, counties, districts and streets across the country

Introduction: Provide various official and user-released code examples and code references. Everyone is welcome to exchange and learn.

3. How to display provincial and city address information in ecshop order confirmation_PHP

Introduction: The last step in ecshop’s shopping process The order confirmation information, which contains the user's order delivery address information, does not include the province, city, county and district information selected by the user

##4. thinkPHP and ajax implemented province, city, county and district information. Request method for three-level linkage addresses

Introduction: Request method for three-level linkage addresses of provinces, cities, counties and districts implemented by thinkPHP and ajax

5. How to display provincial and city address information in ecshop order confirmation_php skills

Introduction: The last order confirmation information in ecshop’s shopping process, among which Regarding the delivery address information of the user's order, the province, city, county and district information selected by the user is not included

6. Native JavaScript implements the example code of the dynamic province, city and county three-level linkage drop-down box menu. _javascript skills

#Introduction: Just like when choosing an address for shopping, dynamically load the city list through the selected province, and dynamically load the county list through the selected city, so that you can achieve For the three-level linkage of provinces, cities and counties, native JavaScript is used to implement this function. Friends who need it can refer to it

[Related Q&A recommendations]:

javascript - How to make Taobao’s js province, city, county and district linkage menu?

The above is the detailed content of 6 recommended articles about counties and districts. For more information, please follow other related articles on the PHP Chinese website!

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template