Home > Article > Backend Development > 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
- WBOYOriginal
- 2016-07-21 15:36:57946browse
//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;
Statement：
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
Previous article：Example code for uploading, downloading and deleting files by connecting to ftp under PHP_PHP TutorialNext article：Example code for uploading, downloading and deleting files by connecting to ftp under PHP_PHP Tutorial