后台直接操作数据库,实现新建、编辑、删除数据表,新建、编辑、删除数据库字段,Thinkphp5数据库管理操作源码

1、使用前请配置虚拟主机;将整个文件放在根目录下面;
2、数据库导入;
3、使用框架:thinkphp5.1;
4、版本要求请根据框架要求的版本配置。
//拼接SQL语句
$sql = "CREATE TABLE IF NOT EXISTS `$tablename` (" ;
$key_num;
$numbers = 0;
foreach($fields as $key => $val){
if($val['length']==''){
$this->error('字段长度不能为空!','add','',1);
}
$name = $val['name'];
$type = $val['type'];
$notes= $val['notes'];
if(isset($val['key'])){
++$numbers;
$leng = $val['length'];
$sql .= " `$name` $type($leng) NOT NULL AUTO_INCREMENT COMMENT '$notes',";
$key_num = $key;
}else{
if($val['length']!=''){
$leng = $val['length'];
$sql .= " `$name` $type($leng) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '$notes',";
}else{
$sql .= " `$name` $type CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '$notes',";
}
}
}
if($numbers>1){
$this->error('主键只能有一个!','add','',1);
}else if($numbers==0){
$this->error('必须要选择一个主键!','add','',1);
}
$key = $fields[$key_num]['name'];
$sql .= "PRIMARY KEY (`$key`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '$tablenotes' ROW_FORMAT = Dynamic;";
$creat = Db::execute($sql);
系统已开启自动识别垃圾评论机制,识别到的自动封号,下载出错或者资源有问题请联系全栈客服QQ 1915635791