php 模糊查询

<?php
error_reporting(0);
// 接收数据
$address = $_REQUEST['inputValue'];
$key = $_REQUEST['key'];

// 判断密钥
if($key != '2baa5fa3ed7175d7cf5343b0a38a150b'){
  $Msg1 = array('code'=>100,'msg'=>'非法访问');
    echo json_encode($Msg1);exit;
}

// 判断参数完整性
if($address==""){
  $Msg2 = array('code'=>200,'msg'=>'参数不完整');
    echo json_encode($Msg2);exit;
}

// 数据库链接（根据数据库信息替换对应参数）
$conn = mysql_connect("localhost","root","123456") or die("conn error".mysql_error());  
  mysql_query("SET NAMES UTF8");
  mysql_query("set character_set_client=utf8"); 
  mysql_query("set character_set_results=utf8");
  mysql_select_db("database",$conn) or die("selsct error".mysql_error());  

// 接收前端参数 key：2baa5fa3ed7175d7cf5343b0a38a150b
// echo MD5('3873329');



// 查询
$sql = "SELECT * FROM ftthname WHERE name LIKE '%$address%' ";    
$result = mysql_query($sql);
// $con = mysql_fetch_array($result);
while($row = mysql_fetch_array($result)){
  $con[]= $row;
}
$Msg0['code']= 000;
$Msg0['msg'] = 'success';
$Msg0['result'] = $con;
echo json_encode($con);
// 结束
?>