php - 如何在查询运行之前删除查询中的字符

Question

关闭。此题需要 details or clarity 。目前不接受答案。

---

想要改进这个问题吗？通过 editing this post 添加详细信息并澄清问题.

已关闭 9 年前。

Improve this question

这是我的查询

    $sql = "SELECT * FROM contact where isdeleted = 0  ";



          if ($language !="" && $language !="Empty" ){



                    $language_exp = explode(',', $language);
         $sql .= " INNER JOIN contactlanguage ON contact.id = contactlanguage.contactid
    INNER JOIN language ON contactlanguage.languageid = language.id where isdeleted = 0 AND language.language in ('".implode("', '", $language_exp)."') "; 

                }

 if ($contactgroup !="" && $contactgroup !="Empty" ){



    $contactgroup_exp = explode(',', $contactgroup);
    $sql .= " AND contactgroup in ('".implode("', '", $contactgroup_exp)."')";

    }

如果我运行该函数，查询结果如下

SELECT * FROM contact where isdeleted = 0 INNER JOIN contactlanguage ON contact.id = contactlanguage.contactid INNER JOIN language ON contactlanguage.languageid = language.id where isdeleted = 0 AND language.language in ('English', 'Arabic', '')

这里isdeleted = 0是两次谁能告诉我如何在内部条件之前以及查询运行之前删除 isdeleted = 0 ，谢谢

Answer 1

简单的解决方案是:

$sql = "SELECT * FROM contact";
if ($language !="" && $language !="Empty" ){
    //...
    $sql .= " INNER JOIN .....";
}
else {
    $sql .= " where isdeleted = 0";
}

// run query...
$query = mysql_query($sql);