ERROR: {".$resp['status']."}";
return false;
}
}
$host = "78.47.195.208";
$db_ide = "pijon_tbo";
$username = "user";
$password = "1";
$link = mysqli_connect($host,$username,$password,$db_ide);
if (!$link) {
printf("Невозможно подключиться к базе данных. Код ошибки: %s\n", mysqli_connect_error());
exit;
}
mysqli_query($link,'SET NAMES cp1251');
mysqli_query($link,'SET CHARACTER SET cp1251');
mysql_query("SET character_set_client = cp1251");
mysql_query("SET character_set_connection = cp1251");
mysql_query("SET character_set_results = cp1251");
mysqli_set_charset($link,"cp1251");
$query = "SELECT a.Descr, a.land_info, b.longitude, b.latitude, b.postalcode, i.Name, j.Name, c.Name, d.Name, e.Name, f.Name, g.Name, h.Name
FROM waste_dir_storage_locations as a
left join waste_dir_house as b on a.House = b.Id
left join waste_dir_location_type as c on a.location_type = c.Id
left join waste_dir_location_equipment as d on a.equipment = d.Id
left join waste_dir_location_condition as e on a.condition = e.Id
left join waste_dir_address_program as f on a.address_program = f.Id
left join waste_dir_company as g on a.company = g.Id
left join waste_dir_transport as h on a.transport = h.Id
left join waste_dir_municipality as i on b.municipality = i.Id
left join waste_dir_district as j on b.district = j.Id LIMIT 50";
//$query = "SELECT a.OKTMO, a.POSTALCODE, a.STREET, a.HOUSENUM, a.BUILDNUM, a.STRUCNUM, a.LONGITUDE, a.LATITUDE, a.STREETTYPE, b.MOBR, b.TYPEMOBR, b.OKATO, b.NAMEMOBR, b.NAMEMOKR, b.OKTMOCITY, b.NAMECITY from house_geo as a left join oktmo_dic as b on a.OKTMO = b.OKTMOMOBR WHERE a.LATITUDE > 0 LIMIT 10 ";
$result = mysqli_query($link,$query) or die(mysqli_error($link));
while ($row = mysqli_fetch_row($result)) {
//print_r($row);
if ($row['2']<1){
print_r(geocode(mb_convert_encoding($row['4'], "utf-8", "windows-1251").mb_convert_encoding($row['0'], "utf-8", "windows-1251")));
}
$markers .= ' {
lat: '.$row['3'].',
lng: '.$row['2'].',
land_info: "'.mb_convert_encoding(addslashes($row['1']), "utf-8", "windows-1251").'",
address: "'.addslashes($row['4']).', '.mb_convert_encoding($row['0'], "utf-8", "windows-1251").'",
municipality: "'.mb_convert_encoding(addslashes($row['5']), "utf-8", "windows-1251").'",
district:"'.mb_convert_encoding(addslashes($row['6']), "utf-8", "windows-1251").'",
location_type:"'.mb_convert_encoding(addslashes($row['7']), "utf-8", "windows-1251").'",
equipment:"'.mb_convert_encoding(addslashes($row['8']), "utf-8", "windows-1251").'",
condition:"'.mb_convert_encoding(addslashes($row['9']), "utf-8", "windows-1251").'",
address_program:"'.mb_convert_encoding(addslashes($row['10']), "utf-8", "windows-1251").'",
company:"'.mb_convert_encoding(addslashes($row['11']), "utf-8", "windows-1251").'",
transport:"'.mb_convert_encoding(addslashes($row['12']), "utf-8", "windows-1251").'"
},
';
}
?>
Интерактивная карта
Главрыба