BLOB是一種MySQL資料類型，稱為二進位大對象。正如它的名字它是用來儲存類似MYSQL二進位和VARBINARY類型的、大量的字串資料。
MySQL BLOB分類
MySQL BLOB類型 最大儲存長度(位元組)
TINYBLOB (1)(2 ^ 8)
blob ((2 ^ 16)1)
MEDIUMBLOB ((2 ^ 24)1)
LONGBLOB ((2 ^ 32)1)
在這篇教程中，我們學習如何使用PHP插入和讀取MySQL BLOB欄位。
（PS：T不錯的 PHP Q扣峮：276167802，驗證：csl）
首先,我們需要建立一個MySQL表與一個BLOB欄位。
CREATE TABLE IF NOT EXISTS `output_images` ( `imageId` tinyint(3) NOT NULL AUTO_INCREMENT, `imageType` varchar(25) NOT NULL DEFAULT '', `imageData` mediumblob NOT NULL, PRIMARY KEY (`imageId`))
<?phpif(count($_FILES) > 0) {if(is_uploaded_file($_FILES['userImage']['tmp_name'])) {mysql_connect("localhost", "root", "");mysql_select_db ("phppot_examples");$imgData =addslashes(file_get_contents($_FILES['userImage']['tmp_name']));$imageProperties = getimageSize($_FILES['userImage']['tmp_name']);$sql = "INSERT INTO output_images(imageType ,imageData)VALUES('{$imageProperties['mime']}', '{$imgData}')";$current_id = mysql_query($sql) or die("<b>Error:</b> Problem on Image Insert<br/>" .mysql_error());if(isset($current_id)) {header("Location: listImages.php");}}}?><HTML><HEAD><TITLE>Upload Image to MySQL BLOB</TITLE><link href="imageStyles.css" rel="stylesheet" type="text/css" /></HEAD><BODY><form name="frmImage" enctype="multipart/form-data" action="" method="post"class="frmImageUpload"><label>Upload Image File:</label><br/><input name="userImage" type="file" class="inputFile" /><input type="submit" value="Submit" class="btnSubmit" /></form></div></BODY></HTML>
<?php$conn = mysql_connect("localhost", "root", "");mysql_select_db("phppot_examples") or die(mysql_error());if(isset($_GET['image_id'])) {$sql = "SELECT imageType,imageData FROM output_images WHERE imageId=" . $_GET['image_id'];$result = mysql_query("$sql") or die("<b>Error:</b> Problem on Retrieving Image BLOB<br/>". mysql_error());$row = mysql_fetch_array($result);header("Content-type: " . $row["imageType"]);echo $row["imageData"];}mysql_close($conn);?>
上面的PHP代碼將顯示MySQL BLOB儲存的圖片。從HTML映像標籤我們可以參考這個PHP檔案與相應image_id作為參數。例如：
<img src="imageView.php?image_id=<?php echo $row["imageId"]; ?>" />
<?php$conn = mysql_connect("localhost", "root", "");mysql_select_db("phppot_examples");$sql = "SELECT imageId FROM output_images ORDER BY imageId DESC";$result = mysql_query($sql);?><HTML><HEAD><TITLE>List BLOB Images</TITLE><link href="imageStyles.css" rel="stylesheet" type="text/css" /></HEAD><BODY><?phpwhile($row = mysql_fetch_array($result)) {?><img src="imageView.php?image_id=<?php echo $row["imageId"]; ?>" /><br/><?php}mysql_close($conn);?></BODY></HTML>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
