Home >Backend Development >PHP Tutorial >Save and export images with PHP and MySQL_PHP Tutorial
Save and export images with PHP and MySQL_PHP Tutorial
- WBOYOriginal
- 2016-07-13 17:48:16746browse
In the process of designing and making websites, sometimes it is more convenient to save images to a database than to save them as files. This golden combination with MySQL can easily achieve the above functions. In this article, we will introduce readers to how to save pictures to the MySQL database and how to display pictures in the database.
Set up database
The difference between the text or integer type fields we usually use in the database and the fields that need to be used to save pictures lies in the amount of data that needs to be saved. MySQL database uses special fields to save large amounts of data, and the data type is BLOB.
MySQL database defines BLOB as follows: The BLOB data type is a large binary object that can store a variable amount of data. There are four types of BLOB, namely TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB. The difference lies in the maximum data length that each can save.
After introducing the data types we need to use, we can use the following statements to create a data table to save images.
CREATE TABLE Images (PicNum int NOT NULL AUTO_INCREMENT PRIMARY KEY, Image BLOB);
Write upload script edu-cn.com
Regarding how to upload files, we will not introduce it here. Interested readers can refer to related articles in "Web Page Tao Bar". Now, we mainly look at how to receive uploaded files and store them in the MySQL database. The specific script code is as follows, in which we assume that the name of the file upload domain is Picture.
If($Picture != "none") {
$PSize = filesize($Picture);
$mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize));
mysql_connect($host,$username,$password) or die("Unable to connect to SQL server");
@mysql_select_db($db) or die("Unable to select database");
mysql_query("INSERT INTO Images (Image) VALUES '($mysqlPicture')") or die("Can't Perform Query");
} else {
echo "You did not upload any picture";
}
?>
In this way, we can successfully save the image to the database. If you have problems inserting images into MySQL, you can check the maximum packet size allowed by the MySQL database. If the setting value is too small, we will find the corresponding record in the error log of the database.
Next, we briefly explain the above script program. First, we check whether a file has been uploaded by "If($Picture != "none")". Then, use the addslashes() function to avoid data format errors. Finally, connect to MySQL, select the database and insert the picture.
www.edu4u.com.cn
Show pictures
After knowing how to store images into the database, we need to consider how to retrieve images from the database and display them in HTML pages. This process is a little more complicated. Let’s introduce the implementation process below.
Because displaying images requires sending corresponding headers, we will face the problem that only one image can be displayed at a time, because we cannot send other headers after sending the header.
In order to effectively solve this problem, we have written two files. Among them, the first file serves as the template of the HTML page and locates the display position of the image. The second file is used to actually output the file stream from the database as the SRC attribute of the tag.
The simple form of the first file can be as follows:
mysql_connect($host,$username,$password) or die("Unable to connect to SQL server");
@mysql_select_db($db) or die("Unable to select database");
$result=mysql_query("SELECT * FROM Images") or die("Can't Perform Query");
While($row=mysql_fetch_object($result)) {
echo "
}
?>
www.edu4u.com.cn
When the HTML page is browsed, the Second.php3 file will be called every time an image is displayed. When the second file is called, the corresponding Picture ID will be passed in, so that we can retrieve the corresponding picture from the database and display it.
The Second.php3 file is as follows:
$result=mysql_query("SELECT * FROM Images WHERE PicNum=$PicNum") or die("Can't perform Query");
$row=mysql_fetch_object($result);
Header( "Content-type: image/gif");
echo $row->Image;
?>
Excerpted from Jiutian Galaxy