mysql to bitmap
Hello, I had previously built the database (sqlite) and I used cursor1.getblob, now I have moved all from mysql server with php, but how do I transfer the photos because I like Null response from mysql? If I find as I look at mysql BLOB Binary Data
Sub hc_ResponseSuccess (Response As HttpResponse, TaskId As Int)
Msgbox("server Connect!","")
'VARIABILI TABLE SERVIZI
Dim IDArtista,Cognome,Nome,Pseudo,Nazionalita,TipoArti sta,DataNascita,FotoArtista As String
Dim res As String
res = Response.GetString("UTF8")
Log("Response from server: " & res)
Dim parser As JSONParser
parser.Initialize(res)
Select TaskId
Case Artiste_list
Dim VerfArtista As List
VerfArtista = parser.NextArray
For I = 0 To VerfArtista.Size -1
Dim M As Map
Dim InputStream1 As InputStream
Dim Buffer() As Byte
Dim Bitmap1 As Bitmap
M = VerfArtista.Get(I)
IDArtista=M.Get("IDArtista")
Cognome=M.Get("Cognome")
Nome=M.Get("Nome")
Pseudo=M.Get("Pseudo")
Nazionalita=M.Get("Nazionalita")
TipoArtista=M.Get("TipoArtista")
DataNascita =M.Get("DataNascita")
Buffer = M.Get("FotoArtista")
InputStream1.InitializeFromBytesArray(Buffer, 0, Buffer.Length)
Bitmap1.Initialize2(InputStream1)
InputStream1.Close
ListaArtiste.AddTwoLinesAndBitmap2(Pseudo,Nazional ita,Bitmap1,IDArtista)
Next
|