mysql_query("SET NAMES 'GBK
'") or die(error(mysql_error()));
$db = new mysqli('192.168.200.254', 'dxy' ,'p0o9i8u7', 'patent');<br />if(!$db) {<br />// Show error if we cannot connect.<br />echo 'ERROR: Could not connect to the database.';<br />} else {<br />// Is there a posted query string?<br />if(isset($_POST['queryString'])) {<br />$queryString = $db->real_escape_string($_POST['queryString']);</p><p>// Is the string length greater than 0?</p><p>if(strlen($queryString) >0) {<br />$db->query("SET CHARACTER SET utf8");<br />$query = $db->query($query = "select patent_id,patent_name from list_id where patent_id like '%$queryString%' limit 6");<br />if($query) {<br />// While there are results loop through them - fetching an Object (i like PHP5 btw!).<br />while ($result = $query ->fetch_object()) {<br />echo "<li onClick=fill('".$result->patent_id."^^^".$result->patent_name."');>".$result->patent_id."<br/>".$result->patent_name."</li>";<br /> }<br />} else {<br />echo 'ERROR: There was a problem with the query.';<br />}<br />} else {<br />// Dont do anything.<br />} // There is a queryString.<br />} else {<br />echo 'There should be no direct access to this script!';<br />}<br />}