Paylaşım için teşekkürler. UTF-8 kullanmak istemeyenler aşağıdaki kodu kullanarak ekleyebilirler.
CREATE TABLE `ililce` (
`id` int(10) unsigned NOT NULL auto_increment,
`il_id` int(10) unsigned NOT NULL default '0',
`ilce` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
<?php
set_time_limit(0);
mysql_connect("localhost","root","");
mysql_select_db("ililce");
function utf8($q) {
$q = str_replace("Ç","Ç",$q);
$q = str_replace("ç","ç",$q);
$q = str_replace("İ","İ",$q);
$q = str_replace("ı","ı",$q);
$q = str_replace("ö","ö",$q);
$q = str_replace("ü","ü",$q);
$q = str_replace("ÄŸ","ğ",$q);
$q = str_replace("ÅŸ","ş",$q);
$q = str_replace("Å","Ş",$q);
$q = str_replace(" Büyükşehir","",$q);
$q = str_replace(" Mrk.","",$q);
$q = str_replace("\n","",$q);
$q = str_replace("\r","",$q);
$q = str_replace("\t","",$q);
$q = str_replace("\b","",$q);
$q = str_replace(" ","",$q);
$q = trim($q);
return $q;
}
for ($ii=1;$ii<82;$ii++) {
$f = file_get_contents("http://www.milliyet.com.tr/Secim2009/api/belediyelist.ashx?sehirid=".$ii);
$t1 = explode(";",$f); # 197#Tatvan
foreach ($t1 AS $key=>$val) {
$t2 = explode("#",$val);
$ilce=utf8($t2[1]);
$SQL="INSERT INTO ililce SET il_id='$ii',ilce='$ilce' ";
mysql_query($SQL);
}
}
?>