Android: how to upload image in mysql using php

Question

I have image in ImageView that is selected by the user ... how can i insert it to mysql database table using php?

can anyone help me with that.

the type of column that i want image to save on it is Blob.

@jtheman imageView.buildDrawingCache(); bmIcone = imageView.getDrawingCache(); ByteArrayOutputStream stream = new ByteArrayOutputStream(); bmIcone.compress(Bitmap.CompressFormat.PNG, 90, stream); byte [] byte_arr = stream.toByteArray(); String image_str = Base64.encodeBytes(byte_arr); namevaluepair.add(new BasicNameValuePair("image",image_str)); php code $base= $_REQUEST['image']; $buffer = base64_decode($base); — FinalDark
– FinalDark, Commented Feb 10, 2013 at 12:48

FinalDark · Accepted Answer · 2013-03-02 10:48:54Z

4

OK that i found a solution for my question

code in java assuming that the image is already converted to bitmap:

        ByteArrayOutputStream stream = new ByteArrayOutputStream();
        bmIcone.compress(Bitmap.CompressFormat.PNG, 90, stream);
        byte[] byte_arr = stream.toByteArray();
        String image_str = Base64.encodeBytes(byte_arr);
        namevaluepair.add(new BasicNameValuePair("image", image_str));

in server :

$base= $_REQUEST['image'];
    $buffer = base64_decode($base);

    $buffer = mysql_real_escape_string($buffer);

then inserting the $buffer to table blob column type

answered Mar 2, 2013 at 10:48

FinalDark

1,7581 gold badge17 silver badges26 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:08:13Z

0

First, you will have to call your php in android. Many answers already exist on this topic:

To answer your question, this tutorial teaches you how to write your php to store images in MySQL:

http://forum.codecall.net/topic/40286-tutorial-storing-images-in-mysql-with-php/

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Feb 7, 2013 at 23:37

Barney

2,3714 gold badges23 silver badges38 bronze badges

1 Comment

FinalDark Over a year ago

thx for your help but the tutorial u gave it to me is for html page. android is different i think.. what i am doing right now is converting the ImageView to a bitmap and then convert the bitmap to String by encoding it using base64 ,then send it to php and decode it ... the problem is how can i insert it into table after decoding it? ... or is there any different solution for inserting image to mysql tables?

Collectives™ on Stack Overflow

Android: how to upload image in mysql using php

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related