Example of storing php uploaded images to a database

This article mainly introduces the example of storing uploaded php images into a database. For more information, see

This article mainly introduces the example of storing uploaded php images into a database. For more information, see

Most people upload images by saving a path to the database, which is indeed fast during insertion and meets the characteristics of the web, but it is very troublesome to delete the file. You need to find and delete the file, this code can directly store the code into the database and delete it when it is deleted. Please note: In this case, the database size will surge, please use it as appropriate

Table Structure

The Code is as follows:

Create table 'upload '(
'Id' int (10) unsigned not null AUTO_INCREMENT,
'Type' varchar (20) not null,
'Data' mediumblob not null,
Primary key ('id ')
) ENGINE = InnoDB AUTO_INCREMENT = 1 default charset = utf8;

Index.html

The Code is as follows:

<BR> Post-Image <BR>

Post. php

The Code is as follows:

If ($ _ FILES ["file"] ["error"]> 0)
{
Echo "Error:". $ _ FILES ["file"] ["error"]."
";
}
Else
{
$ Type = $ _ FILES ["file"] ["type"];
$ Size = $ _ FILES ['file'] ['SIZE'];
$ Tmp = $ _ FILES ["file"] ["tmp_name"];
$ Fp = fopen ($ tmp, 'rb ');
$ Data = bin2hex (fread ($ fp, $ size ));
$ Dsn = 'mysql: host = localhost; dbname = test ';
Echo'

';
    try{
        $pdo = new PDO($dsn,'root','root');
        $pdo->exec("INSERT INTO `upload`(`type`,`data`) values ('$type',0x$data)");
        $id = $pdo->lastInsertId();
        echo 'upload success!View';
        $pdo = null;
    }catch (PDOException $e){
        echo $e->getMessage();
    }
    echo '

';
Fclose ($ fp );
}

View. php

The Code is as follows:

$ Id = $ _ GET ['id'];
If (is_numeric ($ id )){
$ Dsn = 'mysql: host = localhost; dbname = test ';
Try {
$ Pdo = new PDO ($ dsn, 'root', 'root ');
$ Rs = $ pdo-> query ('select * from 'upload' where 'id' = '. $ id );
$ Row = $ rs-> fetchAll ();
$ Data = $ row [0];
Header ("Content-Type :$ {data ['type']}");
Echo $ data ['data'];
$ Pdo = null;
} Catch (PDOException $ e ){
Echo $ e-> getMessage ();
}
} Else {
Exit ();
}