后台直接操作数据库,实现新建、编辑、删除数据表,新建、编辑、删除数据库字段,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);
转载请说明出处
UE资源网 » Thinkphp5新建、编辑、删除数据表,数据库操作源码
UE资源网 » Thinkphp5新建、编辑、删除数据表,数据库操作源码