php - Medoo MySQL 不读取变量

Question

我正在使用 Medoo MySQL 框架，但在 WHERE 语句中使用 IN 时遇到了这个问题:

$test = '1,2,3,4';

$count = $database->count("products", [
    "AND" => [
        "category_id" => $category['id'],
        "id" => [$test]
    ]
]);

计数结果应该是 4，但我得到 1。但是:

$count = $database->count("products", [
    "AND" => [
        "category_id" => $category['id'],
        "id" => [1,2,3,4]
    ]
]);

给了我 4 的正确结果。有什么想法吗？提前致谢!

Answer 1

试试这个...

$test = array(1,2,3,4);

$count = $database->count("products", [
    "AND" => [
        "category_id" => $category['id'],
        "id" => $test // variable without []
    ]
]);