php - 如何在 codeIgniter 中正确地进行查询？

Question

如何在 PHP 中正确地进行查询？

$where = "MONTH('leave_date') = ".$data['currM']."' AND YEAR('leave_date') = '".$data['currY']."' AND agent_id = '".$list->ps_crm_agent_id;

数据库错误；

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' AND YEAR('leave_date') = '2019' AND agent_id = '7' at line 3

SELECT `ps_crm_agent_leaves`.* FROM `ps_crm_agent_leaves` WHERE 
MONTH('leave_date') = 11' AND YEAR('leave_date') = '2019' AND `agent_id` = '7

Answer 1

你忘记了一些单引号

$where = "MONTH('leave_date') = '".$data['currM']."' AND YEAR('leave_date') = '".$data['currY']."' AND agent_id = '".$list->ps_crm_agent_id."'";
                                ^                                                                                                            ^      
                               here                                                                                                     here