如何使用PHP保存图片？

Question

<?php
$size       = filesize('H:/blog_banner.jpg');
$fp         = fopen('H:/blog_banner.jpg','rb');
$binary_pic = fread($fp,$size);
$link       = mysqli_connect('127.0.0.1','root','123456') or die('connect failed!');
$binary_pic = base64_encode($binary_pic);

mysqli_select_db($link, 'rqPro');
mysqli_query($link,"insert into tb_pic values('',$binary_pic)") or die('cant perform pic');

The result is:

cant perform pic.

The picture in mysql save field is :medium blob.

How can I solve this?

Answer 1

Your insert query is wrong. You don't specify which field of table it will be saved. It should be .. INSERT INTO tb_pic(field1,field2) VALUES('',$binary_pic)

And my advice, it's not a good way to save pictures in Database. It's heavy. It's better to save it in your server / directory. Try to look http://php.net/manual/en/function.move-uploaded-file.php