Free mysql database implementation code for storing images in binary in mysql database and displaying them under PHP

//PHP code to save pictures to the database

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

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;

The above introduces the implementation code of free mysql database to store and display pictures in binary in mysql database under PHP, including the content of free mysql database. I hope it will be helpful to friends who are interested in PHP tutorials.