Php timezone_identifier兼容数据库？

Question

In my database I would like to insert PHP supported timezones information of the main cities in the world, but I can't seem to find anything near what I'm looking for.


Here's 2 examples of what I am looking for:

|--------------------------|
|        City table        |
|--------------------------|
| name     | timezone      |
|--------------------------|
| London   | Europe/London |
| Aberdeen | Europe/London |
|--------------------------|

Any idea where I can find these information?


Cheers,
Nicolas.

Answer 1

Do you want this list ? The name can be extracted from the part after the slash.