Example of uploading images to the database and displaying them on the page implemented in Vue

This article mainly introduces the function of uploading pictures to the database and displaying them on the page implemented by vue. It analyzes the database operation and page picture display related operation skills based on vue.js in the form of examples. Friends in need can refer to the following

The example of this article describes the function of uploading images to the database and displaying them on the page implemented by vue. Share it with everyone for your reference, the details are as follows:

1. Click to upload a picture, and the picture selection option box will pop up.

Page code:

<p class="form-signin-heading" id="btnUpload" @change="upload">上传图片</p>
<input type="file" name="avatar" id="avatar" multiple="multiple" @change="upload">
<img src="/static/imghwm/default1.png"  data-src="&#39;http://localhost:8888&#39;+item.photos_url"  class="lazy"  : alt=""/>

Since we want to set the style of the uploaded image, we hide the input and do the following operations to send the click event of the input to the p box:

mounted: function () {
 var upload = document.getElementById("btnUpload");
 var avatar = document.getElementById("avatar");
 upload.onclick =function(){
  avatar.click(); //注意IE的兼容性
 };
}

2. Add two files to the controller layer of the api interface and name them yourself, such as:

upFile.js

let multer=require('multer');
let storage = multer.diskStorage({
  //设置上传后文件路径，uploads文件夹会自动创建。
  destination: function (req, file, cb) {
    cb(null, './public/uploads')
  },
  //给上传文件重命名，获取添加后缀名
  filename: function (req, file, cb) {
    let fileFormat = (file.originalname).split(".");
    cb(null, file.fieldname + '-' + Date.now() + "." + fileFormat[fileFormat.length - 1]);
  }
});
//添加配置文件到multer对象。
let upload = multer({
  storage: storage
});
module.exports = upload;

upFileController.js

var muilter = require('./upFile.js');
//multer有single()中的名称必须是表单上传字段的name名称。
var upload=muilter.single('file');
function dataInput(req, res) {
  upload(req, res, function (err) {
    //添加错误处理
    if (err) {
      return console.log(err);
    }
    //文件信息在req.file或者req.files中显示。
    let photoPath = req.file.path;
    photoPath = photoPath.replace(/public/,"");//将文件路径中的public\去掉，否则会和静态资源配置冲突
    //将photoPath存入数据库即可
    console.log(photoPath);
    res.send(photoPath);
  });
}
module.exports = {
  dataInput
};

3. On the page Save the address of the picture to the database

upload: function (e) {
    var that = this;
    let formData = new window.FormData();
    let file = e.target.files[0];
    formData.append('file',file);//通过append向form对象添加数据
    //利用split切割，拿到上传文件的格式
    var src = file.name,
     formart = src.split(".")[1];
    //使用if判断上传文件格式是否符合
    if (formart == "jpg" || formart == "png" ||
     formart == "docx" || formart == "txt" ||
     formart == "ppt" || formart == "xlsx" ||
     formart == "zip" || formart == "rar" ||
     formart == "doc") {
     //只有满足以上格式时，才会触发ajax请求
     this.$axios.post(this.$api.personalCenter.upFile,formData).then(function (res) {
      that.upFileData = res.data;
     }).then(function (res) {
      var params = {
       photos_url: that.upFileData,
       photo_des: ''
      };
//      console.log(params.photos_url,'photos_url')
      that.$axios.post(that.$api.personalCenter.wallAdd,qs.stringify(params)).then(function (res) {
       console.log(res.data);
       that.$options.methods.imgList.bind(that)();
      }).catch(function (err) {
       console.log(err);
       console.log("请求出错");
      })
     })
    } else {
     alert("文件格式不支持上传");
    }
}

The above is what I compiled for everyone. I hope it will be helpful to everyone in the future.

Related articles:

Instances of spirngmvc js passing complex json parameters to controller

##Vue.js form control operation summary

JS method of passing array parameters to the background controller

The above is the detailed content of Example of uploading images to the database and displaying them on the page implemented in Vue. For more information, please follow other related articles on the PHP Chinese website!