Home > Article > Backend Development > 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
- WBOYOriginal
- 2016-07-20 11:07:411144browse
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;