18-4.php

来自「php 和 ajax 开发的一些资料」· PHP 代码 · 共 25 行

<?php
$key=$_GET["key"];

$host="localhost";
$user="root";
$password="";
$db="test";
$table="check_key";
$my_conn=mysql_connect($host,$user,$password);
mysql_select_db($db,$my_conn);

$sql="select value from $table where value like '$key%'";
$result=mysql_query($sql,$my_conn);

if(mysql_num_rows($result)>0)
{
  header('Content-Type:text/XML;charset=UTF-8');
  echo "<all>";
  while($rows=mysql_fetch_array($result))
	{
	  echo "<v>".$rows[value]."</v>";
	}
	echo "</all>";
}
?>