PHP operation in MySQL blob field method

Source: Internet
Author: User
This article mainly introduces the PHP operation of the Blob field in MySQL method, combined with specific examples of PHP using MySQL blob field to store news content and pictures of the relevant operation skills, the need for friends can refer to the next

The example in this article describes how PHP operates BLOB fields in MySQL. Share to everyone for your reference, as follows:

1. The type of BLOB field in MySQL

A field of BLOB type is used to store binary data.

In MySQL, BLOBs are a series of types, including: Tinyblob, BLOBs, Mediumblob, Longblob, the only difference between these types is the maximum size of the storage file.

MySQL four types of blobs

tinyblob: Maximum 255 bytes
Blob: 65K max
mediumblob: 16M max
longblob: 4G max

Note: If you store a file that is too large, the performance of the database will degrade a lot.

2. PHP Operation Blob case

(1) Operation of news content


<?php  mysql_connect ("localhost", "root", "password");//Connect Database  mysql_select_db ("db");//Select Database  Data insertion:  $CONTENT = "Test content";  $CONTENT for news content  $COMPRESS _content = Bin2Hex (gzcompress ($CONTENT));  $result =mysql_query ("INSERT INTO News" value (' $COMPRESS _content ') ");//data is inserted into the database news table  //show:  $query = "Select data from testtable where Filename= $filename";  $result = mysql_query ($query);  $COMPRESS _content= @gzuncompress ($result ["compress_content"]);  echo $COMPRESS _content;? >

(2) Storing pictures


<?phpmysql_connect ("localhost", "root", "password");//Connect to database Mysql_select_ DB ("database"); Select Database//store: $filename = ""//Fill in picture path $compress_content = Addslashes (Fread (fopen ($filename, "R"), FileSize ($filename)) )///Open file and normalize data into variable $data $result=mysql_query ("INSERT INTO News (' $COMPRESS _content ')");// Data inserted into the Database test table//Show: Ob_end_clean (); Header ("Content-type:image/gif"); $query = "Select data from testtable where Filename= $filename"; $result = mysql_query ($ query); Echo $result ["compress_content"];? 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.