php - 1064 预约 Pro 出错

Question

我是这些方面的新手，我对“预约专业组件”有疑问

当我尝试在前端进行“预订”时，它向我显示错误

错误是:

1064 YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR '' AT LINE 3 SQL=SELECT MAX(ORDERING) FROM F3CBW_SV_APPTPRO3_BOOKOFFS WHERE ID_BOOKOFFS =

代码是:

{
    $query = "SELECT #__users.name FROM #__users JOIN #__sv_apptpro3_bookoffs ON #__sv_apptpro3_bookoffs.checked_out = #__users.id ".
    " WHERE #__sv_apptpro3_bookoffs.id_bookoffs = ". $this->_id_bookoffs;           
    $this->_db->setQuery($query);
    $locked_by = $this->_db->loadResult();
    return $locked_by;
}

请帮助我，我找不到语法错误。谢谢

Answer 1

根据错误消息判断 $this->_id_bookoffs 没有值，并且在查询中生成无效的 WHERE 子句。您应该在执行查询之前验证它是否具有有效值。