How to get BLOB image file from MYSQL server via JSON efficiently

Question

My MYSQL db contains 5 rows

id, name, username, password, email, image

The image type is BLOB.

My PHP codes below to get JSON data from MYSQL.

while($row = mysqli_fetch_array($res)){
     array_push($result,
         array('id'=>$row[0],
               'name'=>$row[1],
               'username'=>$row[2],
               'password'=>$row[3],
               'email'=>$row[4],
               'image'=>$row[5])
               ));
}

echo json_encode(array("result"=>$result));

My application will load longer than expected to parse the base64 image string from the returned JSON.

So what's the best way to store and retrieve image file efficiently?

one suggestion is to store imagepath and not image in your db , and show images in android from that imagepath you received via json — Satyen Udeshi
– Satyen Udeshi, Commented Oct 5, 2015 at 6:26
The simple answer is it's completely inefficient. and the only way to make it efficient is not to store images as blobs. — e4c5
– e4c5, Commented Oct 5, 2015 at 7:17

Panda · Accepted Answer · 2015-10-05 06:31:45Z

3

I had a similar problem. So I avoided storing images in MySql. I am storing them in the server as image files and using picasso to show the images. Its super easy to transform and use.

answered Oct 5, 2015 at 6:31

Panda

1522 silver badges10 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:16:56Z

0

Assuming your Above code is correct and you are getting base64 as image you can simply do this

while($row = mysqli_fetch_array($res)){
     array_push($result,
         array('id'=>$row[0],
               'name'=>$row[1],
               'username'=>$row[2],
               'password'=>$row[3],
               'email'=>$row[4],
               'image'=>$row[5])
               ));
}

echo json_encode(array("result"=>$result));

on Android side you can do some thing like this to convert it to image.

byte[] decodedString = Base64.decode(encodedImage, Base64.DEFAULT);
Bitmap decodedByte = BitmapFactory.decodeByteArray(decodedString, 0, decodedString.length);

Convert base64 string to Image in Java taken as reference

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Oct 5, 2015 at 6:29

noobie-php

7,32416 gold badges60 silver badges106 bronze badges

7 Comments

cw fei Over a year ago

I've tried this, I got a textview to display JSON data, it show null when use this method

noobie-php Over a year ago

@cwfei : originally you were using reference to the image like &row[5] and not to value itself i.e $row[5] try this approach again

cw fei Over a year ago

That's my mistake but I've correct it, without base64_decode i get something like "image":"\/9j\/4AAQSkZJRASJDASDJA\/........", a very long string

noobie-php Over a year ago

thats the actual base 64 converted image all you need to do is send the data as it is to client i.e android device and decode it on client end.

noobie-php Over a year ago

@cwfei: All you have to do is send the base64 string to client i.e android and decode it there, i have shared a sample on how to do it, there are other few ways to do that too.

|

Collectives™ on Stack Overflow

How to get BLOB image file from MYSQL server via JSON efficiently

2 Answers 2

Comments

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related