yii连接数据库添加数据--demo

最新推荐文章于 2024-03-19 12:06:53 发布

awake720

最新推荐文章于 2024-03-19 12:06:53 发布

阅读量1k

点赞数

分类专栏： yii2-demo

本文链接：https://blog.csdn.net/awake720/article/details/79782936

版权

yii2-demo 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

yii连接数据库添加数据--demo

<?php
/**
 * Created by PhpStorm.
 * User: kkk
 * Date: 2018/4/1
 * Time: 21:11
 */

namespace app\modules\index\models;
use yii\db;
use yii;
use yii\base\Model;

class MsgModel extends Model
{
    public function doctor_info($data){
        $db = Yii::$app->db;
        $transaction = $db->beginTransaction();
        try {
            $res = $db->createCommand()->batchInsert(
                'yii_release',//这是表名
                ['name','doc_tel','doc_sex','doc_hos','doc_admini','doc_job'],//字段
                [[$data['name'],$data["tel"],$data["sex"],$data["hos"],$data["admin"],$data["job"]]]//数组，如果单独有一组数据，必须在一组数据外层嵌套一个[]
            )->execute();
            $transaction->commit();
            return $res;
        } catch(\Exception $e) {
            $transaction->rollBack();
            throw $e;
        }
    }
}