Monday, July 26, 2010

Zend_db 乱码问题

$params = array (
'host' => 'localhost',
'username' => 'root',
'password' => '',
'dbname' => 'gestboard'
);
$db = Zend_Db::factory('PDO_MYSQL', $params);
$db->query('SET NAMES UTF8'); //这句是关键
$select = $db->select();
$select->from('depense','*');
$select->join('depense_project','depense.id_project = depense_project.id','project_name');
$select->join('depense_type_charge','depense.id_type_charge = depense_type_charge.id','type_charge');
$select->where('id_user_info =?',$idvalue);
$select->where('EXTRACT(YEAR FROM date)=?', $year);
$select->where('EXTRACT(MONTH FROM date)=?', $month);
$select->order('date DESC');

$sql = $select->__toString();
$this->view->listDepense = $db->fetchAll($sql);



另见:http://www.z-f.fr/forum/viewtopic.php?id=81

0 评论:

Post a Comment