I'm currently trying to get rows from my MySQL DB in a specific order.
Therefore, I found a query like this useful:
SELECT * FROM tbl_items WHERE id IN (130,129) ORDER BY FIELD(ID, 130,129)
When I run this directly in MySQL, everything is working fine.
Now in PHP, I'm using the database framework Medoo.
What I do there is running this query:
$asservate = $database->query("SELECT *
FROM tbl_items
WHERE ID in (:ids)
ORDER BY FIELD(ID,:ids)",
[":ids" => intval($items)])
->fetchAll();
What this query results in, when I echo the last executed query, is the following:
SELECT * FROM tbl_items WHERE ID in ('129,130') ORDER BY FIELD(ID,'129,130')
So the values are entered as strings and that seems to be the problem. The result is, that I only get row number 129 returned, no other one.
Is there any idea how I could force medoo to not enter the values with '
or how I could force MySQL to still execute the query, even with the '
there?
Thanks in advance!
EDIT:
Here's the code for the query
-function of Medoo:
public function query($query, $map = [])
{
if (!empty($map))
{
foreach ($map as $key => $value)
{
switch (gettype($value))
{
case 'NULL':
$map[ $key ] = [null, PDO::PARAM_NULL];
break;
case 'resource':
$map[ $key ] = [$value, PDO::PARAM_LOB];
break;
case 'boolean':
$map[ $key ] = [($value ? '1' : '0'), PDO::PARAM_BOOL];
break;
case 'integer':
case 'double':
$map[ $key ] = [$value, PDO::PARAM_INT];
break;
case 'string':
$map[ $key ] = [$value, PDO::PARAM_STR];
break;
}
}
}
return $this->exec($query, $map);
}