网站数据里关于地区值的变更逻辑-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

网站数据里关于地区值的变更逻辑

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 23, 2016 pm 02:20 PM

不知道各位高手对这个有什么好的见解。

先说说我的逻辑：
1.我们网站有如下地区值，为了索引速度，所有的地区值都有自己的数值。
  1-中国
    1-北京
      1-朝阳区
      2-海淀区
      3-...
    2-上海
    3-...
    5-广东
      1-广州
      2-...
  2-韩国
  3-日本
  4-...

用户编辑信息的时候从国家，省份，市级选择3级地区值。

问题：中国的地区信息会有变更。这个时候对现有的数据进行更新很麻烦。
比如某个省的某3个市合并为一个新城市。或者删掉某个市。（增加比较简单）

有没有一个比较成熟的地区值管理方法？

回复讨论(解决方案)

你示例的数据是有限分类的
根据此类的特点，你可以这样组织数据
01 中国
0101 北京
010101 朝阳区
010102 海淀区
010103 ...
0102 上海
0103 ...
0105 广东
010501 广州
010502 ...
02 韩国
03 日本
规范一点的就是国别代码 + 区划代码（这些都有相应国的国家标准）

嗯这个我同意
但我的难题是对已有数据的更新。
比如上次发现山东省的几个市合并为一个市，什么滨海新区？忘了
但我们的很多数据都有地区值，比如会员信息，企业信息，产品信息，订单信息，位置信息等等。。

Statement

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

What is PDO in PHP?Apr 28, 2025 pm 04:51 PM

The article discusses PHP Data Objects (PDO), an extension for database access in PHP. It highlights PDO's role in enhancing security through prepared statements and its benefits over MySQLi, including database abstraction and better error handling.

What is Memcache and Memcached in PHP? Is it possible to share a single instance of a Memcache between several projects of PHP?Apr 28, 2025 pm 04:47 PM

Memcache and Memcached are PHP caching systems that speed up web apps by reducing database load. A single instance can be shared among projects with careful key management.

What are the steps to create a new database using MySQL and PHP?Apr 28, 2025 pm 04:44 PM

Article discusses steps to create and manage MySQL databases using PHP, focusing on connection, creation, common errors, and security measures.

Does JavaScript interact with PHP?Apr 28, 2025 pm 04:43 PM

The article discusses how JavaScript and PHP interact indirectly through HTTP requests due to their different environments. It covers methods for sending data from JavaScript to PHP and highlights security considerations like data validation and prot

How to execute a PHP script from the command line?Apr 28, 2025 pm 04:41 PM

The article discusses executing PHP scripts from the command line, including steps, common options, troubleshooting errors, and security considerations.

What is PEAR in PHP?Apr 28, 2025 pm 04:38 PM

PEAR is a PHP framework for reusable components, enhancing development with package management, coding standards, and community support.

What are the uses of PHP?Apr 28, 2025 pm 04:37 PM

PHP is a versatile scripting language used mainly for web development, creating dynamic pages, and can also be utilized for command-line scripting, desktop apps, and API development.

What was the old name of PHP?Apr 28, 2025 pm 04:36 PM

The article discusses PHP's evolution from "Personal Home Page Tools" in 1995 to "PHP: Hypertext Preprocessor" in 1998, reflecting its expanded use beyond personal websites.

See all articles