Implementation code for storing images in binary in mysql database and displaying them under PHP_PHP Tutorial

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

http://www.bkjia.com/PHPjc/322041.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/322041.htmlTechArticle//The php code for saving pictures to the database is copied as follows: If($Picture != "none") { $PSize = filesize($Picture); $mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize...