insert_statements.php

<?php

foreach($tzlist as $items) {
  foreach($items as $item) {
    echo "INSERT INTO timezones (timezone) VALUES ('" . $item . "');";
  }
}

timezone_select.php

<?php

static $regions = array(
    'Africa' => DateTimeZone::AFRICA,
    'America' => DateTimeZone::AMERICA,
    'Antarctica' => DateTimeZone::ANTARCTICA,
    'Aisa' => DateTimeZone::ASIA,
    'Atlantic' => DateTimeZone::ATLANTIC,
    'Europe' => DateTimeZone::EUROPE,
    'Indian' => DateTimeZone::INDIAN,
    'Pacific' => DateTimeZone::PACIFIC
);
foreach ($regions as $name => $mask) {
    $tzlist[] = DateTimeZone::listIdentifiers($mask);
}

echo '<select>';
echo '<option>Pick your timezone</option>';

$count = 0;
foreach($tzlist as $timezones) {
  foreach($timezones as $timezone) {
    echo '<option value="' . ++$count . '">' . $timezone . '</option>';
  }
}

echo '</select>';

timezones.sql

CREATE TABLE timezones (
  tid INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  timezone VARCHAR(30) NOT NULL
) ENGINE=InnoDB;

users_timezones.sql

CREATE TABLE users_timezones (
  uid INT(11) NOT NULL,
  tid INT(11) NOT NULL,
  FOREIGN KEY (uid) REFERENCES users(uid),
  FOREIGN KEY (tid) REFERENCES timezones(tid)
) ENGINE=InnoDB;

varchar.php

<?php

$len = strlen('America/Argentina/Rio_Gallegos');
echo $len;