这种表单自动完成功能,像百度,google,淘宝他们的搜索功能都有,在用户输入一部要的内容时会根据条件显示相关内容。
php代码
class datafetch{
private $conn, $rs;
function __construct(){
$this->conn = mysql教程_connect("localhost","root","pwd") or die("cant't connect host~"); mysql_select_db("studentinfo",$this->conn) or die("cant't select database~"); }
public function data_list($s){
$this->rs=mysql_query("select sno from student where sno like '$s%'") or die("can't fetch~");
$datalist=array();
while($row = mysql_fetch_array($this->rs,mysql_assoc))
{
array_push($datalist,$row);
}
return $datalist; }}
$search= isset($argv[1]) ? $argv[1] : ( isset($_get['search']) ? $_get['search'] : '' ) ;
$fetch=new datafetch();
$data=$fetch->data_list($search);
echo '[';
foreach ($data as $key=>$value)
{ echo "nt";
echo '"'.$value['sno'].'"';
if( $key!=count($data)-1 ) echo ','; else echo "n";}echo "]n";
?>
这里是利用了php mysql返回json数据,因为上面的jquery也是分析json数据来处的,因为json数据比较实时小而快,所以很多时候都用它了。