Android Question insert and read image with blob on server mysql database

[taylorw]

Hi,all i need help for insert and read image with blob need help.
thanks.

'''''''''''This is insert Code
Dim Query As String
Dim InputStream1 As InputStream

InputStream1 = File.OpenInput(Dir, FileName)
Dim OutputStream1 As OutputStream
OutputStream1.InitializeToBytesArray(1000)
File.Copy2(InputStream1, OutputStream1)
Dim Buffer() As Byte 'declares an empty array
Buffer = OutputStream1.ToBytesArray

If Success Then
IV.SetBackgroundImage(LoadBitmap(Dir,FileName))
Query = "Insert Into tblItem_Maintenance (Item_Picture) Values ('" & Array As Object(Buffer) & "') "
ExecuteRemoteQuery(Query,"")
Else

End If

 

[KMatle]

Just convert it to Base64 and use LONGTEXT (or so) as the culumn's data type. So you just handle text's. Very easy. Convert it back when needed.

There are examples in the forum. Just search for Base64.

Note: If you need to handle a huge amount of images it might be better to store an index in your db and store the image as a file (search the forum how to store a file in php like multipart, etc.)

 

[Cableguy]

Check this thread, post#2 image2bytes and bytes2image

https://www.b4x.com/android/forum/threads/b4x-bytes-to-file.70111/#content

 

[Erel]

The PHP script doesn't support blobs. You can switch to RDC which does support blobs (and has other advantages).

 

[M.LAZ]

The PHP script doesn't support blobs. You can switch to RDC which does support blobs (and has other advantages).

i don't have a server and my hosting is shared , could i use RDC or Jrdc2?

 

[Erel]

You should have started a new thread for this question.

You cannot run B4J servers in shared hosting. You need a VPS.