Home >Backend Development >PHP Tutorial >PHP upload image save to database example

PHP upload image save to database example

WBOYOriginal: 2016-08-08 09:22:311027browse

php upload pictures and save them to the database example

php upload pictures, generally use the move_uploaded_file method to save them on the server. But if a website has multiple servers, it needs to publish pictures to all servers for normal use (except for those using picture servers)

If the picture data is saved in the database, file sharing can be achieved between multiple servers, saving money. space.

First of all, the image file is binary data, so the binary data needs to be saved in the mysql database.

MySQL database provides the BLOB type for storing large amounts of data. BLOB is a binary object that can accommodate data of different sizes.

There are four types of BLOB, which are the same except for the maximum amount of information stored. Different types can be used depending on your needs.

TinyBlob Maximum 255B

Blob Maximum 65K

MediumBlob Maximum 16M

LongBlob Maximum 4 G

data tablephoto, used to save image data, the structure is as follows:

CREATE TABLE `photo` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(100) NOT NULL,
  `binarydata` mediumblob NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

upload_image_todb.php

<?php
// 连接数据库
$c  or die(mysql_error());
@mysql_select_db(&#39;demo&#39;,$conn) or die(mysql_error());

// 判断action
$action = isset($_REQUEST[&#39;action&#39;])? $_REQUEST[&#39;action&#39;] : &#39;&#39;;


// 上传图片
if($action==&#39;add&#39;){

    $image = mysql_escape_string(file_get_contents($_FILES[&#39;photo&#39;][&#39;tmp_name&#39;]));
    $type = $_FILES[&#39;photo&#39;][&#39;type&#39;];
    $sqlstr = "insert into photo(type,binarydata) values(&#39;".$type."&#39;,&#39;".$image."&#39;)";

    @mysql_query($sqlstr) or die(mysql_error());

    header(&#39;location:upload_image_todb.php&#39;);
    exit();

// 显示图片
}elseif($action==&#39;show&#39;){

    $id = isset($_GET[&#39;id&#39;])? intval($_GET[&#39;id&#39;]) : 0;
    $sqlstr = "select * from photo where id=$id";
    $query = mysql_query($sqlstr) or die(mysql_error());
    
    $thread = mysql_fetch_assoc($query);
    
    if($thread){
        header(&#39;content-type:&#39;.$thread[&#39;type&#39;]);
        echo $thread[&#39;binarydata&#39;];
        exit();
    }

}else{
// 显示图片列表及上传表单
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" c/html; charset=utf-8">
  <title> upload image to db demo </title>
 </head>

 <body>
  <form name="form1" method="post" action="upload_image_todb.php" enctype="multipart/form-data">
  <p>图片：<input type="file" name="photo"></p>
  <p><input type="hidden" name="action" value="add"><input type="submit" name="b1" value="提交"></p>
  </form>

<?php
    $sqlstr = "select * from photo order by id desc";
    $query = mysql_query($sqlstr) or die(mysql_error());
    $result = array();
    while($thread=mysql_fetch_assoc($query)){
        $result[] = $thread;
    }
    foreach($result as $val){
        echo '<p><img src="upload_image_todb.php?action=show&id=&#39;.$val[&#39;id&#39;].&#39;&t=&#39;.time().&#39;" width="150"></p>';
    }
?>

 </body>
</html>
<?php
}
?>

The above introduces the example of uploading pictures and saving them to the database in PHP, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.

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

Previous article：Nginx configuration file nginxconf Chinese detailed explanationNext article：Nginx configuration file nginxconf Chinese detailed explanation

See more

PHP upload image save to database example

Related articles