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

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;

http://www.bkjia.com/PHPjc/444939.htmlwww.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) {...