PHP Encoding and Decoding HTML as Binary

Question

The database I am using is Postgresql and I downloading a webpage and storing in a BLOB. Like this:

<?php
$html = file_get_contents('http://www.example.com');
$encoded_html = base64_encode($html);

//Store encoded data in blob in database
?>

That part works fine. But when I try to decode it and display it, it comes out garabled.

<?php echo base64_decode($encoded_html); ?>

Do I have to add extra parameters when encoding and decoding the data?

Besides that if you are base64 encoding then you don't need a blob, just plain text. — Clodoaldo Neto
– Clodoaldo Neto, Commented Mar 3, 2013 at 22:43
Indeed, take care of the place used by base64. it is greedy of memory. You can add directly your content, escaping your string to prevent error from your postGreSQL. That will be fine and more simple. — MatRt
– MatRt, Commented Mar 3, 2013 at 22:43

James C · Accepted Answer · 2013-03-03 22:44:41Z

1

If this works then the encode/decode functions work fine

<?php
$html = file_get_contents('http://www.example.com');
$md5 = md5($html);
$encoded_html = base64_encode($html);
$decoded_html = base64_decode($encoded_html);
echo (md5($decoded_html) == $md5) ? 'OK' : 'FAIL';
echo PHP_EOL;

If not then I'd suggest comparing the base64 data that you're putting into the database with what comes out.

answered Mar 3, 2013 at 22:44

James C

14.2k1 gold badge37 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

PHP Encoding and Decoding HTML as Binary

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related