tp5动态建表

//动态建表
$table = 'order_'.date('Y',time());
$sql = "create table ".$table."(`order_id` int(11) unsigned not null auto_increment primary key comment '订单id',
`order_num` varchar(32) not null comment '订单号',
`order_money` decimal(10,2) not null comment '订单总金额',
`pay_money` decimal(10,2) not null comment '用户实际支付的金额',
index order_num(order_num)
 )engine=innodb default charset=utf8;";
$res = Db::execute($sql);

结果$res = 0 表示成功  $res = 1表示失败

database.php文件中的sql_explain设置为true

tp5监听sql 监听要写在前面

  //TP5监听sql
       $res = Db::listen(function($sql,$time,$explain){
           echo $sql.'['.$time.']';
            dump($explain);
        });
        //tp5事务操作
     $res =  Db::transaction(function(){
           Db::table('user')->where('name','qfx')->update(['header_img'=>'fsdf.jpg1']);
           Db::table('user')->where('name','qin')->update(['header_img'=>'fdsd2.jpg1']);
       });