01.<?php
02.header("Content-type:application/json; charset=UTF-8");
03.header("Cache-Control: no-store, no-cache, must-revalidate");
04.header("Cache-Control: post-check=0, pre-check=0", false);
05.
06.mysql_connect("localhost","root","1234") or die("Cannot connect the Server");
07.mysql_select_db("mh") or die("Cannot select database");
08.mysql_query("set character set utf8");
09.?>
10.
11.<?php
12.$pagesize = 50;
13.$table_db="med";
14.$find_field="keyword";
15.
16.
17.if($_GET['term']!=""){
18. $q = $_GET["term"];
19. $sql = "select * from $table_db where locate('$q', $find_field) > 0 order by locate('$q', $find_field), $find_field limit $pagesize";
20.}else{
21. $sql = "select * from $table_db where 1";
22.}
23.$qr=mysql_query($sql);
24.$total=mysql_num_rows($qr);
25.echo '[ ';
26.$i=0;
27.while ($rs=mysql_fetch_array($qr)) {
28. $i++;
29.echo '{"id":"'.$rs['medID'].'","label":"'.str_replace(""","",htmlentities($rs['keyword'], ENT_QUOTES, "UTF-8")).'","value":"'.str_replace(""","",htmlentities($rs['treat'], ENT_QUOTES, "UTF-8")).'"}';
30. if($i<$total){
31. echo ",";
32. }
33.}
34.echo ' ]';
35.mysql_close();
36.exit;
37.?>
มันจะดีนะ 555+
