Suggestion Search - проблем при търсене на кирилица

prostoaz · 16 Юли 2012

Здравейте, имам много странен проблем. При търсене на латиница, търсачката визуализира резултатите от дб, при търсене на кирилица не изкарва никакъв резултат, а такъв съм добавил ръчно в дб. Енкодинга във дб е cp1251_bulgarian_ci .. пробвах utf8.. и какви ли още не но не става. Пускам кода на търсачката, дано някой може да помогне.

Ето я търсачката:
http://web-tourist.net/login/login/view.php?st=3411

Код:

index.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
	<head>
		<META http-equiv="content-type" content="text/html; charset=windows-1251">
		<title>under construction</title>
		<link rel="stylesheet" type="text/css" href="css/style.css" />
		<script type="text/javascript" src="http://www.google.com/jsapi"></script>
		<script type="text/javascript" src="js/script.js"></script>
	</head>
<body>
<div>
	<form id="searchform">
		<div>
			What are you looking for? <input type="text" size="30" value="" id="inputString" onkeyup="lookup(this.value);" />
		</div>
		<div id="suggestions"></div>
	</form>
</div>
</body>
</html>

Код:

search.php

<p id="searchresults">
<?php
	// PHP5 Implementation - uses MySQLi.
	// mysqli('localhost', 'yourUsername', 'yourPassword', 'yourDatabase');
	$db = new mysqli('localhost', 'user', 'pass', 'db');
	
	if(!$db) {
		// Show error if we cannot connect.
		echo 'ERROR: Could not connect to the database.';
	} else {
		// Is there a posted query string?
		if(isset($_POST['queryString'])) {
			$queryString = $db->real_escape_string($_POST['queryString']);
			
			// Is the string length greater than 0?
			if(strlen($queryString) >0) {
				$query = $db->query("SELECT * FROM search s INNER JOIN categories c ON s.cat_id = c.cid WHERE name LIKE '%" . $queryString . "%' ORDER BY cat_id LIMIT 8");
				
				if($query) {
					// While there are results loop through them - fetching an Object.
					
					// Store the category id
					$catid = 0;
					while ($result = $query ->fetch_object()) {
						if($result->cat_id != $catid) { // check if the category changed
							echo '<span class="category">'.$result->cat_name.'</span>';
							$catid = $result->cat_id;
						}
	         			echo '<a href="'.$result->url.'">';
	         			echo '<img src="search_images/'.$result->img.'" alt="" />';
	         			
	         			$name = $result->name;
	         			if(strlen($name) > 35) { 
	         				$name = substr($name, 0, 35) . "...";
	         			}	         			
	         			echo '<span class="searchheading">'.$name.'</span>';
	         			
	         			$description = $result->desc;
	         			if(strlen($description) > 80) { 
	         				$description = substr($description, 0, 80) . "...";
	         			}
	         			
	         			echo '<span>'.$description.'</span></a>';
	         		}
	         		echo '<span class="seperator"><a href="http://www.marcofolio.net/sitemap.html" title="Sitemap">Nothing interesting here? Try the sitemap.</a></span><br class="break" />';
				} else {
					echo 'ERROR: There was a problem with the query.';
				}
			} else {
				// Dont do anything.
			} // There is a queryString.
		} else {
			echo 'There should be no direct access to this script!';
		}
	}
?>
</p>

Suggestion Search - проблем при търсене на кирилица

prostoaz

Registered