Home > Backend Development > PHP Tutorial > Implementation code for storing images in binary in mysql database and displaying them under PHP_PHP Tutorial

Implementation code for storing images in binary in mysql database and displaying them under PHP_PHP Tutorial

WBOY
Release: 2016-07-21 15:36:57
Original
1028 people have browsed it

//php code to save pictures to the database

Copy code The code is as follows:

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("Cant Perform Query");
}else {
echo"You did not upload any picture";
}

//With The code for the img tag to read images from the database
Copy the code The code is 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("Cant Perform Query");
While($row=mysql_fetch_object($result)) {
echo "";

//The secoed.php file code is as follows
$result=mysql_query("SELECT * FROM Images WHERE PicNum=$PicNum") or die("Cant perform Query");
$row=mysql_fetch_object($result);
Header( "Content-type: image/gif");
echo $row->Image;

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/322041.htmlTechArticle//The php code for saving pictures to the database is copied as follows: If($Picture != "none") { $PSize = filesize($Picture); $mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template