<?php
    	include('../cfg/config.php');
	$link = mysql_connect(ini_get("mysql.default_host"),
		ini_get("mysql.default_user"),
		ini_get("mysql.default_password")) or die('Cannot connect to the DB');
	mysql_select_db('hitchhi8', $link) or die('Cannot select the DB');
	// Не помогло :(
	mysql_set_charset("Windows-1251", $link);
	$sql = "SELECT.."
	$result = mysql_query($sql, $link) or die('Query error');
	$posts = array();
	if(mysql_num_rows($result)) {
		while($post = mysql_fetch_assoc($result)) {
			$posts[] = array('post'=>$post);
		}
	}
	$result = json_encode(array('posts'=>$posts));
	header("Content-type: text/plain");
	echo "Результат:".$result;
?>

<?php
	function convertCharset(&$array, $from, $to) {
   		foreach ($array as $key => $value) {
      		if(is_array($value))
         		convertCharset($array[$key], $from, $to);
      		else
      			$array[$key] = iconv($from, $to, $value);
   		}
	}

	function hex2str($hex) {
		$r = '';
		for ($i = 0; $i < strlen($hex) - 1; $i += 2)
			$r .= chr(hexdec($hex[$i] . $hex[$i + 1]));
		return $r;
	}

	header("Content-type: text/plain");
	include('../cfg/config.php');
	//////////////////////////////////////
	// Connect to Db
	$link = mysql_connect(ini_get("mysql.default_host"),
		ini_get("mysql.default_user"),
		ini_get("mysql.default_password")) or die('Cannot connect to DB');
	mysql_select_db($db_name, $link) or die('Cannot select DB');
	mysql_set_charset("cp1251", $link);
	mysql_query("SET NAMES cp1251", $link) or die('Cannot set charset');
	//////////////////////////////////////
	// Get sql query
	$routelist_sql = '../sql/routelist.sql';
	$sql = @fread(@fopen($routelist_sql, 'r'), @filesize($routelist_sql)) or die('Error reading sql file');
	//////////////////////////////////////
	// Query sql
	$result = mysql_query($sql, $link) or die('Query error');
	//////////////////////////////////////
	// Put query result to array
	$rows = array();
	$rows[] = mysql_num_rows($result);
	while($r = mysql_fetch_assoc($result)) {
		$rows[] = $r;
	}
	//////////////////////////////////////
	// Convert array cp1251 to utf8
	convertCharset($rows, 'windows-1251', 'utf-8');
	//////////////////////////////////////
	// Encode result to json
	$result = '{"response":'.json_encode($rows).'}';
	//////////////////////////////////////
	// Convert utf16 to cp1251
	$result = preg_replace('/\\\u([0-9A-F]{4})/sei', 'iconv("utf-16", "windows-1251", hex2str("$1"))', $result);
	echo $result;
?>