html - How to implement nested location and store it in a database with PHP/MySQL?

Question

Closed. This question needs to be more focused. It is not currently accepting answers. question from:https://stackoverflow.com/questions/65854739/how-to-implement-nested-location-and-store-it-in-a-database-with-php-mysql

Answer 1

For each location you add is_a_group and parent data. Each location must have unique ID(like every other data in the database).

If you want to create location(or something else) that is collection of other things(like Asia on provided image), set is_a_group to 1. When you load data with is_a_group = 1, show all data with parent equal to ID of data where is_a_group is set to 1.