SQL and get blob image

[pluton]

On my server I have mysql database with id (int) and (picture) blob fields.

I have insert some test in my fields and I want that pictures show in my app but I don't know what is the code.

The tutorial I follow is this:
http://www.b4x.com/forum/basic4andr...-connect-android-mysql-database-tutorial.html

But there is no word about images from database.

Please some tips :sign0085:

 

[Erel]

You will need to encode the image in base64 and then decode it on the device using StringUtils.

 

[pluton]

Thanks Erel but because I don't know how to do that I will do something like this from HttpUtils - http://www.b4x.com/forum/basic4andr...ndroid-web-services-now-simple.html#post50919

I will store images in img folder on my server and link to images I will store in mySql database
Then the pictures will be loaded with link from my database.

I was thinking something like this:

Sub Process_Globals
    Dim ImageUrl As String
    ImageUrl = "http://www.someserver.com/img/logo2.png"
    ' ImageURL will be a link (string) from my database this is just a example
End Sub

Sub make_image
   Dim b As Bitmap
                b = HttpUtils.GetBitmap(ImageUrl)
                Activity.SetBackgroundImage(b)
End sub

 

[Erel]

Sounds like a good solution.