Aspire
Koineks
  • 05-10-2005, 19:28:04
    #1
    1/2
    Elinde alfabetik sıraya göre Türkiyedeki illerin listesi olan varmı. Liste oluşturmam gerekli tek tek yazmak uzun sürer diye sorayım dedim.
    Eğer elinizde varsa paylaşabilirmisiniz.
  • Sponsor Reklam
  • 05-10-2005, 19:36:12
    #2
    1/2
    İl Plaka Kodu - İl Adı
    1-ADANA
    2-ADIYAMAN
    3-AFYONKARAHİSAR
    4-AĞRI
    68-AKSARAY
    5-AMASYA
    6-ANKARA
    7-ANTALYA
    75-ARDAHAN
    8-ARTVİN
    9-AYDIN
    10-BALIKESİR
    74-BARTIN
    72-BATMAN
    69-BAYBURT
    11-BİLECİK
    12-BİNGÖL
    13-BİTLİS
    14-BOLU
    15-BURDUR
    16-BURSA
    17-ÇANAKKALE
    18-ÇANKIRI
    19-ÇORUM
    20-DENİZLİ
    21-DİYARBAKIR
    81-DÜZCE
    22-EDİRNE
    23-ELAZIĞ
    24-ERZİNCAN
    25-ERZURUM
    26-ESKİŞEHİR
    27-GAZİANTEP
    28-GİRESUN
    29-GÜMÜŞHANE
    30-HAKKARİ
    31-HATAY
    76-IĞDIR
    32-ISPARTA
    34-İSTANBUL
    35-İZMİR
    46-KAHRAMANMARAŞ
    78-KARABÜK
    70-KARAMAN
    36-KARS
    37-KASTAMONU
    38-KAYSERİ
    71-KIRIKKALE
    39-KIRKLARELİ
    40-KIRŞEHİR
    79-KİLİS
    41-KOCAELİ
    42-KONYA
    43-KÜTAHYA
    44-MALATYA
    45-MANİSA
    47-MARDİN
    33-MERSİN
    48-MUĞLA
    49-MUŞ
    50-NEVŞEHİR
    51-NİĞDE
    52-ORDU
    80-OSMANİYE
    53-RİZE
    54-SAKARYA
    55-SAMSUN
    56-SİİRT
    57-SİNOP
    58-SİVAS
    63-ŞANLI URFA
    73-ŞIRNAK
    59-TEKİRDAĞ
    60-TOKAT
    61-TRABZON
    62-TUNCELİ
    64-UŞAK
    65-VAN
    77-YALOVA
    66-YOZGAT
    67-ZONGULDAK
    elmasgunes.net
  • 05-10-2005, 19:42:15
    #3
    1/2
    http://www.alomaliye.com/plaka.htm

    eksik olanları buradan tamamlayabilirsin..
  • 05-10-2005, 20:55:34
    #4
    1/2
    Teşekkür ederim..
  • 09-10-2005, 07:28:08
    #5
    1/2
    CREATE TABLE sehir (
    id int(10) unsigned NOT NULL auto_increment,
    sehir varchar(255) default NULL,
    PRIMARY KEY (id),
    UNIQUE KEY id (id),
    KEY id_2 (id)
    ) ;

    INSERT INTO sehir VALUES("34", "Istanbul");
    INSERT INTO sehir VALUES("6", "Ankara");
    INSERT INTO sehir VALUES("35", "Izmir");
    INSERT INTO sehir VALUES("1", "Adana");
    INSERT INTO sehir VALUES("2", "Adıyaman");
    INSERT INTO sehir VALUES("3", "Afyon");
    INSERT INTO sehir VALUES("4", "Ağrı");
    INSERT INTO sehir VALUES("68", "Aksaray");
    INSERT INTO sehir VALUES("5", "Amasya");
    INSERT INTO sehir VALUES("7", "Antalya");
    INSERT INTO sehir VALUES("75", "Ardahan");
    INSERT INTO sehir VALUES("8", "Artvin");
    INSERT INTO sehir VALUES("9", "Aydın");
    INSERT INTO sehir VALUES("10", "Balıkesir");
    INSERT INTO sehir VALUES("74", "Bartın");
    INSERT INTO sehir VALUES("72", "Batman");
    INSERT INTO sehir VALUES("69", "Bayburt");
    INSERT INTO sehir VALUES("11", "Bilecik");
    INSERT INTO sehir VALUES("12", "Bingöl");
    INSERT INTO sehir VALUES("13", "Bitlis");
    INSERT INTO sehir VALUES("14", "Bolu");
    INSERT INTO sehir VALUES("15", "Burdur");
    INSERT INTO sehir VALUES("16", "Bursa");
    INSERT INTO sehir VALUES("17", "Çanakkale");
    INSERT INTO sehir VALUES("18", "Çankırı");
    INSERT INTO sehir VALUES("19", "Çorum");
    INSERT INTO sehir VALUES("20", "Denizli");
    INSERT INTO sehir VALUES("21", "Diyarbakır");
    INSERT INTO sehir VALUES("81", "Duzce");
    INSERT INTO sehir VALUES("22", "Edirne");
    INSERT INTO sehir VALUES("23", "Elazığ");
    INSERT INTO sehir VALUES("24", "Erzincan");
    INSERT INTO sehir VALUES("25", "Erzurum");
    INSERT INTO sehir VALUES("26", "Eskişehir");
    INSERT INTO sehir VALUES("27", "Gaziantep");
    INSERT INTO sehir VALUES("28", "Giresun");
    INSERT INTO sehir VALUES("29", "Gümüşhane");
    INSERT INTO sehir VALUES("30", "Hakkari");
    INSERT INTO sehir VALUES("31", "Hatay");
    INSERT INTO sehir VALUES("76", "Iğdır");
    INSERT INTO sehir VALUES("32", "Isparta");
    INSERT INTO sehir VALUES("33", "Içel(Mersin)");
    INSERT INTO sehir VALUES("78", "Karabük");
    INSERT INTO sehir VALUES("70", "Karaman");
    INSERT INTO sehir VALUES("36", "Kars");
    INSERT INTO sehir VALUES("37", "Kastamonu");
    INSERT INTO sehir VALUES("38", "Kayseri");
    INSERT INTO sehir VALUES("71", "Kırıkkale");
    INSERT INTO sehir VALUES("39", "Kırklareli");
    INSERT INTO sehir VALUES("40", "Kırşehir");
    INSERT INTO sehir VALUES("79", "Kilis");
    INSERT INTO sehir VALUES("41", "Kocaeli");
    INSERT INTO sehir VALUES("42", "Konya");
    INSERT INTO sehir VALUES("43", "Kütahya");
    INSERT INTO sehir VALUES("44", "Malatya");
    INSERT INTO sehir VALUES("45", "Manisa");
    INSERT INTO sehir VALUES("46", "Maraş");
    INSERT INTO sehir VALUES("47", "Mardin");
    INSERT INTO sehir VALUES("48", "Muğla");
    INSERT INTO sehir VALUES("49", "Muş");
    INSERT INTO sehir VALUES("50", "Nevşehir");
    INSERT INTO sehir VALUES("51", "Niğde");
    INSERT INTO sehir VALUES("52", "Ordu");
    INSERT INTO sehir VALUES("80", "Osmaniye");
    INSERT INTO sehir VALUES("53", "Rize");
    INSERT INTO sehir VALUES("54", "Sakarya");
    INSERT INTO sehir VALUES("55", "Samsun");
    INSERT INTO sehir VALUES("56", "Siirt");
    INSERT INTO sehir VALUES("57", "Sinop");
    INSERT INTO sehir VALUES("58", "Sivas");
    INSERT INTO sehir VALUES("73", "Sırnak");
    INSERT INTO sehir VALUES("59", "Tekirdağ");
    INSERT INTO sehir VALUES("60", "Tokat");
    INSERT INTO sehir VALUES("61", "Trabzon");
    INSERT INTO sehir VALUES("62", "Tunceli");
    INSERT INTO sehir VALUES("63", "Urfa");
    INSERT INTO sehir VALUES("64", "Uşak");
    INSERT INTO sehir VALUES("65", "Van");
    INSERT INTO sehir VALUES("77", "Yalova");
    INSERT INTO sehir VALUES("66", "Yozgat");
    INSERT INTO sehir VALUES("67", "Zonguldak");

    db de hazır olarak daha çok işine yarar
  • 09-10-2005, 07:44:26
    #6
    1/2
    asp.net icin webservisleri sunuyor e-devletimiz. ihtiyacin olursa yazayim (ara$tirmak zor geldi
  • 23-08-2009, 17:01:17
    #7
    1/2
    Allah razı olsun Şu şehir sorgusu çok işimi gördü XKARE sağolasın
  • 09-01-2010, 18:48:28
    #8
    1/2
    xkare adlı üyeden alıntı
    CREATE TABLE sehir (
    id int(10) unsigned NOT NULL auto_increment,
    sehir varchar(255) default NULL,
    PRIMARY KEY (id),
    UNIQUE KEY id (id),
    KEY id_2 (id)
    ) ;

    INSERT INTO sehir VALUES("34", "Istanbul");
    INSERT INTO sehir VALUES("6", "Ankara");
    INSERT INTO sehir VALUES("35", "Izmir");
    INSERT INTO sehir VALUES("1", "Adana");
    INSERT INTO sehir VALUES("2", "Adıyaman");
    INSERT INTO sehir VALUES("3", "Afyon");
    INSERT INTO sehir VALUES("4", "Ağrı");
    INSERT INTO sehir VALUES("68", "Aksaray");
    INSERT INTO sehir VALUES("5", "Amasya");
    INSERT INTO sehir VALUES("7", "Antalya");
    INSERT INTO sehir VALUES("75", "Ardahan");
    INSERT INTO sehir VALUES("8", "Artvin");
    INSERT INTO sehir VALUES("9", "Aydın");
    INSERT INTO sehir VALUES("10", "Balıkesir");
    INSERT INTO sehir VALUES("74", "Bartın");
    INSERT INTO sehir VALUES("72", "Batman");
    INSERT INTO sehir VALUES("69", "Bayburt");
    INSERT INTO sehir VALUES("11", "Bilecik");
    INSERT INTO sehir VALUES("12", "Bingöl");
    INSERT INTO sehir VALUES("13", "Bitlis");
    INSERT INTO sehir VALUES("14", "Bolu");
    INSERT INTO sehir VALUES("15", "Burdur");
    INSERT INTO sehir VALUES("16", "Bursa");
    INSERT INTO sehir VALUES("17", "Çanakkale");
    INSERT INTO sehir VALUES("18", "Çankırı");
    INSERT INTO sehir VALUES("19", "Çorum");
    INSERT INTO sehir VALUES("20", "Denizli");
    INSERT INTO sehir VALUES("21", "Diyarbakır");
    INSERT INTO sehir VALUES("81", "Duzce");
    INSERT INTO sehir VALUES("22", "Edirne");
    INSERT INTO sehir VALUES("23", "Elazığ");
    INSERT INTO sehir VALUES("24", "Erzincan");
    INSERT INTO sehir VALUES("25", "Erzurum");
    INSERT INTO sehir VALUES("26", "Eskişehir");
    INSERT INTO sehir VALUES("27", "Gaziantep");
    INSERT INTO sehir VALUES("28", "Giresun");
    INSERT INTO sehir VALUES("29", "Gümüşhane");
    INSERT INTO sehir VALUES("30", "Hakkari");
    INSERT INTO sehir VALUES("31", "Hatay");
    INSERT INTO sehir VALUES("76", "Iğdır");
    INSERT INTO sehir VALUES("32", "Isparta");
    INSERT INTO sehir VALUES("33", "Içel(Mersin)");
    INSERT INTO sehir VALUES("78", "Karabük");
    INSERT INTO sehir VALUES("70", "Karaman");
    INSERT INTO sehir VALUES("36", "Kars");
    INSERT INTO sehir VALUES("37", "Kastamonu");
    INSERT INTO sehir VALUES("38", "Kayseri");
    INSERT INTO sehir VALUES("71", "Kırıkkale");
    INSERT INTO sehir VALUES("39", "Kırklareli");
    INSERT INTO sehir VALUES("40", "Kırşehir");
    INSERT INTO sehir VALUES("79", "Kilis");
    INSERT INTO sehir VALUES("41", "Kocaeli");
    INSERT INTO sehir VALUES("42", "Konya");
    INSERT INTO sehir VALUES("43", "Kütahya");
    INSERT INTO sehir VALUES("44", "Malatya");
    INSERT INTO sehir VALUES("45", "Manisa");
    INSERT INTO sehir VALUES("46", "Maraş");
    INSERT INTO sehir VALUES("47", "Mardin");
    INSERT INTO sehir VALUES("48", "Muğla");
    INSERT INTO sehir VALUES("49", "Muş");
    INSERT INTO sehir VALUES("50", "Nevşehir");
    INSERT INTO sehir VALUES("51", "Niğde");
    INSERT INTO sehir VALUES("52", "Ordu");
    INSERT INTO sehir VALUES("80", "Osmaniye");
    INSERT INTO sehir VALUES("53", "Rize");
    INSERT INTO sehir VALUES("54", "Sakarya");
    INSERT INTO sehir VALUES("55", "Samsun");
    INSERT INTO sehir VALUES("56", "Siirt");
    INSERT INTO sehir VALUES("57", "Sinop");
    INSERT INTO sehir VALUES("58", "Sivas");
    INSERT INTO sehir VALUES("73", "Sırnak");
    INSERT INTO sehir VALUES("59", "Tekirdağ");
    INSERT INTO sehir VALUES("60", "Tokat");
    INSERT INTO sehir VALUES("61", "Trabzon");
    INSERT INTO sehir VALUES("62", "Tunceli");
    INSERT INTO sehir VALUES("63", "Urfa");
    INSERT INTO sehir VALUES("64", "Uşak");
    INSERT INTO sehir VALUES("65", "Van");
    INSERT INTO sehir VALUES("77", "Yalova");
    INSERT INTO sehir VALUES("66", "Yozgat");
    INSERT INTO sehir VALUES("67", "Zonguldak");

    db de hazır olarak daha çok işine yarar


    Teşekkür Ettim