次文为代码笔记,如果能帮助到你,不胜荣幸!
表结构:
CREATE TABLE `tb_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键ID',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '名称',
`age` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '年龄',
`email` varchar(100) NOT NULL DEFAULT '' COMMENT '邮箱',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表'
代码清单:
public function actionAddUpdate() {
$user = new User;
$user->name = 'lee';
$user->age = 30;
$user->email = 'ruxing.li@qq.com';
$row = false;
try {
// 执行添加
$row = $user->save();
} catch (Exception $ex) {
// 标注为修改,须设置主键
$user->isNewRecord = false;
$user->id = 1;
$row = $user->save();
}
var_dump($row);
}
提示:tb_user 表须生成 Model 文件。