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
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.
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!