thinkphp表單上傳檔案並將檔案路徑儲存到資料庫中-php教程-PHP中文網

首頁

後端開發

php教程

thinkphp表單上傳檔案並將檔案路徑儲存到資料庫中

不言

May 08, 2018 am 11:26 AM

phpthinkphp

這篇文章主要介紹了thinkphp表單上傳文件並將文件路徑保存到資料庫中的相關資料,需要的朋友可以參考下

上傳單個文件，此文以上傳圖片為例，上傳效果如圖所示

建立資料庫upload_img,用於儲存上傳路徑

CREATE TABLE `seminar_upload_img` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`img_name` varchar(255) DEFAULT NULL COMMENT &#39;图片名称&#39;,
`img_url` varchar(255) DEFAULT NULL COMMENT &#39;图片路径&#39;,
`create_time` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

在公用設定檔Common/Conf.php中連接資料庫，並設定位址

return array(
&#39;DB_TYPE&#39;=>&#39;mysql&#39;,
&#39;DB_HOST&#39;=>&#39;127.0.0.1&#39;,
&#39;DB_NAME&#39;=>&#39;seminar&#39;,
&#39;DB_USER&#39;=>&#39;root&#39;,
&#39;DB_PWD&#39;=>&#39;root&#39;,
&#39;DB_PORT&#39;=>3306,
&#39;DB_PREFIX&#39;=>&#39;seminar_&#39;,
&#39;DB_CHARSET&#39;=>&#39;utf8&#39;,
&#39;SHOW_PAGE_TRACE&#39;=>true,
/*地址替换*/
&#39;TMPL_PARSE_STRING&#39;=>array(
&#39;__UPLOAD__&#39;=>__ROOT__.&#39;/Public/Uploads&#39;,
),
);

##在檢視檔Upload/index.html中

<!DOCTYPE html>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
#img{height:22px; border:#000 2px solid}
#button{height:30px; width:100px;}
</style>
</head>
<body>
<p><notemply name="data">
<img  src="/static/imghwm/default1.png"  data-src="__UPLOAD__/{$data[&#39;img_url&#39;]}"  class="lazy"      style="max-width:90%"  style="max-width:90%"/ alt="thinkphp表單上傳檔案並將檔案路徑儲存到資料庫中" >
</notemply></p>
<p class="result" >上传允许文件类型：&#39;jpg&#39;, &#39;gif&#39;, &#39;png&#39;, &#39;jpeg&#39;图像文件后</p><br>
<form action="{:U(&#39;upload/Upload&#39;)}" method="post" enctype="multipart/form-data">
<input type="file" name="image"/>
<input type="submit" value="上传" id="button">
</form>
</body>
</html>

控制器UploadController.class.php中實作上傳檔案

namespace Home\Controller;
use Think\Controller;
class UploadController extends Controller {
public function index() {
$img=M(&#39;upload_img&#39;);
$sel=$img->order(&#39;create_time desc&#39;)->find();
$this->assign(&#39;data&#39;, $sel);
$this->display();
}
public function upload(){
$upload_img=M(&#39;upload_img&#39;);
if(!empty($_FILES)){
//上传单个图像
$upload = new \Think\Upload();// 实例化上传类
$upload->maxSize = 1*1024*1024 ;// 设置附件上传大小
$upload->exts = array(&#39;jpg&#39;, &#39;gif&#39;, &#39;png&#39;, &#39;jpeg&#39;);// 设置附件上传类型
$upload->rootPath = &#39;Public/Uploads/&#39;; // 设置附件上传根目录
$upload->savePath = &#39;&#39;; // 设置附件上传（子）目录
$upload->saveName=array(&#39;uniqid&#39;,&#39;&#39;);//上传文件的保存规则
$upload->autoSub = true;//自动使用子目录保存上传文件 
$upload->subName = array(&#39;date&#39;,&#39;Ymd&#39;);
// 上传单个图片
$info = $upload->uploadOne($_FILES[&#39;image&#39;]);
if(!$info) {// 上传错误提示错误信息
$this->error($upload->getError());
}else{// 上传成功 获取上传文件信息
$img_url=$info[&#39;savepath&#39;].$info[&#39;savename&#39;];
$data[&#39;img_url&#39;]=$img_url;
$data[&#39;img_name&#39;]=$info[&#39;savename&#39;];
$data[&#39;create_time&#39;]=NOW_TIME;
$upload_img->create($data);
$result=$upload_img->add();
if(!$result){
$this->error(&#39;上传失败！&#39;);
}else{
$this->success(&#39;上传成功&#39;);
}
}
}
}
}

相關建議：

ThinkPHP 表單自動驗證運用，thinkphp表單驗證_PHP教學

以上是thinkphp表單上傳檔案並將檔案路徑儲存到資料庫中的詳細內容。更多資訊請關注PHP中文網其他相關文章！

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

PHP中的依賴注入：避免常見的陷阱May 16, 2025 am 12:17 AM

DependencyInjection(DI)inPHPenhancescodeflexibilityandtestabilitybydecouplingdependencycreationfromusage.ToimplementDIeffectively:1)UseDIcontainersjudiciouslytoavoidover-engineering.2)Avoidconstructoroverloadbylimitingdependenciestothreeorfour.3)Adhe

如何加快PHP網站：性能調整May 16, 2025 am 12:12 AM

到Improveyourphpwebsite的實力，UsEthestertate：1）emplastOpCodeCachingWithOpcachetCachetOspeedUpScriptInterpretation.2）優化的atabasequesquesquesquelies berselectingOnlynlynnellynnessaryfields.3）usecachingsystemssslikeremememememcachedisemcachedtoredtoredtoredsatabaseloadch.4）

通過PHP發送大規模電子郵件：有可能嗎？May 16, 2025 am 12:10 AM

是的，ItispossibletosendMassemailswithp.1）uselibrarieslikeLikePhpMailerorSwiftMailerForeffitedEmailsending.2）enasledeLaysBetenemailstoavoidSpamflagssspamflags.3））

PHP中依賴注入的目的是什麼？May 16, 2025 am 12:10 AM

DependencyInjection(DI)inPHPisadesignpatternthatachievesInversionofControl(IoC)byallowingdependenciestobeinjectedintoclasses,enhancingmodularity,testability,andflexibility.DIdecouplesclassesfromspecificimplementations,makingcodemoremanageableandadapt