一個簡單的 MySQL 搜索函數(shù)使用實例

怎么才能更好的學習MySQL,下面小編帶你們了結(jié)一個簡單的 MySQL 搜索函數(shù)。

if?(!function_exists('mysql_search'))?{  ???function?mysql_search($table,?$columns,?$query?=?'',?$options?=?Array())?{  ??????if?(empty($query))?{?return?Array();?}  ??????$sql_query?=?Array();  ??????$options['columns']?=?isset($options['columns'])?$options['columns']:'*';  ??????$options['method']?=?isset($options['method'])?$options['method']:'OR';  ??????$options['extra_sql']?=?isset($options['extra_sql'])?$options['extra_sql']:'';  ??????$query?=?ereg_replace('[[:<:>:]]',?'',?$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('?+',?'|',?$keywords);?}  ?????????$column_list?=?explode('?',?$column);  ?????????$sql?=?Array();  ?????????for?($i?=?0;?$i?$value,?'sql'=&gt;implode('?'?.?$options['method']?.?'?',?$sql));  ?????????$sql_query?=?array_merge($sql_query,?$sql);  ?????????$sql_query?=?implode('?'?.?$options['method']?.?'?',?$sql_query);  ??????}  ??????$results?=?mysql_fetch_results(mysql_query('SELECT?'?.?$options['columns']?.?'?FROM?'?.?$table?.?'?WHERE?'?.?$sql_query?.?'?'?.?$options['extra_sql']));  ??????return?$results;  ???}    }</:>

? 版權聲明
THE END
喜歡就支持一下吧
點贊14 分享