dougou8552 2019-02-19 09:36
浏览 63

MySQL Medoo强制数据类型

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);
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 LiBeAs的带隙等于0.997eV,计算阴离子的N和P
    • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
    • ¥15 来真人,不要ai!matlab有关常微分方程的问题求解决,
    • ¥15 perl MISA分析p3_in脚本出错
    • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
    • ¥15 ubuntu虚拟机打包apk错误
    • ¥199 rust编程架构设计的方案 有偿
    • ¥15 回答4f系统的像差计算
    • ¥15 java如何提取出pdf里的文字?
    • ¥100 求三轴之间相互配合画圆以及直线的算法