PHP Methods for manipulating BLOB fields in MySQL

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

Specific 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 database mysql_select_db ("databases"); 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"];? >

Related recommendations:

How to remove a blob image from MySQL

JavaScript-How to parse a video address that starts with a blob in a video tag

Java-mysql The BLOB type of the read problem!

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.