php - 明显不工作

Question

1.

select sub_category from add_skills where skillax_id='28'

2.

select distinct skillax_id from add_skills where sub_category in('Nutrition 101','All About Juicing','Make Up 101')

上述方式工作不同，但当我使用...

select distinct skillax_id from add_skills where sub_category in('".$na['sub_category']."')

喜欢这个明显不起作用

select * from users where skillax_id in('28','23','5')

Answer 1

如果 id 为整数值，则可以使用 php 的 implode 函数。见下文:

<?php
$query = "select distinct skillax_id from add_skills where sub_category in(".implode(",",$na['sub_category']).")";
?>

如果有字符串作为类别名称，则使用下面的代码。

<?php
$str = "";
if(!empty($na['sub_category']))
{
    foreach($na['sub_category'] as $key=>$val)
    {
        if($str == "")
            $str .= "'".$val."'";
        else
            $str .= ",'".$val."'";
    }
    $query = "select distinct skillax_id from add_skills where sub_category in(".$str.")";
}
?>