php - 如何在 Zend Framework 查询之间放置

Question

任何人都可以根据 ZF 更正此查询。我遇到用户选择不同参数并在此基础上进行查询的情况

$user = new Zend_Session_Namespace('user');
$phone_service_id = $user->phone_service_id;

$start_date = $this->_getParam('start_date'); //02/07/2012
$end_date = $this->_getParam('end_date');     //02/21/2012
$option_call_log = $this->_getParam('option_call_log'); //COLUMN NAME
$option_call_log_asc_desc = $this->_getParam('option_call_log_asc_desc');  //ASC/DESC

我想我在查询中有语法错误，请看这里

$select = $DB->select()
         ->from('CALL_LOG', array('caller_name','call_number','call_start_time','call_duration','call_direction'))
         ->where('phone_service_id = ?', $phone_service_id)
         ->where(DATE_FORMAT(date_created, '%m/%d/%Y') BETWEEN  $start_date  AND $end_date)
         ->order($option_call_log $option_call_log_asc_desc)
         ->limit(0,9);

这是怎么回事？？

Answer 1

BETWEEN子句是包含的，正确的做法如下:

$select = $DB->select()
         ->from('CALL_LOG', array('caller_name','call_number','call_start_time','call_duration','call_direction'))
         ->where('phone_service_id = ?', $phone_service_id)
         ->where("DATE_FORMAT(date_created, '%m/%d/%Y') >= ?",  $start_date)
         ->where("DATE_FORMAT(date_created, '%m/%d/%Y') <= ?",  $end_date)
         ->order("".$option_call_log." ".$option_call_log_asc_desc)
         ->limit(0,9);

试试上面的代码，你的问题就解决了。