retrieving image from remote mysql db to android

Question

how to fetch the image stored in mysql on server? I want to fetch those images based on the values user has entered (means dynamic query). I want to use json to send the image from php to android. I successfully displayed that image in web browser using static query but when I saw the response of the php in android app it shows some html code instead of image.please help me in parsing the image json response and displaying that image. following is the php code to send image to android.

 while($post = mysql_fetch_object($data))
 {
    $posts[] = $post;

 }
         //header("Content-type: image/jpeg");

         echo '{"pprs":'.json_encode($posts).'}';

now i am getting response : {"pprs":[{"pprs":null},{"pprs":null}]}

please help me.Thank you.

Do you have any sample code or anything? Without any more details, it's very difficult as to what may be happening. — tcole
– tcole, Commented Sep 28, 2012 at 22:48
I am getting the following response 2{"pprs":null}{"pprs":null} — TechHelper
– TechHelper, Commented Sep 29, 2012 at 19:38
currently i am trying static sql query to retrieve all the images from mysql. As shown in the code above $data contains query result. — TechHelper
– TechHelper, Commented Sep 29, 2012 at 20:51

Oto Zars · Accepted Answer · 2013-01-17 13:22:55Z

2

You need to convert your image to string if you want to use JSON:

    $posts[] = base64_encode($post);

And on Android side:

String base64image = jsonobject.getString("pprs");
byte[] rawImage = Base64.decode(base64image, Base64.DEFAULT);
Bitmap bmp = BitmapFactory.decodeByteArray(rawImage, 0, rawImage.length);
ImageView imageview = (ImageView) findViewById(R.id.imgPicture);
imageview.setImageBitmap(bmp);

answered Jan 17, 2013 at 13:22

Oto Zars

8211 gold badge12 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

retrieving image from remote mysql db to android

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