Tuesday, July 27, 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