Php Upload image to database example sharing _ PHP Tutorial-php Tutorial

Php uploads images to the database for example sharing. 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, 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 ();
}

Success ,...