Android Question Load sql blob data and display image on html page

metrick

Active Member
Licensed User
Longtime User
Ok, spend amount of time searching, but couldn't get answered.
Codes to read data from sql:
B4X: 
                  Dim Buffer() As Byte 'declare an empty byte array
                            Buffer = cur.GetBlob("Img")
                            Dim InputStm As InputStream
                            InputStm.InitializeFromBytesArray(Buffer, 0, Buffer.Length)

              Dim Bmp As Bitmap
              Bmp.Initialize2(InputStm)
              InputStm.Close

'tag to display img:
<img src=Bmp style="width:120px;height:120px;">
 
Sort by date Sort by votes

DonManfred

Expert
Licensed User
Longtime User
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
As @DonManfred wrote you need to save it to a file:
B4X: 
Dim out As OutputStream = File.OpenOutput(...)
out.WriteBytes(buffer, 0, buffer.length)
out.Close
You can save it to File.DirInternal.

B4X: 
WebView.LoadHtml($"
<img src="file://${File.Combine(File.DirInternal, "1.png")}" style="width:120px;height:120px;"/>
"$)
 
Upvote 0
You must log in or register to reply here.

Similar Threads

W
  • Question
Android Question JdbcSQL with BLOB field
Replies
8
Views
2K
Wendell Carneiro Mendes
W
M
  • Question
Android Question [SOLVED] jRDC & sqlite image blob retrieval and display in imageview
Replies
4
Views
4K
KMatle
T
  • Question
Android Question insert and read image with blob on server mysql database
Replies
5
Views
4K
Erel
D
  • Question
Android Question BLOB - Null
Replies
2
Views
2K
Declan
D
D
  • Question
Android Question SQLite Insert/Update BLOB at specific position
2
Replies
20
Views
7K
Mvula
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…