Medoo MySQL not reading variable

Question

I'm using the Medoo MySQL framework but ran into this issue when using IN within a WHERE statement:

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

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

The count result should be 4, but I'm getting 1. However:

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

Gives me the correct result of 4. Any ideas? Thanks in advance!

my guess is `$test = '1,2,3,4';` in `"id" => [$test]` is evaluating to array with 1 string, ie. `['1,2,3,4']` or `id[0] = `1,2,3,4`, instead of an array with 4 values. — Sean, Mar 29 '16 at 05:30

jkrav · Answer 1 · 2016-07-25T15:41:28.467

1

Try this...

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

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

edited Jul 25 '16 at 15:41

answered Jul 25 '16 at 15:16

jkrav

11
2

score 0 · Answer 2 · answered Sep 17 '17 at 10:07

0

$test = '1,2,3,4'; is a string. To convert it as array, you need to use:

$test = explode(',', '1,2,3,4');

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

answered Sep 17 '17 at 10:07

Angolao

986
1
15
27

score 0 · Answer 3 · answered Oct 04 '17 at 07:04

0

The following solution has been posted here: https://github.com/catfan/Medoo/issues/637

$values = '2,123,234,54';

$database->select("account", "user_name", [
    "OR" => [
        "user_id" => explode(',',$values)
    ]
]);

answered Oct 04 '17 at 07:04

Dagobert Debug

1

Medoo MySQL not reading variable

3 Answers3