[FAQ] 如何將圖片存放於MySQL中？

[cosa]

Step 1.
建立資料庫test

Step 2.
建立表格
binary_data CREATE TABLE binary_data ( id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY, description CHAR(50), bin_data LONGBLOB, filename CHAR(50), filesize CHAR(50), filetype CHAR(50) );

Step 3.
 利用 store.php 寫入圖片 store.php 程式碼
此段內容 請參考Databse 的 SOP..可至檔案下載處下載
File Description:
 
File to upload/store in database:
 
 
Step 4.
利用 store.php 取出圖片 getdata.php 程式碼 if($id) { // you may have to modify login information for your database server: @MYSQL_CONNECT("localhost","root","YOUR_PASSWORD"); @mysql_select_db("test"); $query = "select bin_data,filetype from binary_data where id=$id"; $result = @MYSQL_QUERY($query); $data = Base64_Decode(@MYSQL_RESULT($result,0,"bin_data")); $type = @MYSQL_RESULT($result,0,"filetype"); Header( "Content-type: $type"); echo $data; }; ?>