mysql image to json array

[jayel]

Hello,

I've been searching around but can't find it.
I have a table with products and an image(foto) of that product.

I can get de product name & product code in a json array and put it on a listview.

But now when I click the product in de listview I want the picture of that product shown on my android .

Can somedy help please?

Greets,

John

 

[Erel]

You will need to convert the image BLOB to a string by encoding it in base 64 in the PHP script. You will then need to convert it to bytes in the client.

 

[jayel]

Thanks Erel,

Dim m As Map
m = l.Get(0)
Dim b() As Byte   
Dim bmp As Bitmap
Dim s As StringUtils
Dim i As InputStream


b =s.DecodeBase64(m.Get("afbeelding"))

i.InitializeFromBytesArray(b,0,b.Length)
bmp.Initialize2(i)
i.Close
ImgAfbeelding.Bitmap = bmp

SOLVED !

greets,

John

 

[AJ Ramone]

How must the php Script look like?
The php Script is like explained in the mysql database tutorial.
I have changed the Code like jayel posted but I am still getting an load image error.