更多會員限定文章可以到patreon觀看
完整code可以到以下gist
Client端HTML
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <style> img { width: 150px; } </style> </head> <body> <input type="file" id="file-uploader" accept="image/png" multiple="multiple"/> <img id='preview'> </body> </html>
- input tag
- type設成file,讓使用者能選擇檔案
- accept設定使用者能選的格式,如果要所有照片格式就改成
image/*
- multiple讓使用者能選擇多個檔案
Client端JS
我們會用JSON來傳遞資料(也可以用form-data)
取得使用者選擇的照片
讀進來的每個檔案會是blob(Binary Large Object)
const fileUploader = document.querySelector('#file-uploader'); fileUploader.addEventListener('change', (e) => { console.log(e.target.files); // get list of file objects });
e.target.files
是fileList
將照片轉成base64 string
function display_img(curFiles) { const curFile = curFiles[0]; const reader = new FileReader(); // 這會在readAS後才執行 reader.onload = function (e) { // console.log('file:', e.target.result); // base64 document.querySelector('#preview').src = e.target.result; }; // to data url reader.readAsDataURL(curFile); }
img.src
能顯示url with base64
將blob轉成array buffer
相較於buffer, blob保留了照片的資訊,像是檔名、MIME type等
function blob2buffer(blob) { return new Promise((resolve, reject) => { var arrayBuffer; var fileReader = new FileReader(); fileReader.onload = function (event) { arrayBuffer = event.target.result; resolve(arrayBuffer); }; fileReader.readAsArrayBuffer(blob); return arrayBuffer; }); }
先將blob轉成buffer,方便後續建成array
將array轉成字串post到server
buffer不能直接操作,要先轉成指定type的array
arrayBuffer = await blob2buffer(pic); fetch(url, { method: 'POST', // flask need to set header of json headers: { 'content-type': 'application/json' }, body: JSON.stringify({ item_id: 1, format: 'png', img: Array.from(new Uint8Array(arrayBuffer)), }), })
轉成array前要先將buffer轉成typed array
讀取server端傳回來的array
產生blob的url (不同於前面產base64的fileReader)
function display_arr_img(arr) { document.querySelector('#preview').src = URL.createObjectURL(new Blob([new Uint8Array(arr)], {type: "image/png"})); }
將array轉回typed array,再將其變回blob
Server端API
這裡我們用python + flask作為例子
DataBase
這裡我們用MySQL,然後照片的欄位type是blob,要注意blob有分可以存的size
-
TINYBLOB
: maximum length of 255 bytes -
BLOB
: maximum length of 65,535 bytes => 64kb -
MEDIUMBLOB
: maximum length of 16,777,215 bytes -
LONGBLOB
: maximum length of 4,294,967,295 bytes
連接到資料庫
import pymysql connection = pymysql.connect(host='localhost', user='root', password='password', db='db01', charset='', cursorclass=pymysql.cursors.DictCursor)
注意pymysql不支援connection string
Python Code
所需套件在requirements.txt內
存到blob的好處是不會讓照片被額外index (會導致檔案大小增幅30%)
@app.route('/upload/json/img_raw', methods=['POST']) def raw_img(): json_data = flask.request.json # save to db with connection.cursor() as cursor: sql = "UPDATE table1 SET `img_raw`=%s WHERE id=%s" try: # img現在是list, 可以用json string/ byterarray/ base64存進資料庫 cursor.execute(sql, (json.dumps(json_data['img']), json_data['item_id'])) connection.commit() except Exception as err: connection.rollback() return flask.jsonify({'err': err}) # get a picture sql = "SELECT * FROM table1" cursor.execute(sql) result = cursor.fetchone() r = result[0]['img_raw'] r = json.loads(r.decode()) # utf-8, 也可用ascii return flask.jsonify({'img': r})
存進mysql blob欄位後,會變成binary object
-
json.dumps(json_data['img']
- 我們要將List轉成json style的string才能存進資料庫
-
json.loads(r.decode())
- 存資料庫拿出來的會是binary object,我們要先將其轉回字串
- 然後再將字串 parse回list
Top comments (0)