[摘要]the)[[:>:]], , $query);$query = ereg_replace( +, , trim(stripslashes($query)));$pattern = /([[:...
the)[[:>:]]', '', $query);
$query = ereg_replace(' +', ' ', trim(stripslashes($query)));
$pattern = '/([[:alpha:]:]+)([[:alpha:] ]+)[[:alpha:]]?+[ ]?/i';
$regs = Array();
preg_match_all($pattern, $query, $regs);
$query = $regs[0];
while (list($key, $value) = @each($query)) {
$column = $columns;
$keywords = urldecode($value);
if (strpos($value, ':')) {
$column = substr($value, 0, strpos($value, ':'));
$keywords = trim(substr($keywords, strpos($keywords, ':') + 1));
$keywords = ereg_replace('\'', '', $keywords);
} else { $keywords = ereg_replace(' +', '
关键词：一个容易的 MySQL 搜索函数运用案例