$('#locality_name').autocomplete({ 
		      	source: function( request, response ) {
		      		$.ajax({					
		      			url : 'ajax.php',
		      			dataType: "json",
						data: {
						   name_startsWith: request.term,
						   type: 'locality'
						},
						 success: function( data ) {
							 response( $.map( data, function( item ) {
								return {
									label: item,
									value: item
								}
							}));
						}
		      		});
		      	},
		      	autoFocus: true,
		      	minLength: 0      	
		      });

header("Content-Type: text/html; charset=windows-1251");
include("config/config.php");

if($_GET['type'] == 'locality'){
  $data= array("SELECT locality FROM locality where locality LIKE '".strtoupper($_GET['name_startsWith'])."%'");
  $_GET['name_startsWith'] = iconv('UTF-8', 'windows-1251', $_GET['name_startsWith']);

  $result = mysql_query("SELECT locality_name FROM locality where locality_name LIKE '".strtoupper($_GET['name_startsWith'])."%'");	
  while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
		array_push($data, $row['locality_name']);	
	}	
  echo json_encode($data);
} 

if($_GET['type'] == 'locality'){
    $_GET['name_startsWith'] = iconv('windows-1251', 'UTF-8', $_GET['name_startsWith']);
	$result = mysql_query("SELECT locality_name FROM locality where locality_name LIKE '".strtoupper($_GET['name_startsWith'])."%'");	

	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
	        $row['locality_name'] = iconv('UTF-8', 'windows-1251', $row['locality_name']);
		array_push($data, $row['locality_name']);	
	}	
	echo json_encode($query);
}

if($_GET['type'] == 'locality'){
    $_GET['name_startsWith'] = iconv( 'UTF-8', 'windows-1251', $_GET['name_startsWith']);
	$result = mysql_query("SELECT locality_name FROM locality where locality_name LIKE '".strtoupper($_GET['name_startsWith'])."%'");	
    $data = array();
	while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
	   $row['locality_name'] = iconv( 'windows-1251', 'UTF-8', $row['locality_name']);
		array_push($data, $row['locality_name']);	
	}	
	echo json_encode($data);
}

static function simple ( $request, $conn, $table, $primaryKey, $columns )
	{
		$bindings = array();
		$db = self::db( $conn );

		// Build the SQL query string from the request
		$limit = self::limit( $request, $columns );
		$order = self::order( $request, $columns );
		$where = self::filter( $request, $columns, $bindings );

		// Main query to actually get the data
		$data = self::sql_exec( $db, $bindings,
			"SELECT SQL_CALC_FOUND_ROWS `".implode("`, `", self::pluck($columns, 'db'))."`
			 FROM `$table`
			 $where
			 $order
			 $limit"
		);

		// Data set length after filtering
		$resFilterLength = self::sql_exec( $db,
			"SELECT FOUND_ROWS()"
		);
		$recordsFiltered = $resFilterLength[0][0];

		// Total data set length
		$resTotalLength = self::sql_exec( $db,
			"SELECT COUNT(`{$primaryKey}`)
			 FROM   `$table`"
		);
		$recordsTotal = $resTotalLength[0][0];


		/*
		 * Output
		 */

		return array(
			"draw"            => intval( $request['draw'] ),
			"recordsTotal"    => intval( $recordsTotal ),
			"recordsFiltered" => intval( $recordsFiltered ),
			"data"            => self::data_output( $columns, $data )
		);
	}