- 普通 - 未处理
2.1和2.0我都用于不同项目研发。其中2.1给我感觉出现这个问题的次数最多,2.0比较少。
举例:
模型:
class click_b_qqModel extends commonModel {
protected $dbName = 'sites_guangxi_b';
protected $tableName = 'click_b_qq';
public function getList($returnCount = true, $page = '', $numPerPage = '', $where = '') {
if ($returnCount) {
return $this->where ( $where )->count ();
}
return $this->where ( $where )->limit ( $page . ',' . $numPerPage )->order ( 'b_id desc' )->findAll ();
}
}
然后控制器里这样打:
M('sites_guangxi_b.click_b_qq')->find($_GET['id']);
echo m()->getlastsql();
D('b_click_qq')->find ( $_GET ['id'] );
echo m()->getlastsql();
显示结果:
SELECT * FROM sites_guangxi_b.click_b_qq WHERE b_id='13' LIMIT 1
SELECT * FROM sites_guangxi_b.click_b_qq WHERE id='13' LIMIT 1
表结构:
CREATE TABLE `click_b_qq` (
`b_id` int(11) NOT NULL AUTO_INCREMENT,
`b_url` varchar(100) NOT NULL,
`b_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`b_ip` varchar(15) NOT NULL,
`b_qq` varchar(15) NOT NULL,
`b_browser` varchar(30) NOT NULL,
PRIMARY KEY (`b_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='企业QQ 点击记录'
问题:D() 有时无法获得PK
