Home >Backend Development >PHP Tutorial >PHP stores images in mysql database and displays them on the web page_PHP tutorial

PHP stores images in mysql database and displays them on the web page_PHP tutorial

WBOY
WBOYOriginal
2016-07-20 11:07:411348browse

php saves the image into the mysql database and displays it on the web page

php tutorial saves the image into the mysql database tutorial and displays it on the web page

//Save the image to the database

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";
}



//Read images from the database with img tags

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 "";

//Such as 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/444939.htmlTechArticlephp save pictures into mysql database and display them on the web page php tutorial store pictures into mysql tutorial database tutorial And display on the web page //Save the picture to the database If($Picture != none) {...
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