01.<?php
02.define ('XAJAX_DEFAULT_CHAR_ENCODING','TIS-620');
03.
04.
05.
06.$link=mysql_connect("localhost","root","123456") or die("error".mysql_error());
07.mysql_select_db("project",$link);
08.mysql_query("set character set utf8");
09.
10.$q = urldecode($_GET["q"]);
11.$group_id=urldecode($_GET["grp"]);
12.$conditgrp="";
13.$pagesize = 100;
14.$table_db="ajaxque";
15.$find_field="name";
16.if(!empty($group_id))
17.{
18. $conditgrp=" grp='".$group_id."' AND ";
19.}
20.$sql = "select * from $table_db where $conditgrp locate('$q', $find_field) > 0 order by locate('$q', $find_field), $find_field limit $pagesize";
21.
22. $results = mysql_query($sql);
23.while ($row = mysql_fetch_array($results )) {
24. $id = $row["code"];
25. $name = ucwords( strtolower( $row["name"] ) );
26.
27. $name = str_replace("'", "'", $name);
28.
29. $display_name = preg_replace("/(" . $q . ")/i", "<font color=red><b>$1</b></font>", $name);
30. echo "<li onselect=\"this.setText('$name').setValue('$id');\">$display_name</li>";
31.}
32.mysql_close();
33.?>
