参见英文答案 > Formatting a PHP array for an SQL “IN” clause                                    7个
这是我的代码：

$newMsg="chinu debasish bITto deba PRince's";

    //$curTime=date('G');
    //if(($curTime >= 9) || ($curTime < 21)){
        $chkUname=explode(" ",$newMsg);
        echo "SELECT mobile_hash From ".Chat_USER." WHERE username IN(".implode(",",$chkUname).")";
    //}

以上代码我得到：

SELECT mobile_hash
From chat_users WHERE username IN(chinu,debasish,bitto,deba)

但我希望每个字符串都带有单引号,如：

SELECT mobile_hash
FROM chat_users WHERE username IN('chinu','debasish','bitto','deba')

编辑：这个问题不重复请再次检查我的问题和Formatting a PHP array for an SQL “IN” clause

$imp = "'" . implode( "','",MysqL_escaPE_string($chkUname) ) . "'";

echo "SELECT mobile_hash FROM ".CHAT_USER." WHERE username IN($imp)";