Code Samples

Monday, January 30, 2017

Windows Batch Script to create new MySQL database and import

Create a file named restore.bat with following contents & double to click to create new database & import data to selected database

@ECHO OFF
cd C:\xampp\mysql\bin
mysql.exe -uroot -hlocalhost -e "drop database if exists some_db_name";
mysql.exe -uroot -hlocalhost -e "create database some_db_name default character set utf8 default collate utf8_general_ci;";
echo DB Created
mysql.exe -uroot -hlocalhost some_db_name < "C:\tmp\back_up.sql"
echo DB Restored
pause
exit;

Windows Batch Script to backup local MySQL database

Create a file name "backup.bat" with following contents and double click to backup selected database to local file.

@ECHO OFF
cd C:\xampp\mysql\bin
mysqldump.exe -uroot -hlocalhost some_db_name > "C:\tmp\back_up.sql"
echo DB Backuped
mysql.exe -uroot -hlocalhost -e "drop database if exists some_db_name";
echo DB Removed
pause
exit;

Saturday, January 28, 2017

DateTime Picker · Bootstrap

You can download full example from here

<head>
    <title>Bootstrap Date Time Picker Example</title>
    <script type="text/javascript" src="jquery-2.1.1.min.js"></script>
    <script type="text/javascript" src="moment-with-locales.js"></script>
    <script type="text/javascript" src="bootstrap.min.js"></script>
    <script type="text/javascript" src="bootstrap-datetimepicker.js"></script>

    <link rel="stylesheet" href="bootstrap.min.css"/>
    <link rel="stylesheet" href="font-awesome.min.css"/>
    <link rel="stylesheet" href="bootstrap-datetimepicker.css"/>

    <script type="text/javascript">
        $(function () {
            var start = new Date();
            start.setMinutes(start.getMinutes() + 20);
            var start_value = start.getFullYear() + "-" + (start.getMonth() + 1) + "-" + start.getDate();
            start_value += " " + start.getHours() + ":" + start.getMinutes();

            start.setDate(start.getDate() + 1);

            $('#datetimepicker1').datetimepicker({
                defaultDate: start_value,
                format: 'DD-MM-YYYY hh:mm A',
                disabledDates: [
                    start
                ],
                daysOfWeekDisabled: [0, 6],
                sideBySide: false,
                showTodayButton: true,
                showClear: true,
                showClose: true,
                onSelect: function () {
                    var minDate = $(this).datepicker('getDate');
                    $('#datetimepicker2').datepicker( "option", "minDate", minDate);
                }
            });

            $('#datetimepicker2').datetimepicker({
                defaultDate: start_value,
                format: 'DD-MM-YYYY hh:mm A',
                disabledDates: [
                    start
                ],
                daysOfWeekDisabled: [0, 6],
                sideBySide: false,
                showTodayButton: true,
                showClear: true,
                showClose: true
            });

            $('#datetimepicker3').datetimepicker({
                format: 'DD-MM-YYYY hh:mm A'
            });
            $('#datetimepicker4').datetimepicker({
                useCurrent: false,
                format: 'DD-MM-YYYY hh:mm A'
            });
            $("#datetimepicker3").on("dp.change", function (e) {
                $('#datetimepicker4').data("DateTimePicker").minDate(e.date);
            });
            $("#datetimepicker4").on("dp.change", function (e) {
                $('#datetimepicker3').data("DateTimePicker").maxDate(e.date);
            });
        });
    </script>
</head>
<body>
<div class="container">
    <div class="row">
        <div class='col-sm-6'>
            <div class="form-group">
                <div class='input-group date' id='datetimepicker1'>
                    <input type='text' class="form-control" />
                    <span class="input-group-addon">
                        <span class="glyphicon glyphicon-calendar"></span>
                    </span>
                </div>
            </div>
        </div>
        <div class='col-sm-6'>
            <div class="form-group">
                <input id="datetimepicker2" type="text" class="form-control"/>
            </div>
        </div>
    </div>
    <div class="row">
        <div class='col-md-6'>
            <div class="form-group">
                <div class='input-group date' id='datetimepicker3'>
                    <input type='text' class="form-control" />
                <span class="input-group-addon">
                    <span class="glyphicon glyphicon-calendar"></span>
                </span>
                </div>
            </div>
        </div>
        <div class='col-md-6'>
            <div class="form-group">
                <div class='input-group date' id='datetimepicker4'>
                    <input type='text' class="form-control" />
                <span class="input-group-addon">
                    <span class="glyphicon glyphicon-calendar"></span>
                </span>
                </div>
            </div>
        </div>
    </div>
</div>
</body>

Tuesday, January 24, 2017

List all timeZones in SQL Format

CREATE TABLE IF NOT EXISTS time_zone_list 
(id int(11) NOT NULL AUTO_INCREMENT,name varchar(50) NOT NULL,display_value varchar(100) NOT NULL,PRIMARY KEY (id))
ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Abidjan', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Accra', 'Ghana Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Addis_Ababa', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Algiers', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Asmara', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Asmera', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bamako', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bangui', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Banjul', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bissau', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Blantyre', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Brazzaville', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Bujumbura', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Cairo', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Casablanca', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ceuta', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Conakry', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Dakar', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Dar_es_Salaam', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Djibouti', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Douala', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/El_Aaiun', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Freetown', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Gaborone', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Harare', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Johannesburg', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Juba', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kampala', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Khartoum', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kigali', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Kinshasa', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lagos', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Libreville', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lome', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Luanda', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lubumbashi', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Lusaka', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Malabo', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Maputo', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Maseru', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Mbabane', 'South Africa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Mogadishu', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Monrovia', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Nairobi', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ndjamena', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Niamey', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Nouakchott', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Ouagadougou', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Porto-Novo', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Sao_Tome', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Timbuktu', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Tripoli', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Tunis', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Africa/Windhoek', 'Western African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Adak', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Anchorage', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Anguilla', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Antigua', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Araguaina', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Buenos_Aires', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Catamarca', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/ComodRivadavia', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Cordoba', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Jujuy', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/La_Rioja', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Mendoza', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Rio_Gallegos', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Salta', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/San_Juan', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/San_Luis', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Tucuman', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Argentina/Ushuaia', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Aruba', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Asuncion', 'Paraguay Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Atikokan', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Atka', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bahia', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bahia_Banderas', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Barbados', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Belem', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Belize', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Blanc-Sablon', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Boa_Vista', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Bogota', 'Colombia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Boise', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Buenos_Aires', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cambridge_Bay', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Campo_Grande', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cancun', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Caracas', 'Venezuela Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Catamarca', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cayenne', 'French Guiana Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cayman', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Chicago', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Chihuahua', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Coral_Harbour', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cordoba', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Costa_Rica', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Creston', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Cuiaba', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Curacao', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Danmarkshavn', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dawson', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dawson_Creek', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Denver', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Detroit', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Dominica', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Edmonton', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Eirunepe', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/El_Salvador', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Ensenada', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fort_Nelson', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fort_Wayne', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Fortaleza', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Glace_Bay', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Godthab', 'Western Greenland Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Goose_Bay', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Grand_Turk', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Grenada', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guadeloupe', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guatemala', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guayaquil', 'Ecuador Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Guyana', 'Guyana Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Halifax', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Havana', 'Cuba Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Hermosillo', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Indianapolis', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Knox', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Marengo', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Petersburg', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Tell_City', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Vevay', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Vincennes', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indiana/Winamac', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Indianapolis', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Inuvik', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Iqaluit', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Jamaica', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Jujuy', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Juneau', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kentucky/Louisville', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kentucky/Monticello', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Knox_IN', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Kralendijk', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/La_Paz', 'Bolivia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Lima', 'Peru Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Los_Angeles', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Louisville', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Lower_Princes', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Maceio', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Managua', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Manaus', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Marigot', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Martinique', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Matamoros', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mazatlan', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mendoza', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Menominee', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Merida', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Metlakatla', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Mexico_City', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Miquelon', 'Pierre & Miquelon Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Moncton', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Monterrey', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montevideo', 'Uruguay Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montreal', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Montserrat', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nassau', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/New_York', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nipigon', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Nome', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Noronha', 'Fernando de Noronha Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/Beulah', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/Center', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/North_Dakota/New_Salem', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Ojinaga', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Panama', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Pangnirtung', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Paramaribo', 'Suriname Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Phoenix', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Port-au-Prince', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Port_of_Spain', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Porto_Acre', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Porto_Velho', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Puerto_Rico', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rainy_River', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rankin_Inlet', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Recife', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Regina', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Resolute', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rio_Branco', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Rosario', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santa_Isabel', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santarem', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santiago', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Santo_Domingo', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Sao_Paulo', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Scoresbysund', 'Eastern Greenland Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Shiprock', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Sitka', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Barthelemy', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Johns', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Kitts', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Lucia', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Thomas', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/St_Vincent', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Swift_Current', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tegucigalpa', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Thule', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Thunder_Bay', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tijuana', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Toronto', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Tortola', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Vancouver', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Virgin', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Whitehorse', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Winnipeg', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Yakutat', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('America/Yellowknife', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Casey', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Davis', 'Davis Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/DumontDUrville', 'Dumont-d''Urville Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Macquarie', 'Macquarie Island Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Mawson', 'Mawson Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/McMurdo', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Palmer', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Rothera', 'Rothera Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/South_Pole', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Syowa', 'Syowa Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Troll', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Antarctica/Vostok', 'Vostok Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Arctic/Longyearbyen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aden', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Almaty', 'Alma-Ata Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Amman', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Anadyr', 'Anadyr Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aqtau', 'Aqtau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Aqtobe', 'Aqtobe Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ashgabat', 'Turkmenistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ashkhabad', 'Turkmenistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Baghdad', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bahrain', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Baku', 'Azerbaijan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bangkok', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Beirut', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Bishkek', 'Kirgizstan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Brunei', 'Brunei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Calcutta', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chita', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Choibalsan', 'Choibalsan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chongqing', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Chungking', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Colombo', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dacca', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Damascus', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dhaka', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dili', 'Timor-Leste Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dubai', 'Gulf Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Dushanbe', 'Tajikistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Gaza', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Harbin', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hebron', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ho_Chi_Minh', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hong_Kong', 'Hong Kong Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Hovd', 'Hovd Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Irkutsk', 'Irkutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Istanbul', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jakarta', 'West Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jayapura', 'East Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Jerusalem', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kabul', 'Afghanistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kamchatka', 'Petropavlovsk-Kamchatski Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Karachi', 'Pakistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kashgar', 'Xinjiang Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kathmandu', 'Nepal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Katmandu', 'Nepal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Khandyga', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kolkata', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Krasnoyarsk', 'Krasnoyarsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuala_Lumpur', 'Malaysia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuching', 'Malaysia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Kuwait', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Macao', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Macau', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Magadan', 'Magadan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Makassar', 'Central Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Manila', 'Philippines Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Muscat', 'Gulf Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Nicosia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Novokuznetsk', 'Krasnoyarsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Novosibirsk', 'Novosibirsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Omsk', 'Omsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Oral', 'Oral Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Phnom_Penh', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Pontianak', 'West Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Pyongyang', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Qatar', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Qyzylorda', 'Qyzylorda Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Rangoon', 'Myanmar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Riyadh', 'Arabia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Saigon', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Sakhalin', 'Sakhalin Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Samarkand', 'Uzbekistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Seoul', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Shanghai', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Singapore', 'Singapore Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Srednekolymsk', 'Srednekolymsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Taipei', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tashkent', 'Uzbekistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tbilisi', 'Georgia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tehran', 'Iran Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tel_Aviv', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Thimbu', 'Bhutan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Thimphu', 'Bhutan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Tokyo', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ujung_Pandang', 'Central Indonesia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ulaanbaatar', 'Ulaanbaatar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ulan_Bator', 'Ulaanbaatar Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Urumqi', 'Xinjiang Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Ust-Nera', 'Ust-Nera Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Vientiane', 'Indochina Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Vladivostok', 'Vladivostok Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yakutsk', 'Yakutsk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yekaterinburg', 'Yekaterinburg Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Asia/Yerevan', 'Armenia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Azores', 'Azores Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Bermuda', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Canary', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Cape_Verde', 'Cape Verde Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Faeroe', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Faroe', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Jan_Mayen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Madeira', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Reykjavik', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/South_Georgia', 'South Georgia Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/St_Helena', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Atlantic/Stanley', 'Falkland Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/ACT', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Adelaide', 'Australian Central Standard Time (South Australia)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Brisbane', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Broken_Hill', 'Australian Central Standard Time (South Australia/New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Canberra', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Currie', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Darwin', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Eucla', 'Australian Central Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Hobart', 'Australian Eastern Standard Time (Tasmania)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/LHI', 'Lord Howe Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Lindeman', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Lord_Howe', 'Lord Howe Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Melbourne', 'Australian Eastern Standard Time (Victoria)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/NSW', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/North', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Perth', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Queensland', 'Australian Eastern Standard Time (Queensland)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/South', 'Australian Central Standard Time (South Australia)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Sydney', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Tasmania', 'Australian Eastern Standard Time (Tasmania)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Victoria', 'Australian Eastern Standard Time (Victoria)');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/West', 'Australian Western Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Australia/Yancowinna', 'Australian Central Standard Time (South Australia/New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/Acre', 'Acre Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/DeNoronha', 'Fernando de Noronha Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/East', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Brazil/West', 'Amazon Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CET', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CST6CDT', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Atlantic', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Central', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/East-Saskatchewan', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Eastern', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Mountain', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Newfoundland', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Pacific', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Saskatchewan', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Canada/Yukon', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Chile/Continental', 'Chile Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Chile/EasterIsland', 'Easter Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Cuba', 'Cuba Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EET', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EST5EDT', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Egypt', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Eire', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+1', 'GMT-01:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+10', 'GMT-10:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+11', 'GMT-11:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+12', 'GMT-12:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+2', 'GMT-02:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+3', 'GMT-03:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+4', 'GMT-04:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+5', 'GMT-05:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+6', 'GMT-06:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+7', 'GMT-07:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+8', 'GMT-08:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT+9', 'GMT-09:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-1', 'GMT+01:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-10', 'GMT+10:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-11', 'GMT+11:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-12', 'GMT+12:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-13', 'GMT+13:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-14', 'GMT+14:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-2', 'GMT+02:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-3', 'GMT+03:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-4', 'GMT+04:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-5', 'GMT+05:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-6', 'GMT+06:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-7', 'GMT+07:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-8', 'GMT+08:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT-9', 'GMT+09:00');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/GMT0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Greenwich', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/UCT', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/UTC', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Universal', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Etc/Zulu', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Amsterdam', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Andorra', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Athens', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Belfast', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Belgrade', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Berlin', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Bratislava', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Brussels', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Bucharest', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Budapest', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Busingen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Chisinau', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Copenhagen', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Dublin', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Gibraltar', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Guernsey', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Helsinki', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Isle_of_Man', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Istanbul', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Jersey', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Kaliningrad', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Kiev', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Lisbon', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Ljubljana', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/London', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Luxembourg', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Madrid', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Malta', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Mariehamn', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Minsk', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Monaco', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Moscow', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Nicosia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Oslo', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Paris', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Podgorica', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Prague', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Riga', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Rome', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Samara', 'Samara Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/San_Marino', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Sarajevo', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Simferopol', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Skopje', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Sofia', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Stockholm', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tallinn', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tirane', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Tiraspol', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Uzhgorod', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vaduz', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vatican', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vienna', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Vilnius', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Volgograd', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Warsaw', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zagreb', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zaporozhye', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Europe/Zurich', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GB', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GB-Eire', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GMT', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('GMT0', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Greenwich', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Hongkong', 'Hong Kong Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Iceland', 'Greenwich Mean Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Antananarivo', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Chagos', 'Indian Ocean Territory Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Christmas', 'Christmas Island Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Cocos', 'Cocos Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Comoro', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Kerguelen', 'French Southern & Antarctic Lands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mahe', 'Seychelles Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Maldives', 'Maldives Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mauritius', 'Mauritius Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Mayotte', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Indian/Reunion', 'Reunion Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Iran', 'Iran Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Israel', 'Israel Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Jamaica', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Japan', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Kwajalein', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Libya', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MET', 'Middle Europe Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MST7MDT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/BajaNorte', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/BajaSur', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Mexico/General', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NZ', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NZ-CHAT', 'Chatham Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Navajo', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PRC', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PST8PDT', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Apia', 'West Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Auckland', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Bougainville', 'Bougainville Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Chatham', 'Chatham Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Chuuk', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Easter', 'Easter Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Efate', 'Vanuatu Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Enderbury', 'Phoenix Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Fakaofo', 'Tokelau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Fiji', 'Fiji Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Funafuti', 'Tuvalu Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Galapagos', 'Galapagos Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Gambier', 'Gambier Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Guadalcanal', 'Solomon Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Guam', 'Chamorro Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Honolulu', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Johnston', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kiritimati', 'Line Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kosrae', 'Kosrae Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Kwajalein', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Majuro', 'Marshall Islands Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Marquesas', 'Marquesas Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Midway', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Nauru', 'Nauru Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Niue', 'Niue Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Norfolk', 'Norfolk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Noumea', 'New Caledonia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pago_Pago', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Palau', 'Palau Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pitcairn', 'Pitcairn Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Pohnpei', 'Pohnpei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Ponape', 'Pohnpei Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Port_Moresby', 'Papua New Guinea Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Rarotonga', 'Cook Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Saipan', 'Chamorro Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Samoa', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tahiti', 'Tahiti Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tarawa', 'Gilbert Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Tongatapu', 'Tonga Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Truk', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Wake', 'Wake Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Wallis', 'Wallis & Futuna Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Pacific/Yap', 'Chuuk Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Poland', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Portugal', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ROK', 'Korea Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Singapore', 'Singapore Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/AST4', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/AST4ADT', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/CST6', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/CST6CDT', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/EST5', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/EST5EDT', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/HST10', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/MST7', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/MST7MDT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/PST8', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/PST8PDT', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/YST9', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SystemV/YST9YDT', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Turkey', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('UCT', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Alaska', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Aleutian', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Arizona', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Central', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/East-Indiana', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Eastern', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Hawaii', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Indiana-Starke', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Michigan', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Mountain', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Pacific', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Pacific-New', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('US/Samoa', 'Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('UTC', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Universal', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('W-SU', 'Moscow Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('WET', 'Western European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('Zulu', 'Coordinated Universal Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EST', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('HST', 'Hawaii Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MST', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ACT', 'Australian Central Standard Time (Northern Territory)');
INSERT INTO time_zone_list(name, display_value) VALUES('AET', 'Australian Eastern Standard Time (New South Wales)');
INSERT INTO time_zone_list(name, display_value) VALUES('AGT', 'Argentine Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ART', 'Eastern European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('AST', 'Alaska Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('BET', 'Brasilia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('BST', 'Bangladesh Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CAT', 'Central African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CNT', 'Newfoundland Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CST', 'Central Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('CTT', 'China Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('EAT', 'Eastern African Time');
INSERT INTO time_zone_list(name, display_value) VALUES('ECT', 'Central European Time');
INSERT INTO time_zone_list(name, display_value) VALUES('IET', 'Eastern Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('IST', 'India Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('JST', 'Japan Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('MIT', 'West Samoa Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NET', 'Armenia Time');
INSERT INTO time_zone_list(name, display_value) VALUES('NST', 'New Zealand Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PLT', 'Pakistan Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PNT', 'Mountain Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PRT', 'Atlantic Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('PST', 'Pacific Standard Time');
INSERT INTO time_zone_list(name, display_value) VALUES('SST', 'Solomon Is. Time');
INSERT INTO time_zone_list(name, display_value) VALUES('VST', 'Indochina Time');

Thursday, January 19, 2017

php - Send ics calendar invite using Swift Mailer

Download full source code from here

This code works fine with Gmail, Yahoo, Office 365, Outlook & Others. Some screenshots of different mail system are below.

Sample Request

BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20170118T134600Z
DTEND:20170118T141600Z
DTSTAMP:20170118T132600Z
UID:PKMf3c65f6ac8d3c3e1a99f3464acb6d11723400878
ORGANIZER;CN=email@organizer.pkm:mailto:email@organizer.pkm
ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;
    CN=pritomkucse@yahoo.com;X-NUM-GUESTS=0:mailto:pritomkucse@yahoo.com
ATTENDEE;CUTYPE=INDIVIDUAL;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;
    CN=pritomkucse@gmail.com;X-NUM-GUESTS=0:mailto:pritomkucse@gmail.com
CLASS:PRIVATE
DESCRIPTION:Some Calendar Description
LOCATION:Some Calendar Location
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Some Calendar Summary
TRANSP:OPAQUE
PRIORITY:5
BEGIN:VALARM
DESCRIPTION:REMINDER
TRIGGER:-P0DT0H10M0S
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR

Sample response

Google Email Inbox View:

Google Calendar Box View:

Yahoo Email Inbox View:

Yahoo Calendar Box View:

Office 365 Email Inbox View:

Customized Email Inbox View

Outlook 2013 Email Inbox View

Calendar Reminder Notification Example

Saturday, January 14, 2017

Implement Redirect Interceptor For All Http Call - Angular JS

Download resources from here

<script type="text/javascript" src="angular.js"></script>
<script type="text/javascript" src="angular-resource.js"></script>

<div data-ng-app="myApp" data-ng-controller="MyCtrl">[[dataFromAngularJS]]</div>

<script type="text/javascript">
    var app = angular.module('myApp', ['ngResource'], function ($interpolateProvider) {
        $interpolateProvider.startSymbol('[[');
        $interpolateProvider.endSymbol(']]');
    });
    app.config(['$httpProvider', '$controllerProvider', function ($httpProvider, $controllerProvider, $window) {
        $httpProvider.interceptors.push('redirectInterceptor');
    }])
    .run(function ($rootScope, $window) {
        console.log("MY_APP START RUNNING");
        $rootScope.baseUrl = "/";
    })
    .factory('redirectInterceptor', function ($q, $location, $window, $rootScope) {
        return {
            response: function (response) {
                console.log("GOT DATA VIA AJAX CALL");
                console.log(response);
                return response;
            },
            responseError: function(response) {
                console.log("GOT ERROR VIA AJAX CALL");
                console.log(response);
                response.data = "ERROR";
                return $q.reject(response);
            }
        }
    });

    app.controller('MyCtrl', ['$scope', '$http', function ($scope, $http) {
        $scope.dataFromAngularJS = "Data From Angular JS";

        $http.get('data.html').
        success(function(response, status, headers, config) {
            $scope.dataFromAngularJS = "Success=" + response;
        }).
        error(function(response, status, headers, config) {
            $scope.dataFromAngularJS = "Error=" + response;
        });
    }]);
</script>

Abort / Cancel jQuery Ajax Request Example

<script type="text/javascript" src="jquery-min.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        var $xhr = $.ajax({
            url: "search.php",
            type: "POST",
            data: {id: 1, name: "Pritom Kumar"},
            beforeSend: function(xhr){
                xhr.setRequestHeader('X-Test-Header1', 'test-value1');
                xhr.setRequestHeader('X-Test-Header2', 'test-value2');
            },
            dataType: "json"
        }).done(function(data, textStatus, jqXHR) {

        }).fail(function(jqXHR, textStatus, errorThrown) {
            alert("Failed With Reason=" + textStatus);
        });
        setTimeout(function() {
            $xhr.abort();
        }, 100);
    });
</script>

Pages

Monday, January 30, 2017

Windows Batch Script to create new MySQL database and import

Create a file named restore.bat with following contents & double to click to create new database & import data to selected database

Windows Batch Script to backup local MySQL database

Create a file name "backup.bat" with following contents and double click to backup selected database to local file.

Saturday, January 28, 2017

DateTime Picker · Bootstrap

You can download full example from here

Tuesday, January 24, 2017

List all timeZones in SQL Format

Thursday, January 19, 2017

php - Send ics calendar invite using Swift Mailer

Download full source code from here

Sample Request

Sample response

Google Email Inbox View:

Google Calendar Box View:

Yahoo Email Inbox View:

Yahoo Calendar Box View:

Office 365 Email Inbox View:

Customized Email Inbox View

Outlook 2013 Email Inbox View

Calendar Reminder Notification Example

Saturday, January 14, 2017

Implement Redirect Interceptor For All Http Call - Angular JS

Download resources from here

Abort / Cancel jQuery Ajax Request Example