Question

在这里,我试图得到一个搜索引擎取名字输入 Doe J 而不是 Doe, J。

这是我的代码:

$sql_where = array();

if (isset($_GET[ name ])) {

    echo "Searched: {$_GET[ name ]}<br>";

    $names = explode(   , trim(preg_replace( / +/ ,    , $_GET[ name ])));
    $names_cnt = count($names);

    if (2 == $names_cnt) {

        foreach ($names as $name_idx => $name) {

            if (($name_idx+1) == $names_cnt) {
                // last one
                $sql_where[] = "
                    (full_name like  % {$name}% )
                    ";
            } else {
                // first one
                $sql_where[] = "
                    (full_name like  {$name}% )
                    ";
            }
        }
    } else {

        $sql_where[] = "
            (full_name like  " . $DB->cleanString($_GET[ name ]) . "% )
            ";

我尝试了 /[a-zA-Z0-9]/ 和其他一些未成功修改的改动。

Answer 1

echo preg_replace( "`[^a-zA-Z0-9]+`", " ", $string); 
//replaces all non alpha numeric characters as " " 
//(and will not have duplicate spaces)

DEMO:“http://codepad.org/7Ltx3kcr' rel=“nofollow'>http://codepad.org/7Ltx3kcr

友情链接