How to save binary data in MySQL using PHP?

Question

i want to download the image from one server, and want to save the binery data into mysql blob field. but its not working.

if i am displaying the $picture1 then it shows the un-readable characters. byt $picture2 is not displaying.
if i try to save it in the table, then its not saving in the table.

how can i save this into my blob field.

$picture1 = GetImageFromUrl($url);
$picture2 = addslashes(fread(fopen($picture, "r"), filesize($picture)));

print_r($picture1)
print_r($picture2)

function GetImageFromUrl($link)
{

$ch = curl_init(); 
curl_setopt($ch, CURLOPT_POST, 0); 
curl_setopt($ch,CURLOPT_URL,$link); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); 
$result=curl_exec($ch); 
curl_close($ch); 
return $result;
}

Community · Accepted Answer · 2017-05-23 10:09:12Z

1

Try encoding it with base64 before saving in your database field:

echo base64_encode($picture1);

And to read out from database, you need to decode it:

echo base64_decode($picture);

But be sure to send the right headers with it, for example:

header('Content-Type: image/png');

But please read this before: Storing Images in DB - Yea or Nay? and consider if you really want to save it in your database.

I am strictly against it, but it's in your power

edited May 23, 2017 at 10:09

CommunityBot

11 silver badge

answered May 31, 2012 at 14:07

dan-lee

14.5k6 gold badges55 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Turpin Over a year ago

Also, be aware that the size of base64 encoded data is roughly 1.37 times bigger than the size of the original data.

asif hameed Over a year ago

its displaying the binary codes, but not saving it in the database.

Collectives™ on Stack Overflow

How to save binary data in MySQL using PHP?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related