//动态创建数据表
public function testCreateTable(){
$tableName = config('database.prefix').'think_order_'.date('Ymd');
$isTable = Db::query('SHOW TABLES LIKE '."'".$tableName."'");
if($isTable){
//已存在
}else{
//未存在
$time=date('Ymd');
$sql = <<<sql
CREATE TABLE IF NOT EXISTS `cmj_think_order_$time`(
`order_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`out_trade_no` varchar(255) NOT NULL,
PRIMARY KEY (`order_id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
CHECKSUM=0
ROW_FORMAT=DYNAMIC
DELAY_KEY_WRITE=0
;
sql;
$a=Db::execute($sql);
}
}
thinkphp5 动态创建数据表
最新推荐文章于 2023-12-10 12:20:09 发布