i have a sqlite db that has many columns but 2 important columns.
id & ver
now i have a online db where i fill all new data to it.
the app should send an array from all records with key id and value ver
and via php compare with the online db if for the specific id the ver is newer then return it via array
so i dont want to return a single record i want to return all records with a newer version.
i just dont find it efficient to download the whole table and make the comparison in the b4x app. instead i would like to make it online. (php)
so the app should create a arra with key & value (i was thinking maybe json string) and then upload to the php server and make the check there. the problem is i dont find the answer how to get from the json array the json object by key.
Dim jsonstr As String = $"[{"audioid":"w0R2Ppk5","ver":"0"},{"audioid":"ne47IX5A","ver":"1"}]"$
Wait For (Main.mysqlClass.downLoadAudio(jsonstr)) Complete (audioMap As Map)
Log(audioMap.Size)