Most people upload pictures by saving a path to the database, which is really fast when inserting and conforms to the characteristics of the web. However, it is very troublesome when deleting. You need to find the file and delete it. This code can directly Save it to the database and delete it when you delete it. Please note: If this happens, the database size will increase. Please use it as appropriate
Table structure
Copy code 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
Copy code The code is as follows:
post.php
Copy code 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 '
';<br> try{<br> $pdo = new PDO($dsn,'root' ,'root');<br> $pdo->exec("INSERT INTO `upload`(`type`,`data`) values ('$type',0x$data)");<br> $id = $pdo->lastInsertId (); pdo = null;<br> }catch (PDOException $e){<br> echo $e->getMessage();<br> }<br> echo '';
fclose($ fp);
}
view.php
Copy code 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']}"); data'];
$pdo = null;
}catch (PDOException $e){
echo $e->getMessage();
}
}else{
exit ();
}
http://www.bkjia.com/PHPjc/740205.html
www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/740205.htmlTechArticleMost people upload pictures by saving a path to the database, which is really fast when inserting and is also consistent with the web features, but it is very troublesome when deleting. You need to find the file and delete it...
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
