app.get('/getpicture',(req,res)=>{
console.log(req.query) // 客户端请求的传参data数据
const openid=req.query.openid
var connection=mysql.createConnection({
host:'',
port: 3306, //端口号
user:'w',
password:'123456',
database:'w'
})
connection.connect();
connection.query("SELECT pic FROM picture WHERE num=1",function(error,results,fields){
if(error) console.log(error);
res.json(results)
console.log(results)
})
connection.end();
})
三个思路:
(1)传base64给后端,由后端来解决解析并下载图片
(2)参考这个文章:https://www.pudn.com/news/62849c5febb030486dae8734.html
(3) 通过这个试试:wx.base64ToArrayBuffer(base64image)