> 文件，圖片上傳保存到數據庫 ` ~~~ /** * @param $type * @param string $filename * @param bool $is_water * @param int $width * @param int $height * @return array|bool * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @author: LuckyHhy <jackhhy520@qq.com> * @date: 2020/1/13 * @name: upfile * @describe: 上傳文件 */ public function upfile($type, $filename = 'file', $is_water = false, $width = 200, $height = 400) { // 獲取表單上傳文件 例如上傳了001.jpg $file=Request::file($filename); //先檢測MD5和哈希是否存儲過 $md5 = $file->hash('md5'); $sha1 = $file->hash('sha1'); $is_up = $this->checkFileIsUp($md5, $sha1, $this->setting['upload_type']); if($is_up!==true) { //上傳過了 $is_up['code'] = 1; $is_up['msg'] = '上傳成功'; $is_up['info']['name'] = $file->getInfo('name'); return $is_up; } //type 2 七牛 3 oss 1 本地 if($this->setting['upload_type']==2) { //七牛云存儲 $tmp_name=$file->getInfo('tmp_name'); //臨時目錄 //文件后綴 $ext = pathinfo($file->getInfo('name'), PATHINFO_EXTENSION); $config = $this->setting['qiniu_config']; // 構建一個鑒權對象 $auth =new Auth($config['accessKey'],$config['secretKey']); // 生成上傳的token $token = $auth->uploadToken($config['bucket']); // 上傳到七牛后保存的文件名 $up_file_name=date('Ymd') . '/' . md5($tmp_name . time().mt_rand(0,9999)); $key = $up_file_name . '.' .$ext; // 初始化UploadManager類 $uploadMgr = new UploadManager(); list($ret,$err) = $uploadMgr->putFile($token,$key,$tmp_name); if($err !== null){ return array('code'=>0,'msg'=>$err); }else{ $file_path=$config['domain'] . '/' . $key; //保存上傳歷史 $arr=['file_size'=>$file->getInfo('size'),'create_time'=>time(),'filename'=>$file->getInfo('name'),'file_path'=>$file_path,'file_md5'=>$md5,'file_sha1'=>$sha1,'suffix'=>$file->getInfo('type'),'up_type'=>2]; $this->saveUpload($arr); return array('code'=>200,'msg'=>'上傳成功','path'=>$file_path,'savename'=>$up_file_name,'filename'=>$file->getInfo('name'),'info'=>$file->getInfo()); } } else if($this->setting['upload_type']==3) { return ['code' => 0, 'msg' => '上傳方式不存在']; } else { // 移動到框架應用根目錄/uploads/ 目錄下 $info = $file->validate(['size' => $this->setting['size'], 'ext' => $this->setting['ext']])->move(ROOT_PATH.'public'.DS_PROS.'uploads'.DS_PROS.$type); //$info = $file->move(ROOT_PATH . 'public' . DS . 'uploads' . DS . $type); if($info) { $path = '/uploads'.DS_PROS.$type.DS_PROS.$info->getSaveName(); //如果需要添加水印 /*$setting = cache('settings'); if($is_water && $setting['is_watermark'] && $setting['watermark'] && $type = 'images' ){ $image = \think\Image::open(ROOT_PATH . $path); if($image->width() >= $setting['watermark_width'] && $image->height() >= $setting['watermark_height']){ $image->water(ROOT_PATH . $setting['watermark'],$setting['watermark_locate'],$setting['watermark_alpha'])->save(ROOT_PATH . $path); } }*/ $path = str_replace("\\", "/", $path); //保存上傳歷史 $arr = ['file_size' => $info->getSize(), 'up_type' => $this->setting['upload_type'], 'ext' => $info->getExtension(), 'create_time' => time(), 'filename' => $file->getInfo('name'), 'file_path' => $path, 'file_md5' => $md5, 'file_sha1' => $sha1, 'suffix' => $info->getType()]; $getid = $this->saveUpload($arr); return ['code' => 1, 'msg' => '上傳成功', 'save_id' => $getid, 'path' => $path, 'savename' => $info->getSaveName(), 'filename' => $info->getFilename(), 'info' => $info->getInfo(), 'ext' => $info->getExtension()]; } else { return ['code' => 0, 'msg' => $file->getError()]; } } } ~~~ ` > 保存文件和驗證文件 ` ~~~ /** * @param $md5 * @param $sha1 * @param $type * @return array|bool * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\ModelNotFoundException * @throws \think\exception\DbException * @author: hhygyl <hhygyl520@qq.com> * @name: checkFileIsUp * @describe:根據文件MD5和哈希值判斷文件是否上傳過 */ public function checkFileIsUp($md5, $sha1, $type) { $file_data = $this->where(['file_md5' => $md5, 'file_sha1' => $sha1, 'up_type' => $type])->find(); if(empty($file_data)) { return true; } else { return ['path' => $file_data['file_path'], 'info' => ['name' => $file_data['filename'], 'size' => $file_data['file_size'],'save_id'=>$file_data['id'], 'type' => $file_data['suffix']]]; } } /** * @param $arr * @return int|string * @author: hhygyl <hhygyl520@qq.com> * @name: saveUpload * @describe:保存到表里 */ public function saveUpload($arr) { return $this->insertGetId($arr); } ~~~ `