php-think_php5.1-插入数据
插入多条数据
$dataAll = [
[
'uid' => '11113111',
'username' => '辉月',
'gender' => '男',
'email' => '1234234@qq.com',
'price' => 1,
'details' => 23,
'create_time' => date('y-m-d H:i:s')
],
[
'uid' => '11112111',
'username' => '辉月',
'gender' => '男',
'email' => '1234234@qq.com',
'price' => 1,
'details' => 23,
'create_time' => date('y-m-d H:i:s')
]
];
try {
Db::name('user')->insertAll($dataAll);
return "插入成功" . Db::getLastInsID();
} catch (Exception $e) {
return "插入失败";
}
插入单条数据
$data = [
'uid' => '11113111',
'username' => '辉月',
'gender' => '男',
'email' => '1234234@qq.com',
'price' => 1,
'details' => 23,
'create_time' => date('y-m-d H:i:s')
];
try {
Db::name('user')->insert($data);
return "插入成功" . Db::getLastInsID();
} catch (Exception $e) {
return "插入失败";
}