PHP implements method of uploading images to database and displaying output

This article mainly introduces the method of uploading pictures to the database and displaying the output in PHP. It analyzes the related operation skills of using PHP to store pictures in binary form and read and display them in the form of examples. Friends in need can refer to the following

The example of this article describes the method of uploading images to the database and displaying the output in PHP. Share it with everyone for your reference, the details are as follows:

1. Create a data table

CREATE TABLE ccs_image (
 id int(4) unsigned NOT NULL auto_increment,
 description varchar(250) default NULL,
 bin_data longblob,
 filename varchar(50) default NULL,
 filesize varchar(50) default NULL,
 filetype varchar(50) default NULL,
 PRIMARY KEY (id)
)engine=myisam DEFAULT charset=utf8

2. A page for uploading images to the server upimage.html

  
  
  
  
  




  描述:
  
   

  上传文件到数据库:
  

  

3. PHP that handles image uploads upimage.php

query("INSERT INTO ccs_image (description,bin_data,filename,filesize,filetype)
         VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");
  if ($result) {
    echo "图片已存储到数据库";
  } else {
    echo "请求失败,请重试";

Note: The picture is stored in the database in the form of a binary blob, like this

4. Display the php getimage.php

query($query);
  $result=$result->fetchAll(2);
//  var_dump($result);
  $data = $result[0]['bin_data'];
  $type = $result[0]['filetype'];
  Header( "Content-type: $type");
  echo $data;

Go to the browser to view the uploaded image and see if it can be displayed.

is no problem, which proves that the image has been stored in binary form. Reached the database

Related recommendations:

PHP method to implement file upload and download

PHP method to implement uploading pictures to zimg server

The above is the detailed content of PHP implements method of uploading images to database and displaying output. For more information, please follow other related articles on the PHP Chinese website!