<?php
	set_time_limit(0);
	$con = mysql_connect("localhost", "root", "root");
	mysql_select_db("kladr1", $con);
	mysql_query('CREATE TABLE kladr00 (row_id int(7) NOT NULL AUTO_INCREMENT, code char(19) DEFAULT NULL, parentcode char(19) DEFAULT NULL, socr char(10) DEFAULT NULL, name char(40) DEFAULT NULL, postindex char(6) DEFAULT NULL, ocato char(11) DEFAULT NULL, status char(1) DEFAULT NULL, level int(11) DEFAULT NULL, class_id char(3) DEFAULT NULL, numchildre int(11) DEFAULT NULL, PRIMARY KEY (row_id)) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=cp1251;');
	$f = fopen("Regions.csv", "r");
	while(!feof($f)){
		$data = fgetcsv($f, 1000, ';');
		$query1 = mysql_query("SELECT * FROM kladr".$data[0]." where code = ".$data[0]."00000000000;");
		$obj = mysql_fetch_object($query1);
		echo $obj->name."<br>";
		mysql_query("INSERT INTO kladr00 VALUES ({$obj->row_id},'{$obj->code}','{$obj->parentcode}','{$obj->socr}','{$obj->name}','{$obj->postindex}','{$obj->ocato}',{$obj->status},{$obj->level},0,{$obj->numchildre})");
	}
	
?>