jQuery Ajax Based Country, State and City List

In this tutorial, you can populate dynamic list of state and city with the help of jQuery and ajax. By default country drop down is displayed.

When you will select country from the list, State drop down will be appeared with the list of states for the current selected country.

When you will select state from the list, City drop down will be appeared with the list of cities for the current selected state.

Demo Code

Step 1 – Create Database

Create new database tgl_db.

Step 2 – Import Tables

Import attached tgl_country.sql into the database tgl_db.

tgl_country.sql

CREATE TABLE IF NOT EXISTS `tgl_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tgl_country`
--

INSERT INTO `tgl_country` (`id`, `country_name`) VALUES
(1, 'India'),
(2, 'USA'),
(3, 'Australia');

Import attached tgl_state.sql into the database tgl_db.

tgl_state.sql

CREATE TABLE IF NOT EXISTS `tgl_state` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state_name` varchar(255) NOT NULL,
  `country_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

--
-- Dumping data for table `tgl_state`
--

INSERT INTO `tgl_state` (`id`, `state_name`, `country_id`) VALUES
(1, 'Andra Pradesh', 1),
(2, 'Arunachal Pradesh', 1),
(3, 'Andaman and Nicobar Islands', 1),
(4, 'Assam', 1),
(5, 'Bihar', 1),
(6, 'Chandigarh', 1),
(7, 'Chhattisgarh', 1),
(8, 'Dadar and Nagar Haveli', 1),
(9, 'Daman and Diu', 1),
(10, 'Delhi', 1),
(11, 'Goa', 1),
(12, 'Gujarat', 1),
(13, 'Haryana', 1),
(14, 'Himachal Pradesh', 1),
(15, 'Jammu and Kashmir', 1),
(16, 'Jharkhand', 1),
(17, 'Karnataka', 1),
(18, 'Kerala', 1),
(19, 'Lakshadeep', 1),
(20, 'Madya Pradesh', 1),
(21, 'Maharashtra', 1),
(22, 'Manipur', 1),
(23, 'Meghalaya', 1),
(24, 'Mizoram', 1),
(25, 'Nagaland', 1),
(26, 'Orissa', 1),
(27, 'Pondicherry', 1),
(28, 'Punjab', 1),
(29, 'Rajasthan', 1),
(30, 'Sikkim', 1),
(31, 'Tamil Nadu', 1),
(32, 'Tripura', 1),
(33, 'Uttaranchal', 1),
(34, 'Uttar Pradesh', 1),
(35, 'West Bengal', 1),
(36, 'Alaska', 2),
(37, 'California', 2),
(38, 'New York', 2),
(39, 'Florida', 2),
(40, 'Texas', 2),
(41, 'Arizona', 2),
(42, 'Ohio', 2),
(43, 'Mississippi', 2),
(44, 'Victoria', 3),
(45, 'Western Australia', 3),
(46, 'Queensland', 3),
(47, 'South Australia', 3),
(48, 'Tasmania', 3);

Import attached tgl_city.sql into the database tgl_db.

tgl_city.sql

CREATE TABLE IF NOT EXISTS `tgl_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city_name` varchar(255) NOT NULL,
  `state_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1463 ;

--
-- Dumping data for table `tgl_city`
--

INSERT INTO `tgl_city` (`id`, `city_name`, `state_id`) VALUES
(1, 'Adilabad', 1),
(2, 'Adoni', 1),
(3, 'Amadalavalasa', 1),
(4, 'Amalapuram', 1),
(5, 'Anakapalle', 1),
(6, 'Anantapur', 1),
(7, 'Badepalle', 1),
(8, 'Banganapalle', 1),
(9, 'Bapatla', 1),
(10, 'Bellampalle', 1),
(11, 'Bethamcherla', 1),
(12, 'Bhadrachalam', 1),
(13, 'Bhainsa', 1),
(14, 'Bheemunipatnam', 1),
(15, 'Bhimavaram', 1),
(16, 'Bhongir', 1),
(17, 'Bobbili', 1),
(18, 'Bodhan', 1),
(19, 'Chilakaluripet', 1),
(20, 'Chirala', 1),
(21, 'Chittoor', 1),
(22, 'Cuddapah', 1),
(23, 'Devarakonda', 1),
(24, 'Dharmavaram', 1),
(25, 'Eluru', 1),
(26, 'Farooqnagar', 1),
(27, 'Gadwal', 1),
(28, 'Gooty', 1),
(29, 'Gudivada', 1),
(30, 'Gudur', 1),
(31, 'Guntakal', 1),
(32, 'Guntur', 1),
(33, 'Hanuman Junction', 1),
(34, 'Hindupur', 1),
(35, 'Hyderabad', 1),
(36, 'Ichchapuram', 1),
(37, 'Jaggaiahpet', 1),
(38, 'Jagtial', 1),
(39, 'Jammalamadugu', 1),
(40, 'Jangaon', 1),
(41, 'Kadapa', 1),
(42, 'Kadiri', 1),
(43, 'Kagaznagar', 1),
(44, 'Kakinada', 1),
(45, 'Kalyandurg', 1),
(46, 'Kamareddy', 1),
(47, 'Kandukur', 1),
(48, 'Karimnagar', 1),
(49, 'Kavali', 1),
(50, 'Khammam', 1),
(51, 'Koratla', 1),
(52, 'Kothagudem', 1),
(53, 'Kothapeta', 1),
(54, 'Kovvur', 1),
(55, 'Kurnool', 1),
(56, 'Kyathampalle', 1),
(57, 'Macherla', 1),
(58, 'Machilipatnam', 1),
(59, 'Madanapalle', 1),
(60, 'Mahbubnagar', 1),
(61, 'Mancherial', 1),
(62, 'Mandamarri', 1),
(63, 'Mandapeta', 1),
(64, 'Manuguru', 1),
(65, 'Markapur', 1),
(66, 'Medak', 1),
(67, 'Miryalaguda', 1),
(68, 'Mogalthur', 1),
(69, 'Nagari', 1),
(70, 'Nagarkurnool', 1),
(71, 'Nandyal', 1),
(72, 'Narasapur', 1),
(73, 'Narasaraopet', 1),
(74, 'Narayanpet', 1),
(75, 'Narsipatnam', 1),
(76, 'Nellore', 1),
(77, 'Nidadavole', 1),
(78, 'Nirmal', 1),
(79, 'Nizamabad', 1),
(80, 'Nuzvid', 1),
(81, 'Ongole', 1),
(82, 'Palacole', 1),
(83, 'Palasa Kasibugga', 1),
(84, 'Palwancha', 1),
(85, 'Parvathipuram', 1),
(86, 'Pedana', 1),
(87, 'Peddapuram', 1),
(88, 'Pithapuram', 1),
(89, 'Pondur', 1),
(90, 'Ponnur', 1),
(91, 'Proddatur', 1),
(92, 'Punganur', 1),
(93, 'Puttur', 1),
(94, 'Rajahmundry', 1),
(95, 'Rajam', 1),
(96, 'Ramachandrapuram', 1),
(97, 'Ramagundam', 1),
(98, 'Rayachoti', 1),
(99, 'Rayadurg', 1),
(100, 'Renigunta', 1),
(101, 'Repalle', 1),
(102, 'Sadasivpet', 1),
(103, 'Salur', 1),
(104, 'Samalkot', 1),
(105, 'Sangareddy', 1),
(106, 'Sattenapalle', 1),
(107, 'Siddipet', 1),
(108, 'Singapur', 1),
(109, 'Sircilla', 1),
(110, 'Srikakulam', 1),
(111, 'Srikalahasti', 1),
(112, 'Suryapet', 1),
(113, 'Tadepalligudem', 1),
(114, 'Tadpatri', 1),
(115, 'Tandur', 1),
(116, 'Tanuku', 1),
(117, 'Tenali', 1),
(118, 'Tirupati', 1),
(119, 'Tuni', 1),
(120, 'Uravakonda', 1),
(121, 'Venkatagiri', 1),
(122, 'Vicarabad', 1),
(123, 'Vijayawada', 1),
(124, 'Vinukonda', 1),
(125, 'Visakhapatnam', 1),
(126, 'Vizianagaram', 1),
(127, 'Wanaparthy', 1),
(128, 'Warangal', 1),
(129, 'Yellandu', 1),
(130, 'Yemmiganur', 1),
(131, 'Yerraguntla', 1),
(132, 'Zahirabad', 1),
(133, 'Abhayapuri', 4),
(134, 'Amguri', 4),
(135, 'Anandnagaar', 4),
(136, 'Barpeta', 4),
(137, 'Barpeta Road', 4),
(138, 'Bilasipara', 4),
(139, 'Bongaigaon', 4),
(140, 'Dhekiajuli', 4),
(141, 'Dhubri', 4),
(142, 'Dibrugarh', 4),
(143, 'Digboi', 4),
(144, 'Diphu', 4),
(145, 'Dispur', 4),
(146, 'Gauripur', 4),
(147, 'Goalpara', 4),
(148, 'Golaghat', 4),
(149, 'Guwahati', 4),
(150, 'Haflong', 4),
(151, 'Hailakandi', 4),
(152, 'Hojai', 4),
(153, 'Jorhat', 4),
(154, 'Karimganj', 4),
(155, 'Kokrajhar', 4),
(156, 'Lanka', 4),
(157, 'Lumding', 4),
(158, 'Mangaldoi', 4),
(159, 'Mankachar', 4),
(160, 'Margherita', 4),
(161, 'Mariani', 4),
(162, 'Marigaon', 4),
(163, 'Nagaon', 4),
(164, 'Nalbari', 4),
(165, 'North Lakhimpur', 4),
(166, 'Rangia', 4),
(167, 'Sibsagar', 4),
(168, 'Silapathar', 4),
(169, 'Silchar', 4),
(170, 'Tezpur', 4),
(171, 'Tinsukia', 4),
(172, 'Along', 2),
(173, 'Bomdila', 2),
(174, 'Itanagar', 2),
(175, 'Naharlagun', 2),
(176, 'Pasighat', 2),
(177, 'Ahmedabad', 12),
(178, 'Amreli', 12),
(179, 'Anand', 12),
(180, 'Ankleshwar', 12),
(181, 'Bharuch', 12),
(182, 'Bhavnagar', 12),
(183, 'Bhuj', 12),
(184, 'Cambay', 12),
(185, 'Dahod', 12),
(186, 'Deesa', 12),
(187, 'Dholka', 12),
(188, 'Gandhinagar', 12),
(189, 'Godhra', 12),
(190, 'Himatnagar', 12),
(191, 'Idar', 12),
(192, 'Jamnagar', 12),
(193, 'Junagadh', 12),
(194, 'Kadi', 12),
(195, 'Kalavad', 12),
(196, 'Kalol', 12),
(197, 'Kapadvanj', 12),
(198, 'Karjan', 12),
(199, 'Keshod', 12),
(200, 'Khambhalia', 12),
(201, 'Khambhat', 12),
(202, 'Kheda', 12),
(203, 'Khedbrahma', 12),
(204, 'Kheralu', 12),
(205, 'Kodinar', 12),
(206, 'Lathi', 12),
(207, 'Limbdi', 12),
(208, 'Lunawada', 12),
(209, 'Mahesana', 12),
(210, 'Mahuva', 12),
(211, 'Manavadar', 12),
(212, 'Mandvi', 12),
(213, 'Mangrol', 12),
(214, 'Mansa', 12),
(215, 'Mehmedabad', 12),
(216, 'Modasa', 12),
(217, 'Morvi', 12),
(218, 'Nadiad', 12),
(219, 'Navsari', 12),
(220, 'Padra', 12),
(221, 'Palanpur', 12),
(222, 'Palitana', 12),
(223, 'Pardi', 12),
(224, 'Patan', 12),
(225, 'Petlad', 12),
(226, 'Porbandar', 12),
(227, 'Radhanpur', 12),
(228, 'Rajkot', 12),
(229, 'Rajpipla', 12),
(230, 'Rajula', 12),
(231, 'Ranavav', 12),
(232, 'Rapar', 12),
(233, 'Salaya', 12),
(234, 'Sanand', 12),
(235, 'Savarkundla', 12),
(236, 'Sidhpur', 12),
(237, 'Sihor', 12),
(238, 'Songadh', 12),
(239, 'Surat', 12),
(240, 'Talaja', 12),
(241, 'Thangadh', 12),
(242, 'Tharad', 12),
(243, 'Umbergaon', 12),
(244, 'Umreth', 12),
(245, 'Una', 12),
(246, 'Unjha', 12),
(247, 'Upleta', 12),
(248, 'Vadnagar', 12),
(249, 'Vadodara', 12),
(250, 'Valsad', 12),
(251, 'Vapi', 12),
(252, 'Vapi', 12),
(253, 'Veraval', 12),
(254, 'Vijapur', 12),
(255, 'Viramgam', 12),
(256, 'Visnagar', 12),
(257, 'Vyara', 12),
(258, 'Wadhwan', 12),
(259, 'Wankaner', 12),
(260, 'Amarpur', 5),
(261, 'Araria', 5),
(262, 'Areraj', 5),
(263, 'Arrah', 5),
(264, 'Asarganj', 5),
(265, 'Aurangabad', 5),
(266, 'Bagaha', 5),
(267, 'Bahadurganj', 5),
(268, 'Bairgania', 5),
(269, 'Bakhtiarpur', 5),
(270, 'Banka', 5),
(271, 'Banmankhi Bazar', 5),
(272, 'Barahiya', 5),
(273, 'Barauli', 5),
(274, 'Barbigha', 5),
(275, 'Barh', 5),
(276, 'Begusarai', 5),
(277, 'Behea', 5),
(278, 'Bettiah', 5),
(279, 'Bhabua', 5),
(280, 'Bhagalpur', 5),
(281, 'Bihar Sharif', 5),
(282, 'Bikramganj', 5),
(283, 'Bodh Gaya', 5),
(284, 'Buxar', 5),
(285, 'Chandan Bara', 5),
(286, 'Chanpatia', 5),
(287, 'Chhapra', 5),
(288, 'Colgong', 5),
(289, 'Dalsinghsarai', 5),
(290, 'Darbhanga', 5),
(291, 'Daudnagar', 5),
(292, 'Dehri-on-Sone', 5),
(293, 'Dhaka', 5),
(294, 'Dighwara', 5),
(295, 'Dumraon', 5),
(296, 'Fatwah', 5),
(297, 'Forbesganj', 5),
(298, 'Gaya', 5),
(299, 'Gogri Jamalpur', 5),
(300, 'Gopalganj', 5),
(301, 'Hajipur', 5),
(302, 'Hilsa', 5),
(303, 'Hisua', 5),
(304, 'Islampur', 5),
(305, 'Jagdispur', 5),
(306, 'Jamalpur', 5),
(307, 'Jamui', 5),
(308, 'Jehanabad', 5),
(309, 'Jhajha', 5),
(310, 'Jhanjharpur', 5),
(311, 'Jogabani', 5),
(312, 'Kanti', 5),
(313, 'Katihar', 5),
(314, 'Khagaria', 5),
(315, 'Kharagpur', 5),
(316, 'Kishanganj', 5),
(317, 'Lakhisarai', 5),
(318, 'Lalganj', 5),
(319, 'Madhepura', 5),
(320, 'Madhubani', 5),
(321, 'Maharajganj', 5),
(322, 'Mahnar Bazar', 5),
(323, 'Makhdumpur', 5),
(324, 'Maner', 5),
(325, 'Manihari', 5),
(326, 'Marhaura', 5),
(327, 'Masaurhi', 5),
(328, 'Mirganj', 5),
(329, 'Mokameh', 5),
(330, 'Motihari', 5),
(331, 'Motipur', 5),
(332, 'Munger', 5),
(333, 'Murliganj', 5),
(334, 'Muzaffarpur', 5),
(335, 'Narkatiaganj', 5),
(336, 'Naugachhia', 5),
(337, 'Nawada', 5),
(338, 'Nokha', 5),
(339, 'Patna', 5),
(340, 'Piro', 5),
(341, 'Purnia', 5),
(342, 'Rafiganj', 5),
(343, 'Rajgir', 5),
(344, 'Ramnagar', 5),
(345, 'Raxaul Bazar', 5),
(346, 'Revelganj', 5),
(347, 'Rosera', 5),
(348, 'Saharsa', 5),
(349, 'Samastipur', 5),
(350, 'Sasaram', 5),
(351, 'Sheikhpura', 5),
(352, 'Sheohar', 5),
(353, 'Sherghati', 5),
(354, 'Silao', 5),
(355, 'Sitamarhi', 5),
(356, 'Siwan', 5),
(357, 'Sonepur', 5),
(358, 'Sugauli', 5),
(359, 'Sultanganj', 5),
(360, 'Supaul', 5),
(361, 'Warisaliganj', 5),
(362, 'Ambala', 13),
(363, 'Ambala', 13),
(364, 'Asankhurd', 13),
(365, 'Assandh', 13),
(366, 'Ateli', 13),
(367, 'Babiyal', 13),
(368, 'Bahadurgarh', 13),
(369, 'Barwala', 13),
(370, 'Bhiwani', 13),
(371, 'Charkhi Dadri', 13),
(372, 'Cheeka', 13),
(373, 'Ellenabad 2', 13),
(374, 'Faridabad', 13),
(375, 'Fatehabad', 13),
(376, 'Ganaur', 13),
(377, 'Gharaunda', 13),
(378, 'Gohana', 13),
(379, 'Gurgaon', 13),
(380, 'Haibat(Yamuna Nagar)', 13),
(381, 'Hansi', 13),
(382, 'Hisar', 13),
(383, 'Hodal', 13),
(384, 'Jhajjar', 13),
(385, 'Jind', 13),
(386, 'Kaithal', 13),
(387, 'Kalan Wali', 13),
(388, 'Kalka', 13),
(389, 'Karnal', 13),
(390, 'Ladwa', 13),
(391, 'Mahendragarh', 13),
(392, 'Mandi Dabwali', 13),
(393, 'Narnaul', 13),
(394, 'Narwana', 13),
(395, 'Palwal', 13),
(396, 'Panchkula', 13),
(397, 'Panipat', 13),
(398, 'Pehowa', 13),
(399, 'Pinjore', 13),
(400, 'Rania', 13),
(401, 'Ratia', 13),
(402, 'Rewari', 13),
(403, 'Rohtak', 13),
(404, 'Safidon', 13),
(405, 'Samalkha', 13),
(406, 'Shahbad', 13),
(407, 'Sirsa', 13),
(408, 'Sohna', 13),
(409, 'Sonipat', 13),
(410, 'Taraori', 13),
(411, 'Thanesar', 13),
(412, 'Tohana', 13),
(413, 'Yamunanagar', 13),
(414, 'Arki', 14),
(415, 'Baddi', 14),
(416, 'Bilaspur', 14),
(417, 'Chamba', 14),
(418, 'Dalhousie', 14),
(419, 'Dharamsala', 14),
(420, 'Hamirpur', 14),
(421, 'Mandi', 14),
(422, 'Nahan', 14),
(423, 'Shimla', 14),
(424, 'Solan', 14),
(425, 'Sundarnagar', 14),
(426, 'Achabbal', 15),
(427, 'Akhnoor', 15),
(428, 'Anantnag', 15),
(429, 'Arnia', 15),
(430, 'Awantipora', 15),
(431, 'Bandipore', 15),
(432, 'Baramula', 15),
(433, 'Kathua', 15),
(434, 'Leh', 15),
(435, 'Punch', 15),
(436, 'Rajauri', 15),
(437, 'Sopore', 15),
(438, 'Srinagar', 15),
(439, 'Udhampur', 15),
(440, 'Arasikere', 17),
(441, 'Bangalore', 17),
(442, 'Belgaum', 17),
(443, 'Bellary', 17),
(444, 'Chamrajnagar', 17),
(445, 'Chikkaballapur', 17),
(446, 'Chintamani', 17),
(447, 'Chitradurga', 17),
(448, 'Gulbarga', 17),
(449, 'Gundlupet', 17),
(450, 'Hassan', 17),
(451, 'Hospet', 17),
(452, 'Hubli', 17),
(453, 'Karkala', 17),
(454, 'Karwar', 17),
(455, 'Kolar', 17),
(456, 'Kota', 17),
(457, 'Lakshmeshwar', 17),
(458, 'Lingsugur', 17),
(459, 'Maddur', 17),
(460, 'Madhugiri', 17),
(461, 'Madikeri', 17),
(462, 'Magadi', 17),
(463, 'Mahalingpur', 17),
(464, 'Malavalli', 17),
(465, 'Malur', 17),
(466, 'Mandya', 17),
(467, 'Mangalore', 17),
(468, 'Manvi', 17),
(469, 'Mudalgi', 17),
(470, 'Mudbidri', 17),
(471, 'Muddebihal', 17),
(472, 'Mudhol', 17),
(473, 'Mulbagal', 17),
(474, 'Mundargi', 17),
(475, 'Mysore', 17),
(476, 'Nanjangud', 17),
(477, 'Pavagada', 17),
(478, 'Puttur', 17),
(479, 'Rabkavi Banhatti', 17),
(480, 'Raichur', 17),
(481, 'Ramanagaram', 17),
(482, 'Ramdurg', 17),
(483, 'Ranibennur', 17),
(484, 'Robertson Pet', 17),
(485, 'Ron', 17),
(486, 'Sadalgi', 17),
(487, 'Sagar', 17),
(488, 'Sakleshpur', 17),
(489, 'Sandur', 17),
(490, 'Sankeshwar', 17),
(491, 'Saundatti-Yellamma', 17),
(492, 'Savanur', 17),
(493, 'Sedam', 17),
(494, 'Shahabad', 17),
(495, 'Shahpur', 17),
(496, 'Shiggaon', 17),
(497, 'Shikapur', 17),
(498, 'Shimoga', 17),
(499, 'Shorapur', 17),
(500, 'Shrirangapattana', 17),
(501, 'Sidlaghatta', 17),
(502, 'Sindgi', 17),
(503, 'Sindhnur', 17),
(504, 'Sira', 17),
(505, 'Sirsi', 17),
(506, 'Siruguppa', 17),
(507, 'Srinivaspur', 17),
(508, 'Talikota', 17),
(509, 'Tarikere', 17),
(510, 'Tekkalakota', 17),
(511, 'Terdal', 17),
(512, 'Tiptur', 17),
(513, 'Tumkur', 17),
(514, 'Udupi', 17),
(515, 'Vijayapura', 17),
(516, 'Wadi', 17),
(517, 'Yadgir', 17),
(518, 'Chikmagalur', 17),
(519, 'Davanagere', 17),
(520, 'Dharwad', 17),
(521, 'Gadag', 17),
(522, 'Adoor', 18),
(523, 'Akathiyoor', 18),
(524, 'Alappuzha', 18),
(525, 'Ancharakandy', 18),
(526, 'Aroor', 18),
(527, 'Ashtamichira', 18),
(528, 'Attingal', 18),
(529, 'Avinissery', 18),
(530, 'Chalakudy', 18),
(531, 'Changanassery', 18),
(532, 'Chendamangalam', 18),
(533, 'Chengannur', 18),
(534, 'Cherthala', 18),
(535, 'Cheruthazham', 18),
(536, 'Chittur-Thathamangalam', 18),
(537, 'Chockli', 18),
(538, 'Erattupetta', 18),
(539, 'Guruvayoor', 18),
(540, 'Irinjalakuda', 18),
(541, 'Kadirur', 18),
(542, 'Kalliasseri', 18),
(543, 'Kalpetta', 18),
(544, 'Kanhangad', 18),
(545, 'Kanjikkuzhi', 18),
(546, 'Kannur', 18),
(547, 'Kasaragod', 18),
(548, 'Kayamkulam', 18),
(549, 'Kochi', 18),
(550, 'Kodungallur', 18),
(551, 'Kollam', 18),
(552, 'Koothuparamba', 18),
(553, 'Kothamangalam', 18),
(554, 'Kottayam', 18),
(555, 'Kozhikode', 18),
(556, 'Kunnamkulam', 18),
(557, 'Malappuram', 18),
(558, 'Mattannur', 18),
(559, 'Mavelikkara', 18),
(560, 'Mavoor', 18),
(561, 'Muvattupuzha', 18),
(562, 'Nedumangad', 18),
(563, 'Neyyattinkara', 18),
(564, 'Ottappalam', 18),
(565, 'Palai', 18),
(566, 'Palakkad', 18),
(567, 'Panniyannur', 18),
(568, 'Pappinisseri', 18),
(569, 'Paravoor', 18),
(570, 'Pathanamthitta', 18),
(571, 'Payyannur', 18),
(572, 'Peringathur', 18),
(573, 'Perinthalmanna', 18),
(574, 'Perumbavoor', 18),
(575, 'Ponnani', 18),
(576, 'Punalur', 18),
(577, 'Quilandy', 18),
(578, 'Shoranur', 18),
(579, 'Taliparamba', 18),
(580, 'Thiruvalla', 18),
(581, 'Thiruvananthapuram', 18),
(582, 'Thodupuzha', 18),
(583, 'Thrissur', 18),
(584, 'Tirur', 18),
(585, 'Vadakara', 18),
(586, 'Vaikom', 18),
(587, 'Varkala', 18),
(588, 'Ashok Nagar', 20),
(589, 'Balaghat', 20),
(590, 'Betul', 20),
(591, 'Bhopal', 20),
(592, 'Burhanpur', 20),
(593, 'Chhatarpur', 20),
(594, 'Dabra', 20),
(595, 'Datia', 20),
(596, 'Dewas', 20),
(597, 'Dhar', 20),
(598, 'Fatehabad', 20),
(599, 'Gwalior', 20),
(600, 'Indore', 20),
(601, 'Itarsi', 20),
(602, 'Jabalpur', 20),
(603, 'Katni', 20),
(604, 'Kotma', 20),
(605, 'Lahar', 20),
(606, 'Lundi', 20),
(607, 'Maharajpur', 20),
(608, 'Mahidpur', 20),
(609, 'Maihar', 20),
(610, 'Malajkhand', 20),
(611, 'Manasa', 20),
(612, 'Manawar', 20),
(613, 'Mandideep', 20),
(614, 'Mandla', 20),
(615, 'Mandsaur', 20),
(616, 'Mauganj', 20),
(617, 'Mhow Cantonment', 20),
(618, 'Mhowgaon', 20),
(619, 'Morena', 20),
(620, 'Multai', 20),
(621, 'Murwara', 20),
(622, 'Nagda', 20),
(623, 'Nainpur', 20),
(624, 'Narsinghgarh', 20),
(625, 'Narsinghgarh', 20),
(626, 'Neemuch', 20),
(627, 'Nepanagar', 20),
(628, 'Niwari', 20),
(629, 'Nowgong', 20),
(630, 'Nowrozabad', 20),
(631, 'Pachore', 20),
(632, 'Pali', 20),
(633, 'Panagar', 20),
(634, 'Pandhurna', 20),
(635, 'Panna', 20),
(636, 'Pasan', 20),
(637, 'Pipariya', 20),
(638, 'Pithampur', 20),
(639, 'Porsa', 20),
(640, 'Prithvipur', 20),
(641, 'Raghogarh-Vijaypur', 20),
(642, 'Rahatgarh', 20),
(643, 'Raisen', 20),
(644, 'Rajgarh', 20),
(645, 'Ratlam', 20),
(646, 'Rau', 20),
(647, 'Rehli', 20),
(648, 'Rewa', 20),
(649, 'Sabalgarh', 20),
(650, 'Sagar', 20),
(651, 'Sanawad', 20),
(652, 'Sarangpur', 20),
(653, 'Sarni', 20),
(654, 'Satna', 20),
(655, 'Sausar', 20),
(656, 'Sehore', 20),
(657, 'Sendhwa', 20),
(658, 'Seoni', 20),
(659, 'Seoni-Malwa', 20),
(660, 'Shahdol', 20),
(661, 'Shajapur', 20),
(662, 'Shamgarh', 20),
(663, 'Sheopur', 20),
(664, 'Shivpuri', 20),
(665, 'Shujalpur', 20),
(666, 'Sidhi', 20),
(667, 'Sihora', 20),
(668, 'Singrauli', 20),
(669, 'Sironj', 20),
(670, 'Sohagpur', 20),
(671, 'Tarana', 20),
(672, 'Tikamgarh', 20),
(673, 'Ujhani', 20),
(674, 'Ujjain', 20),
(675, 'Umaria', 20),
(676, 'Vidisha', 20),
(677, 'Wara Seoni', 20),
(678, 'Kolhapur', 21),
(679, 'Ahmednagar', 21),
(680, 'Akola', 21),
(681, 'Amravati', 21),
(682, 'Aurangabad', 21),
(683, 'Baramati', 21),
(684, 'Chalisgaon', 21),
(685, 'Chinchani', 21),
(686, 'Devgarh', 21),
(687, 'Dhule', 21),
(688, 'Dombivli', 21),
(689, 'Durgapur', 21),
(690, 'Ichalkaranji', 21),
(691, 'Jalna', 21),
(692, 'Kalyan', 21),
(693, 'Latur', 21),
(694, 'Loha', 21),
(695, 'Lonar', 21),
(696, 'Lonavla', 21),
(697, 'Mahad', 21),
(698, 'Mahuli', 21),
(699, 'Malegaon', 21),
(700, 'Malkapur', 21),
(701, 'Manchar', 21),
(702, 'Mangalvedhe', 21),
(703, 'Mangrulpir', 21),
(704, 'Manjlegaon', 21),
(705, 'Manmad', 21),
(706, 'Manwath', 21),
(707, 'Mehkar', 21),
(708, 'Mhaswad', 21),
(709, 'Miraj', 21),
(710, 'Morshi', 21),
(711, 'Mukhed', 21),
(712, 'Mul', 21),
(713, 'Mumbai', 21),
(714, 'Murtijapur', 21),
(715, 'Nagpur', 21),
(716, 'Nalasopara', 21),
(717, 'Nanded-Waghala', 21),
(718, 'Nandgaon', 21),
(719, 'Nandura', 21),
(720, 'Nandurbar', 21),
(721, 'Narkhed', 21),
(722, 'Nashik', 21),
(723, 'Navi Mumbai', 21),
(724, 'Nawapur', 21),
(725, 'Nilanga', 21),
(726, 'Osmanabad', 21),
(727, 'Ozar', 21),
(728, 'Pachora', 21),
(729, 'Paithan', 21),
(730, 'Palghar', 21),
(731, 'Pandharkaoda', 21),
(732, 'Pandharpur', 21),
(733, 'Panvel', 21),
(734, 'Parbhani', 21),
(735, 'Parli', 21),
(736, 'Parola', 21),
(737, 'Partur', 21),
(738, 'Pathardi', 21),
(739, 'Pathri', 21),
(740, 'Patur', 21),
(741, 'Pauni', 21),
(742, 'Pen', 21),
(743, 'Phaltan', 21),
(744, 'Pulgaon', 21),
(745, 'Pune', 21),
(746, 'Purna', 21),
(747, 'Pusad', 21),
(748, 'Rahuri', 21),
(749, 'Rajura', 21),
(750, 'Ramtek', 21),
(751, 'Ratnagiri', 21),
(752, 'Raver', 21),
(753, 'Risod', 21),
(754, 'Sailu', 21),
(755, 'Sangamner', 21),
(756, 'Sangli', 21),
(757, 'Sangole', 21),
(758, 'Sasvad', 21),
(759, 'Satana', 21),
(760, 'Satara', 21),
(761, 'Savner', 21),
(762, 'Sawantwadi', 21),
(763, 'Shahade', 21),
(764, 'Shegaon', 21),
(765, 'Shendurjana', 21),
(766, 'Shirdi', 21),
(767, 'Shirpur-Warwade', 21),
(768, 'Shirur', 21),
(769, 'Shrigonda', 21),
(770, 'Shrirampur', 21),
(771, 'Sillod', 21),
(772, 'Sinnar', 21),
(773, 'Solapur', 21),
(774, 'Soyagaon', 21),
(775, 'Talegaon Dabhade', 21),
(776, 'Talode', 21),
(777, 'Tasgaon', 21),
(778, 'Tirora', 21),
(779, 'Tuljapur', 21),
(780, 'Tumsar', 21),
(781, 'Uran', 21),
(782, 'Uran Islampur', 21),
(783, 'Wadgaon Road', 21),
(784, 'Wai', 21),
(785, 'Wani', 21),
(786, 'Wardha', 21),
(787, 'Warora', 21),
(788, 'Warud', 21),
(789, 'Washim', 21),
(790, 'Yevla', 21),
(791, 'Kakching', 22),
(792, 'Lilong', 22),
(793, 'Mayang Imphal', 22),
(794, 'Thoubal', 22),
(795, 'Jowai', 23),
(796, 'Nongstoin', 23),
(797, 'Shillong', 23),
(798, 'Tura', 23),
(799, 'Aizawl', 24),
(800, 'Champhai', 24),
(801, 'Lunglei', 24),
(802, 'Saiha', 24),
(803, 'Dimapur', 25),
(804, 'Kohima', 25),
(805, 'Mokokchung', 25),
(806, 'Tuensang', 25),
(807, 'Wokha', 25),
(808, 'Zunheboto', 25),
(809, 'Anandapur', 26),
(810, 'Anugul', 26),
(811, 'Asika', 26),
(812, 'Balangir', 26),
(813, 'Balasore', 26),
(814, 'Baleshwar', 26),
(815, 'Bamra', 26),
(816, 'Barbil', 26),
(817, 'Bargarh', 26),
(818, 'Bargarh', 26),
(819, 'Baripada', 26),
(820, 'Basudebpur', 26),
(821, 'Belpahar', 26),
(822, 'Bhadrak', 26),
(823, 'Bhawanipatna', 26),
(824, 'Bhuban', 26),
(825, 'Bhubaneswar', 26),
(826, 'Biramitrapur', 26),
(827, 'Brahmapur', 26),
(828, 'Brajrajnagar', 26),
(829, 'Byasanagar', 26),
(830, 'Cuttack', 26),
(831, 'Debagarh', 26),
(832, 'Dhenkanal', 26),
(833, 'Gunupur', 26),
(834, 'Hinjilicut', 26),
(835, 'Jagatsinghapur', 26),
(836, 'Jajapur', 26),
(837, 'Jaleswar', 26),
(838, 'Jatani', 26),
(839, 'Jeypur', 26),
(840, 'Jharsuguda', 26),
(841, 'Joda', 26),
(842, 'Kantabanji', 26),
(843, 'Karanjia', 26),
(844, 'Kendrapara', 26),
(845, 'Kendujhar', 26),
(846, 'Khordha', 26),
(847, 'Koraput', 26),
(848, 'Malkangiri', 26),
(849, 'Nabarangapur', 26),
(850, 'Paradip', 26),
(851, 'Parlakhemundi', 26),
(852, 'Pattamundai', 26),
(853, 'Phulabani', 26),
(854, 'Puri', 26),
(855, 'Rairangpur', 26),
(856, 'Rajagangapur', 26),
(857, 'Raurkela', 26),
(858, 'Rayagada', 26),
(859, 'Sambalpur', 26),
(860, 'Soro', 26),
(861, 'Sunabeda', 26),
(862, 'Sundargarh', 26),
(863, 'Talcher', 26),
(864, 'Titlagarh', 26),
(865, 'Umarkote', 26),
(866, 'Ahmedgarh', 28),
(867, 'Amritsar', 28),
(868, 'Barnala', 28),
(869, 'Batala', 28),
(870, 'Bathinda', 28),
(871, 'Bhagha Purana', 28),
(872, 'Budhlada', 28),
(873, 'Chandigarh', 28),
(874, 'Dasua', 28),
(875, 'Dhuri', 28),
(876, 'Dinanagar', 28),
(877, 'Faridkot', 28),
(878, 'Fazilka', 28),
(879, 'Firozpur', 28),
(880, 'Firozpur Cantt.', 28),
(881, 'Giddarbaha', 28),
(882, 'Gobindgarh', 28),
(883, 'Gurdaspur', 28),
(884, 'Hoshiarpur', 28),
(885, 'Jagraon', 28),
(886, 'Jaitu', 28),
(887, 'Jalalabad', 28),
(888, 'Jalandhar', 28),
(889, 'Jalandhar Cantt.', 28),
(890, 'Jandiala', 28),
(891, 'Kapurthala', 28),
(892, 'Karoran', 28),
(893, 'Kartarpur', 28),
(894, 'Khanna', 28),
(895, 'Kharar', 28),
(896, 'Kot Kapura', 28),
(897, 'Kurali', 28),
(898, 'Longowal', 28),
(899, 'Ludhiana', 28),
(900, 'Malerkotla', 28),
(901, 'Malout', 28),
(902, 'Mansa', 28),
(903, 'Maur', 28),
(904, 'Moga', 28),
(905, 'Mohali', 28),
(906, 'Morinda', 28),
(907, 'Mukerian', 28),
(908, 'Muktsar', 28),
(909, 'Nabha', 28),
(910, 'Nakodar', 28),
(911, 'Nangal', 28),
(912, 'Nawanshahr', 28),
(913, 'Pathankot', 28),
(914, 'Patiala', 28),
(915, 'Patran', 28),
(916, 'Patti', 28),
(917, 'Phagwara', 28),
(918, 'Phillaur', 28),
(919, 'Qadian', 28),
(920, 'Raikot', 28),
(921, 'Rajpura', 28),
(922, 'Rampura Phul', 28),
(923, 'Rupnagar', 28),
(924, 'Samana', 28),
(925, 'Sangrur', 28),
(926, 'Sirhind Fatehgarh Sahib', 28),
(927, 'Sujanpur', 28),
(928, 'Sunam', 28),
(929, 'Talwara', 28),
(930, 'Tarn Taran', 28),
(931, 'Urmar Tanda', 28),
(932, 'Zira', 28),
(933, 'Zirakpur', 28),
(934, 'Ajmer', 29),
(935, 'Alwar', 29),
(936, 'Bandikui', 29),
(937, 'Baran', 29),
(938, 'Barmer', 29),
(939, 'Bikaner', 29),
(940, 'Fatehpur', 29),
(941, 'Jaipur', 29),
(942, 'Jaisalmer', 29),
(943, 'Jodhpur', 29),
(944, 'Kota', 29),
(945, 'Lachhmangarh', 29),
(946, 'Ladnu', 29),
(947, 'Lakheri', 29),
(948, 'Lalsot', 29),
(949, 'Losal', 29),
(950, 'Makrana', 29),
(951, 'Malpura', 29),
(952, 'Mandalgarh', 29),
(953, 'Mandawa', 29),
(954, 'Mangrol', 29),
(955, 'Merta City', 29),
(956, 'Mount Abu', 29),
(957, 'Nadbai', 29),
(958, 'Nagar', 29),
(959, 'Nagaur', 29),
(960, 'Nargund', 29),
(961, 'Nasirabad', 29),
(962, 'Nathdwara', 29),
(963, 'Navalgund', 29),
(964, 'Nawalgarh', 29),
(965, 'Neem-Ka-Thana', 29),
(966, 'Nelamangala', 29),
(967, 'Nimbahera', 29),
(968, 'Nipani', 29),
(969, 'Niwai', 29),
(970, 'Nohar', 29),
(971, 'Nokha', 29),
(972, 'Pali', 29),
(973, 'Phalodi', 29),
(974, 'Phulera', 29),
(975, 'Pilani', 29),
(976, 'Pilibanga', 29),
(977, 'Pindwara', 29),
(978, 'Pipar City', 29),
(979, 'Prantij', 29),
(980, 'Pratapgarh', 29),
(981, 'Raisinghnagar', 29),
(982, 'Rajakhera', 29),
(983, 'Rajaldesar', 29),
(984, 'Rajgarh (Alwar)', 29),
(985, 'Rajgarh (Churu', 29),
(986, 'Rajsamand', 29),
(987, 'Ramganj Mandi', 29),
(988, 'Ramngarh', 29),
(989, 'Ratangarh', 29),
(990, 'Rawatbhata', 29),
(991, 'Rawatsar', 29),
(992, 'Reengus', 29),
(993, 'Sadri', 29),
(994, 'Sadulshahar', 29),
(995, 'Sagwara', 29),
(996, 'Sambhar', 29),
(997, 'Sanchore', 29),
(998, 'Sangaria', 29),
(999, 'Sardarshahar', 29),
(1000, 'Sawai Madhopur', 29),
(1001, 'Shahpura', 29),
(1002, 'Shahpura', 29),
(1003, 'Sheoganj', 29),
(1004, 'Sikar', 29),
(1005, 'Sirohi', 29),
(1006, 'Sojat', 29),
(1007, 'Sri Madhopur', 29),
(1008, 'Sujangarh', 29),
(1009, 'Sumerpur', 29),
(1010, 'Suratgarh', 29),
(1011, 'Taranagar', 29),
(1012, 'Todabhim', 29),
(1013, 'Todaraisingh', 29),
(1014, 'Tonk', 29),
(1015, 'Udaipur', 29),
(1016, 'Udaipurwati', 29),
(1017, 'Vijainagar', 29),
(1018, 'Gangtok', 30),
(1019, 'Arakkonam', 31),
(1020, 'Arcot', 31),
(1021, 'Aruppukkottai', 31),
(1022, 'Bhavani', 31),
(1023, 'Chengalpattu', 31),
(1024, 'Chennai', 31),
(1025, 'Chinna salem', 31),
(1026, 'Coimbatore', 31),
(1027, 'Coonoor', 31),
(1028, 'Cuddalore', 31),
(1029, 'Dharmapuri', 31),
(1030, 'Dindigul', 31),
(1031, 'Erode', 31),
(1032, 'Gudalur', 31),
(1033, 'Gudalur', 31),
(1034, 'Gudalur', 31),
(1035, 'Kanchipuram', 31),
(1036, 'Karaikudi', 31),
(1037, 'Karungal', 31),
(1038, 'Karur', 31),
(1039, 'Kollankodu', 31),
(1040, 'Lalgudi', 31),
(1041, 'Madurai', 31),
(1042, 'Nagapattinam', 31),
(1043, 'Nagercoil', 31),
(1044, 'Namagiripettai', 31),
(1045, 'Namakkal', 31),
(1046, 'Nandivaram-Guduvancheri', 31),
(1047, 'Nanjikottai', 31),
(1048, 'Natham', 31),
(1049, 'Nellikuppam', 31),
(1050, 'Neyveli', 31),
(1051, 'O Valley', 31),
(1052, 'Oddanchatram', 31),
(1053, 'P.N.Patti', 31),
(1054, 'Pacode', 31),
(1055, 'Padmanabhapuram', 31),
(1056, 'Palani', 31),
(1057, 'Palladam', 31),
(1058, 'Pallapatti', 31),
(1059, 'Pallikonda', 31),
(1060, 'Panagudi', 31),
(1061, 'Panruti', 31),
(1062, 'Paramakudi', 31),
(1063, 'Parangipettai', 31),
(1064, 'Pattukkottai', 31),
(1065, 'Perambalur', 31),
(1066, 'Peravurani', 31),
(1067, 'Periyakulam', 31),
(1068, 'Periyasemur', 31),
(1069, 'Pernampattu', 31),
(1070, 'Pollachi', 31),
(1071, 'Polur', 31),
(1072, 'Ponneri', 31),
(1073, 'Pudukkottai', 31),
(1074, 'Pudupattinam', 31),
(1075, 'Puliyankudi', 31),
(1076, 'Punjaipugalur', 31),
(1077, 'Rajapalayam', 31),
(1078, 'Ramanathapuram', 31),
(1079, 'Rameshwaram', 31),
(1080, 'Rasipuram', 31),
(1081, 'Salem', 31),
(1082, 'Sankarankoil', 31),
(1083, 'Sankari', 31),
(1084, 'Sathyamangalam', 31),
(1085, 'Sattur', 31),
(1086, 'Shenkottai', 31),
(1087, 'Sholavandan', 31),
(1088, 'Sholingur', 31),
(1089, 'Sirkali', 31),
(1090, 'Sivaganga', 31),
(1091, 'Sivagiri', 31),
(1092, 'Sivakasi', 31),
(1093, 'Srivilliputhur', 31),
(1094, 'Surandai', 31),
(1095, 'Suriyampalayam', 31),
(1096, 'Tenkasi', 31),
(1097, 'Thammampatti', 31),
(1098, 'Thanjavur', 31),
(1099, 'Tharamangalam', 31),
(1100, 'Tharangambadi', 31),
(1101, 'Theni Allinagaram', 31),
(1102, 'Thirumangalam', 31),
(1103, 'Thirunindravur', 31),
(1104, 'Thiruparappu', 31),
(1105, 'Thirupuvanam', 31),
(1106, 'Thiruthuraipoondi', 31),
(1107, 'Thiruvallur', 31),
(1108, 'Thiruvarur', 31),
(1109, 'Thoothukudi', 31),
(1110, 'Thuraiyur', 31),
(1111, 'Tindivanam', 31),
(1112, 'Tiruchendur', 31),
(1113, 'Tiruchengode', 31),
(1114, 'Tiruchirappalli', 31),
(1115, 'Tirukalukundram', 31),
(1116, 'Tirukkoyilur', 31),
(1117, 'Tirunelveli', 31),
(1118, 'Tirupathur', 31),
(1119, 'Tirupathur', 31),
(1120, 'Tiruppur', 31),
(1121, 'Tiruttani', 31),
(1122, 'Tiruvannamalai', 31),
(1123, 'Tiruvethipuram', 31),
(1124, 'Tittakudi', 31),
(1125, 'Udhagamandalam', 31),
(1126, 'Udumalaipettai', 31),
(1127, 'Unnamalaikadai', 31),
(1128, 'Usilampatti', 31),
(1129, 'Uthamapalayam', 31),
(1130, 'Uthiramerur', 31),
(1131, 'Vadakkuvalliyur', 31),
(1132, 'Vadalur', 31),
(1133, 'Vadipatti', 31),
(1134, 'Valparai', 31),
(1135, 'Vandavasi', 31),
(1136, 'Vaniyambadi', 31),
(1137, 'Vedaranyam', 31),
(1138, 'Vellakoil', 31),
(1139, 'Vellore', 31),
(1140, 'Vikramasingapuram', 31),
(1141, 'Viluppuram', 31),
(1142, 'Virudhachalam', 31),
(1143, 'Virudhunagar', 31),
(1144, 'Viswanatham', 31),
(1145, 'Chennai', 31),
(1146, 'Coimbatore', 31),
(1147, 'Agartala', 32),
(1148, 'Badharghat', 32),
(1149, 'Dharmanagar', 32),
(1150, 'Indranagar', 32),
(1151, 'Jogendranagar', 32),
(1152, 'Kailasahar', 32),
(1153, 'Khowai', 32),
(1154, 'Pratapgarh', 32),
(1155, 'Udaipur', 32),
(1156, 'Achhnera', 34),
(1157, 'Adari', 34),
(1158, 'Agra', 34),
(1159, 'Aligarh', 34),
(1160, 'Allahabad', 34),
(1161, 'Amroha', 34),
(1162, 'Azamgarh', 34),
(1163, 'Bahraich', 34),
(1164, 'Ballia', 34),
(1165, 'Balrampur', 34),
(1166, 'Banda', 34),
(1167, 'Bareilly', 34),
(1168, 'Chandausi', 34),
(1169, 'Dadri', 34),
(1170, 'Deoria', 34),
(1171, 'Etawah', 34),
(1172, 'Fatehabad', 34),
(1173, 'Fatehpur', 34),
(1174, 'Fatehpur', 34),
(1175, 'Greater Noida', 34),
(1176, 'Hamirpur', 34),
(1177, 'Hardoi', 34),
(1178, 'Jajmau', 34),
(1179, 'Jaunpur', 34),
(1180, 'Jhansi', 34),
(1181, 'Kalpi', 34),
(1182, 'Kanpur', 34),
(1183, 'Kota', 34),
(1184, 'Laharpur', 34),
(1185, 'Lakhimpur', 34),
(1186, 'Lal Gopalganj Nindaura', 34),
(1187, 'Lalganj', 34),
(1188, 'Lalitpur', 34),
(1189, 'Lar', 34),
(1190, 'Loni', 34),
(1191, 'Lucknow', 34),
(1192, 'Mathura', 34),
(1193, 'Meerut', 34),
(1194, 'Modinagar', 34),
(1195, 'Muradnagar', 34),
(1196, 'Nagina', 34),
(1197, 'Najibabad', 34),
(1198, 'Nakur', 34),
(1199, 'Nanpara', 34),
(1200, 'Naraura', 34),
(1201, 'Naugawan Sadat', 34),
(1202, 'Nautanwa', 34),
(1203, 'Nawabganj', 34),
(1204, 'Nehtaur', 34),
(1205, 'NOIDA', 34),
(1206, 'Noorpur', 34),
(1207, 'Obra', 34),
(1208, 'Orai', 34),
(1209, 'Padrauna', 34),
(1210, 'Palia Kalan', 34),
(1211, 'Parasi', 34),
(1212, 'Phulpur', 34),
(1213, 'Pihani', 34),
(1214, 'Pilibhit', 34),
(1215, 'Pilkhuwa', 34),
(1216, 'Powayan', 34),
(1217, 'Pukhrayan', 34),
(1218, 'Puranpur', 34),
(1219, 'Purquazi', 34),
(1220, 'Purwa', 34),
(1221, 'Rae Bareli', 34),
(1222, 'Rampur', 34),
(1223, 'Rampur Maniharan', 34),
(1224, 'Rasra', 34),
(1225, 'Rath', 34),
(1226, 'Renukoot', 34),
(1227, 'Reoti', 34),
(1228, 'Robertsganj', 34),
(1229, 'Rudauli', 34),
(1230, 'Rudrapur', 34),
(1231, 'Sadabad', 34),
(1232, 'Safipur', 34),
(1233, 'Saharanpur', 34),
(1234, 'Sahaspur', 34),
(1235, 'Sahaswan', 34),
(1236, 'Sahawar', 34),
(1237, 'Sahjanwa', 34),
(1238, 'Sambhal', 34),
(1239, 'Samdhan', 34),
(1240, 'Samthar', 34),
(1241, 'Sandi', 34),
(1242, 'Sandila', 34),
(1243, 'Sardhana', 34),
(1244, 'Seohara', 34),
(1245, 'Shahganj', 34),
(1246, 'Shahjahanpur', 34),
(1247, 'Shamli', 34),
(1248, 'Sherkot', 34),
(1249, 'Shikohabad', 34),
(1250, 'Shishgarh', 34),
(1251, 'Siana', 34),
(1252, 'Sikanderpur', 34),
(1253, 'Sikandra Rao', 34),
(1254, 'Sikandrabad', 34),
(1255, 'Sirsaganj', 34),
(1256, 'Sirsi', 34),
(1257, 'Sitapur', 34),
(1258, 'Soron', 34),
(1259, 'Suar', 34),
(1260, 'Sultanpur', 34),
(1261, 'Sumerpur', 34),
(1262, 'Tanda', 34),
(1263, 'Tanda', 34),
(1264, 'Tetri Bazar', 34),
(1265, 'Thakurdwara', 34),
(1266, 'Thana Bhawan', 34),
(1267, 'Tilhar', 34),
(1268, 'Tirwaganj', 34),
(1269, 'Tulsipur', 34),
(1270, 'Tundla', 34),
(1271, 'Unnao', 34),
(1272, 'Utraula', 34),
(1273, 'Varanasi', 34),
(1274, 'Vrindavan', 34),
(1275, 'Warhapur', 34),
(1276, 'Zaidpur', 34),
(1277, 'Zamania', 34),
(1278, 'Calcutta', 35),
(1279, 'Alipurduar', 35),
(1280, 'Arambagh', 35),
(1281, 'Asansol', 35),
(1282, 'Baharampur', 35),
(1283, 'Bally', 35),
(1284, 'Balurghat', 35),
(1285, 'Bankura', 35),
(1286, 'Barakar', 35),
(1287, 'Barasat', 35),
(1288, 'Bardhaman', 35),
(1289, 'Bidhan Nagar', 35),
(1290, 'Chinsura', 35),
(1291, 'Contai', 35),
(1292, 'Cooch Behar', 35),
(1293, 'Darjeeling', 35),
(1294, 'Durgapur', 35),
(1295, 'Haldia', 35),
(1296, 'Howrah', 35),
(1297, 'Islampur', 35),
(1298, 'Jhargram', 35),
(1299, 'Kharagpur', 35),
(1300, 'Kolkata', 35),
(1301, 'Mainaguri', 35),
(1302, 'Mal', 35),
(1303, 'Mathabhanga', 35),
(1304, 'Medinipur', 35),
(1305, 'Memari', 35),
(1306, 'Monoharpur', 35),
(1307, 'Murshidabad', 35),
(1308, 'Nabadwip', 35),
(1309, 'Naihati', 35),
(1310, 'Panchla', 35),
(1311, 'Pandua', 35),
(1312, 'Paschim Punropara', 35),
(1313, 'Purulia', 35),
(1314, 'Raghunathpur', 35),
(1315, 'Raiganj', 35),
(1316, 'Rampurhat', 35),
(1317, 'Ranaghat', 35),
(1318, 'Sainthia', 35),
(1319, 'Santipur', 35),
(1320, 'Siliguri', 35),
(1321, 'Sonamukhi', 35),
(1322, 'Srirampore', 35),
(1323, 'Suri', 35),
(1324, 'Taki', 35),
(1325, 'Tamluk', 35),
(1326, 'Tarakeswar', 35),
(1327, 'Asola', 10),
(1328, 'Delhi', 10),
(1329, 'Aldona', 11),
(1330, 'Curchorem Cacora', 11),
(1331, 'Madgaon', 11),
(1332, 'Mapusa', 11),
(1333, 'Margao', 11),
(1334, 'Marmagao', 11),
(1335, 'Panaji', 11),
(1336, 'Karaikal', 27),
(1337, 'Mahe', 27),
(1338, 'Pondicherry', 27),
(1339, 'Yanam', 27),
(1340, 'Amlabad', 16),
(1341, 'Ara', 16),
(1342, 'Barughutu', 16),
(1343, 'Bokaro Steel City', 16),
(1344, 'Chaibasa', 16),
(1345, 'Chakradharpur', 16),
(1346, 'Chandrapura', 16),
(1347, 'Chatra', 16),
(1348, 'Chirkunda', 16),
(1349, 'Churi', 16),
(1350, 'Daltonganj', 16),
(1351, 'Deoghar', 16),
(1352, 'Dhanbad', 16),
(1353, 'Dumka', 16),
(1354, 'Garhwa', 16),
(1355, 'Ghatshila', 16),
(1356, 'Giridih', 16),
(1357, 'Godda', 16),
(1358, 'Gomoh', 16),
(1359, 'Gumia', 16),
(1360, 'Gumla', 16),
(1361, 'Hazaribag', 16),
(1362, 'Hussainabad', 16),
(1363, 'Jamshedpur', 16),
(1364, 'Jamtara', 16),
(1365, 'Jhumri Tilaiya', 16),
(1366, 'Khunti', 16),
(1367, 'Lohardaga', 16),
(1368, 'Madhupur', 16),
(1369, 'Mihijam', 16),
(1370, 'Musabani', 16),
(1371, 'Pakaur', 16),
(1372, 'Patratu', 16),
(1373, 'Phusro', 16),
(1374, 'Ramngarh', 16),
(1375, 'Ranchi', 16),
(1376, 'Sahibganj', 16),
(1377, 'Saunda', 16),
(1378, 'Simdega', 16),
(1379, 'Tenu Dam-cum- Kathhara', 16),
(1380, 'Ahiwara', 7),
(1381, 'Akaltara', 7),
(1382, 'Ambagarh Chowki', 7),
(1383, 'Ambikapur', 7),
(1384, 'Arang', 7),
(1385, 'Bade Bacheli', 7),
(1386, 'Balod', 7),
(1387, 'Baloda Bazar', 7),
(1388, 'Bemetra', 7),
(1389, 'Bhatapara', 7),
(1390, 'Bilaspur', 7),
(1391, 'Birgaon', 7),
(1392, 'Champa', 7),
(1393, 'Chirmiri', 7),
(1394, 'Dalli-Rajhara', 7),
(1395, 'Dhamtari', 7),
(1396, 'Dipka', 7),
(1397, 'Dongargarh', 7),
(1398, 'Durg-Bhilai Nagar', 7),
(1399, 'Gobranawapara', 7),
(1400, 'Jagdalpur', 7),
(1401, 'Janjgir', 7),
(1402, 'Jashpurnagar', 7),
(1403, 'Kanker', 7),
(1404, 'Kawardha', 7),
(1405, 'Kondagaon', 7),
(1406, 'Korba', 7),
(1407, 'Mahasamund', 7),
(1408, 'Mahendragarh', 7),
(1409, 'Mungeli', 7),
(1410, 'Naila Janjgir', 7),
(1411, 'Raigarh', 7),
(1412, 'Raipur', 7),
(1413, 'Rajnandgaon', 7),
(1414, 'Sakti', 7),
(1415, 'Tilda Newra', 7),
(1416, 'Nainital', 33),
(1417, 'Almora', 33),
(1418, 'Pitoragarh', 33),
(1419, 'Udhamsingh Nagar', 33),
(1420, 'Bageshwar', 33),
(1421, 'Champawat', 33),
(1422, 'Garhwal(Pauri)', 33),
(1423, 'Tehri-Garhwal', 33),
(1424, 'Chamoli( Gopeshwar )', 33),
(1425, 'Uttarkashi', 33),
(1426, 'Dehradun', 33),
(1427, 'Rudraprayag', 33),
(1428, 'Haridwar', 33),
(1429, 'Dama', 9),
(1430, 'Diu', 9),
(1431, 'Andaman', 3),
(1432, 'Nicobar', 3),
(1433, 'Melbourne', 44),
(1434, 'Geelong', 44),
(1435, 'Kalgoorlie', 45),
(1436, 'Rockingham', 45),
(1437, 'Bundaberg', 46),
(1438, 'Caloundra', 46),
(1439, 'Townsville', 46),
(1440, 'Mount Isa', 46),
(1441, 'Mount Barker', 47),
(1442, 'Victor Harbor', 47),
(1443, 'Hobart', 48),
(1444, 'Launceston', 48),
(1445, 'Sitka', 36),
(1446, 'Juneau', 36),
(1447, 'Wrangell', 36),
(1448, 'Anchorage', 36),
(1449, 'San Diego', 37),
(1450, 'New York City', 38),
(1451, 'Rome', 38),
(1452, 'North Port', 39),
(1453, 'Jacksonville', 39),
(1454, 'Bunnell', 39),
(1455, 'Tampa', 39),
(1456, 'Beaumont', 40),
(1457, 'Waco', 40),
(1458, 'Marana', 41),
(1459, 'Eloy', 41),
(1460, 'Cleveland', 42),
(1461, 'Cincinnati', 42),
(1462, 'Jackson', 43);

Add following files :-

1. db.inc.php
2. index.php
3. ajax_state.php
4. ajax_city.php

db.inc.php

index.php









      
        
          Country:

ajax_state.php

 "") ? trim( addslashes($_REQUEST["country_id"])) : "";
if ($country_id <> "" ) { 
	$sql = "SELECT * FROM tgl_state WHERE country_id = ".$country_id ." ORDER BY state_name";
	$count = mysqli_num_rows(mysqli_query($link, $sql));
	if ($count > 0 ) {
		$query = mysqli_query($link, $sql);
		?>
		State:

ajax_city.php

 "") ? trim( addslashes($_REQUEST["state_id"])) : "";
if ($state_id <> "" ) { 
	$sql = "SELECT * FROM tgl_city WHERE state_id = ".$state_id ." ORDER BY city_name";
	$count = mysqli_num_rows(mysqli_query($link, $sql));
	if ($count > 0 ) {
		$query = mysqli_query($link, $sql);
		?>
		City:

jQuery Ajax Based Country, State and City List

Demo Code

Leave a Reply Cancel reply