为什么这个查询总是返回hy093错误

a9wyjsp7  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(136)

我的查询总是返回mysql hy093错误,但是为什么呢?我有所有的参数,但仍然不起作用。。。
有人能帮忙吗?

// create PDO params array
$params = [
    ':employee '    => $formData['employee'],
    ':usedFrom'     => $formData['usedFrom'],
    ':usedTill'     => $formData['usedTill'],
    ':company'      => $formData['company'],
    ':costCenter'   => $formData['costCenter'],
    ':vehicle'      => $formData['vehicle'],
    ':vehicleTag'   => $formData['vehicleTag'],
    ':updatedAt'    => $formData['updatedAt'],
    ':ID'           => $formData['ID']
];

// update entry
$return = $db->pquery(
    'UPDATE entry SET employee_id = :employee, used_from = :usedFrom, used_till = :usedTill, company_id = :company, cost_center_id = :costCenter, vehicle_id = :vehicle, vehicle_tag = :vehicleTag, updated_at = :updatedAt WHERE ID = :ID',
    $params
);

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题