1 使用CodeIgniter字段值有汉字,按照字母顺序升序排序(规则:空在前,然后是纯字母,最后是汉字)
<!-- lang: php -->
$this->db->order_by('CONVERT(brand USING gbk ) COLLATE gbk_chinese_ci','asc');
2 php字符串与日期的处理
<!-- lang: php -->
var $brand['registerdate'] = '2013-05-26 18:00:00';
echo date('Y-m-d',strtotime($brand['registerdate']));//结果是2013-05-26
3 字符串替代
<!-- lang: php -->
echo str_ireplace(array("\r\n","\n","\r"),"</p><p>",$data['certificateInfo']['description']);