mysql 存储图片和使用
mysql语句
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`images` blob NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
php存入和读取
// 连接
$user = 'root';
$pass = '';
$db = new PDO('mysql:host=localhost;dbname=test;charset=UTF8', $user, $pass);
//存入
$imagePath = '1.jpg';
$name = '111';
$image = addslashes(file_get_contents($imagePath));
$sql = "INSERT INTO `test` (images,name) VALUES ('$image','$name')";
$a = $db->exec($sql);
//读取
$res = $db->query("SELECT * FROM test ");
$test = $res->fetchAll(PDO::FETCH_ASSOC);
$base64 = base64_encode($test[0]['images']);
$b = 'data:image/png;base64,' . $base64;
echo $b;