How to store Base64 string in mySQL as BLOB

Question

I'm trying to insert a base64 string into blob by using the code below, I'm getting a blob added to the database but it's a damaged file with no extension.

Background:

[request setHTTPMethod:@"POST"];
NSString *encodedString = [binaryData base64Encoding];
NSString *bodyString = [NSString stringWithFormat:@"image=%@", encodedString];

PHP:

$json_obj = $_POST['image'];
$encodedData = str_replace(' ','+',$json_obj);
$encodedData= chunk_split(base64_encode(file_get_contents($encodedData)));
$blob = $encodedData;
$dbHandle = mysql_connect("--------","-------","------");
$dbFound = mysql_select_db("----------");

if($dbFound){


    $check = "INSERT INTO `Images`(`imageId`, `image`, `userId`, `dateCreated`) ".
           "VALUES ".
           "('','$blob','0',null)";

    $retval = mysql_query( $check, $dbHandle );

    if(!$retval)
    {
        die('Could not enter data: ' . mysql_error());
    }
echo '<img src="data:image/jpeg;base64,' . $blob . '" />';
}
else{
      print "No Connection";
}

Boris · Accepted Answer · 2013-03-16 17:45:13Z

4

Try to use:

$encodedData= chunk_split(base64_encode(file_get_contents($json_obj)));

Then change echo "BLOB: " . "---" . $blob; to:

echo '<img src="data:image/jpeg;base64,' . $blob. '" />';

Otherwise you are just dumping the string value that's why you get this result.

edited Mar 16, 2013 at 17:45

answered Mar 16, 2013 at 11:50

Boris

8021 gold badge10 silver badges13 bronze badges

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

6 Comments

Dave Over a year ago

I'm not tryna output it or anything, I'm just getting a damaged file with no extension in the database

Dave Over a year ago

It still displays the image file perfectly but having a damaged file with no extension in mysql

Dave Over a year ago

Changed my question with the code provided so you can see it more clearly

Boris Over a year ago

@Dave Try $_FILES["image"] instead of $_POST["image"]. And remove $encodedData = str_replace(' ','+',$json_obj);.

Dave Over a year ago

That gives me <img src="data:image/jpeg;base64,DQo=" />. With a damaged file much smaller in size in the database, I'll add a bit of the background going to php to my question

|

Mike · Accepted Answer · 2013-08-03 22:40:36Z

1

Have you tried using mysql base64 function: TO_BASE64('string'); ?

edited Aug 3, 2013 at 22:40

Mike

24.5k14 gold badges84 silver badges93 bronze badges

answered Aug 3, 2013 at 22:20

eric

111 bronze badge

Collectives™ on Stack Overflow

How to store Base64 string in mySQL as BLOB

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related