原生PHP模糊搜索

//单字段搜索
if($_GET['dzso']){
	$dzso = trim(stripslashes($_GET['dzso'])); 		//stripslashes()用于去除字符串中的一个“\”
	$dz = "%{$dzso}%";
	$where[] = "binary area like '{$dz}'";
}
//多字段搜索
if ($_GET['dzso']) {
	$key = trim(stripslashes($_GET['dzso']))
	$sk = "%{$key}%";
	$fields = explode(" ", "name tel qq num content memo");
	$sfield = array();
	foreach ($fields as $_tm) {
		$sfield[] = "binary $_tm like '{$sk}'";
	}
	$where[] = "(".implode(" or ", $sfield).")";
}