php - 将 php 字符串与列进行比较..什么不匹配？

Question

我有一个 php 逗号分隔的字符串$string = (x,y,z)

我在 mysql 中有一个列，其中包含项目 (y,z)

我想创建一个包含字符串中但不在表列中的项目的数组...

 $cid = "'" . str_replace(",", "','", $cid) . "'";

    $query = mysql_query("SELECT save_key FROM saved WHERE save_key IN ($cid)");

    while ($result = mysql_fetch_assoc($query)){
        $array[] = $result['save_key'];
    }

    $cid_array = explode(',',$cid);

    $dif = array_diff($cid_array, $array);

    print_r($dif);

输出:

查询数组 ( [0] => O45527 [1] => P97387 [2] => Y49437 )

来自 array_dif 的数组 ( [0] => 'P97387' [1] => 'O45527' [2] => 'Y49437' )所有项目都是相同的权利..

print_r($dif); 应该返回 array()

Answer 1

数组不一样，因为您向 $cid 添加了周围的引号。

$quoted_cid = "'" . str_replace(",", "','", $cid) . "'";

$query = mysql_query("SELECT save_key FROM saved WHERE save_key IN ($quoted_cid)");

while ($result = mysql_fetch_assoc($query)){
    $array[] = $result['save_key'];
}

$cid_array = explode(',',$cid);

$dif = array_diff($cid_array, $array);

print_r($dif);