thinkphp a form to upload a file and save the file path to the database

This article mainly describes the thinkphp form upload files and save the file path to the database of relevant information, the need for friends can refer to the following

Upload a single file, this article to upload pictures as an example, upload effect

Create database upload_img to save the upload path

CREATE TABLE ' seminar_upload_img ' (' id ' int (one) not null auto_increment, ' img_name ' varchar (255) DEFAULT NULL COMMENT ' picture name ', ' img_url ' varchar (255) DEFAULT NULL COMMENT ' picture path ', ' Create_time ' text,primary KEY (' id ')) engine=innodb auto_increment =23 DEFAULT Charset=utf8;

Connect to the database in public profile common/conf.php and configure the address

Return Array (' db_type ' = ' mysql ', ' db_host ' = ' 127.0.0.1 ', ' db_name ' = ' seminar ', ' db_user ' = ' root ', ' db_ ' PWD ' = ' root ', ' db_port ' =>3306, ' db_prefix ' = ' seminar_ ', ' db_charset ' = ' utf8 ', ' show_page_trace ' = true,/* Address Replace */' tmpl_parse_string ' =>array (' __upload__ ' =>__root__. ') /public/uploads ',),);

View files in upload/index.html

<! DOCTYPE html>

Implement upload file in controller UploadController.class.php


Namespace Home\controller;use Think\controller;class Uploadcontroller extends Controller {public Function index () {$img =m (' upload_img '); $sel = $img->order (' create_time desc ')->find (); $this->assign (' data ', $sel); $this Display ();} Public function upload () {$upload _img=m (' upload_img '), if (!empty ($_files)) {//upload single image $upload = new \think\upload ();// Instantiate upload class $upload->maxsize = 1*1024*1024;//Set attachment upload size $upload->exts = array (' jpg ', ' gif ', ' PNG ', ' jpeg ');//Set attachment upload type $ Upload->rootpath = ' public/uploads/'; Set the attachment upload root directory $upload->savepath = '; Set attachments Upload (sub) directory $upload->savename=array (' uniqid ', ');//Upload file Save rule $upload->autosub = true;//automatically save upload file using subdirectory $ Upload->subname = Array (' Date ', ' Ymd ');//upload single picture $info = $upload->uploadone ($_files[' image '); if (! $info) {// Upload error message $this->error ($upload->geterror ());} else{//Upload successfully uploaded file information $img_url= $info [' Savepath ']. $info [' Savename ']; $data [' Img_url ']= $img _url; $data [' Img_name ']=$ info[' savename '; $data [' Create_time ']=now_time; $upload _IMG-&GT;CREate ($data); $result = $upload _img->add (), if (! $result) {$this->error (' Upload failed! ');} else{$this->success (' upload successful ');}}}}