Android Question JSON Array expected

[ilan]

hi

i am trying to get the entires from my mysql db via php but what i get is an error saying JSON array expected...

this is the log:

*** Service (starter) Create ***
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
*** Service (httputils2service) Create ***
** Service (httputils2service) Start **
[{"id":"3","title":"דרושים כוונים CNC לכרסום וחריטה","date":"30-07-2019","fav":"0","title2":"גולדברגר טכנולוגיות","jobexp":"לחברת גולדברגר טכנולוגיות הממוקמת בא.ת בר לב (ליד כרמיאל), דרושים כוונים CNC לכרסום וחריטה.\r\n*משרה מלאה.\r\n*אווירה נעימה ואיכותית!\r\n*תנאים טובים מאד למתאימים\/ות.","jobneeds":"- ניסיון קודם - חובה.\r\n- ראש גדול, מוסר עבודה וחריצות.\r\n*המשרה מיועדת לנשים וגברים כאחד.","experience":"1-2","category":"CNC, כרסם - חרט","place":"צפון","period":"משרה מלאה","price":"0","publisher":"גולדברגר","pubemail":"[email protected]","pubid":"1","startdatetime":"00000000000","enddatetime":"00000000000","status":"0"}]
Error occurred on line: 82 (jobs)
java.lang.RuntimeException: JSON Array expected.
at anywheresoftware.b4a.objects.collections.JSONParser.NextArray(JSONParser.java:62)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
at java.lang.reflect.Method.invoke(Native Method)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
at anywheresoftware.b4a.shell.DebugResumableSub$RemoteResumableSub.resume(DebugResumableSub.java:22)
at anywheresoftware.b4a.BA.checkAndRunWaitForEvent(BA.java:250)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:137)
at anywheresoftware.b4a.BA$2.run(BA.java:370)
at android.os.Handler.handleCallback(Handler.java:873)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:193)
at android.app.ActivityThread.main(ActivityThread.java:6669)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:493)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:858)

this is the code:

Sub loadalljobs As ResumableSub
    jobsclv.Clear
   
    Dim j As HttpJob
    j.Initialize("", Me)
    j.Download2("http://www.sagital.net/msjobs4.php", Array As String ("action", "getjobs"))
    Wait For (j) JobDone(j As HttpJob)
    If j.Success Then
        Log(UnescapeUnicode(j.GetString))
       
        Dim parser As JSONParser
        parser.Initialize(UnescapeUnicode(j.GetString))
        Dim root As List = parser.NextArray
        Log(root.Size)
    End If
    j.Release

    Return True
End Sub


Sub UnescapeUnicode(s As String) As String
    Dim sb As StringBuilder
    sb.Initialize
    Dim i As Int
    Do While i < s.Length
        Dim c As Char = s.CharAt(i)
        If c = "\" And i < s.Length - 1 And s.CharAt(i + 1) = "u" Then
            Dim unicode As StringBuilder
            unicode.Initialize
            i = i + 2
            Do While i < s.Length
                Dim cc As String = s.CharAt(i)
                Dim n As Int = Asc(cc.ToLowerCase)
                If (n >= Asc("0") And n <= Asc("9")) Or (n >= Asc("a") And n <= Asc("f")) Then
                    unicode.Append(s.CharAt(i))
                Else
                    i = i - 1
                    Exit
                End If
                i = i + 1
            Loop
            sb.Append(Chr(Bit.ParseInt(unicode.ToString, 16)))
        Else
            sb.Append(c)
        End If
        i = i + 1
    Loop
    Return sb.ToString
End Sub

and php code:

    Case "getjobs":
        $q = mysqli_query($con, "SELECT * FROM $table ORDER BY id");
        $rows = array();
        while($r = mysqli_fetch_assoc($q))
        {
            $rows[] = $r;
        }
        print json_encode($rows);
        mysqli_free_result($q);
    break;

what am i doing wrong?

thanx

 

[Erel]

(Switch to jRDC2. Simpler, more powerful and better performance)

 

[ilan]

(Switch to jRDC2. Simpler, more powerful and better performance)

I would love too, but a private server is very expensive and for now, I don't make enough profit for that. if it will get better I will definitely switch to jrdc2

 

[Erel]

but a private server is very expensive

I cannot recommend any specific VPS but there are quite low cost options. For example: https://lowendbox.com/

 

[ilan]

I cannot recommend any specific VPS but there are quite low cost options. For example: https://lowendbox.com/

wow, this is really cheap. all I checked until today have costs 60$-80$/ month.
just to make sure if I go for this one: https://www.snowvps.com/portal/cart.php?a=confproduct&i=1

will I be able to use JRDC? I don't really know what it means but will I be able to upload a kvs DB and use it with my apps instead of MySQL?

thank you erel

 

[Erel]

I expect it to work. Steps to run a B4J server: https://www.b4x.com/android/forum/threads/server-run-a-server-on-a-vps.60378/#content

 

[ilan]

btw. i think i already asked you once by why does not Anywhere Software also offer Hosting Service? You already are dealing with it (B4i Hosted Builder)
i am sure a lot will use your service (including me)

 

[Erel]

B4i hosted builders are running on a third party host (MacStaduim).
I prefer to focus on the development tools.

 

[Johan Hormaza]

For testing, I recommend that you use Amazon AWS servers, you can use them for one year for free.
https://signin.aws.amazon.com/signi...::015428540659:user/homepage&forceMobileApp=0

 

[inakigarm]

For testing, I recommend that you use Amazon AWS servers, you can use them for one year for free.
https://signin.aws.amazon.com/signin?redirect_uri=https://console.aws.amazon.com/console/home?state=hashArgs%23&isauthcode=true&client_id=arn:aws:iam::015428540659:user/homepage&forceMobileApp=0

I also use the Free Tier and is a good option to begin