Android Question Building your own Local Server with XAMPP and b4A(using MYSQL Database)

[suciwulans]

i try this post https://www.b4x.com/android/forum/t...-local-php-mysql-server-xampp-with-b4a.48635/
i got an error undefine key "action". should i give input manually in XAMMP mysql database?

 

[ilan]

i try this post https://www.b4x.com/android/forum/t...-local-php-mysql-server-xampp-with-b4a.48635/
i got an error undefine key "action". should i give input manually in XAMMP mysql database?

why do you want to use PHP? connect directly to your sql db using jRDC2

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...

www.b4x.com

 

[josejad]

i try this post https://www.b4x.com/android/forum/t...-local-php-mysql-server-xampp-with-b4a.48635/
i got an error undefine key "action". should i give input manually in XAMMP mysql database?

No, you have to define "action" in the URL, something like

/persons/persons.php?action=CountPersons

 

[suciwulans]

why do you want to use PHP? connect directly to your sql db using jRDC2

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...

www.b4x.com

i saw this post using B4J server not XAMMP. so i decide to use PHP. unfortunately error code display when use this on browser 127.0.0.1/persons/persons.php

 

[suciwulans]

No, you have to define "action" in the URL, something like

/persons/persons.php?action=CountPersons

i don.t understand how to use persons.php on this post https://www.b4x.com/android/forum/t...-local-php-mysql-server-xampp-with-b4a.48635/

 

[aeric]

Check my code Snippets which is based on the above post by Kmatle

Register User example using OkHttpUtils2

Register User example using OkHttpUtils2 Updates: This project is deprecated. Please check User Login + MySQL PHP API https://www.b4x.com/android/forum/threads/user-login-mysql-php-api.117826/ Introduction This code snippet is based on the thread posted by KMatle in Tutorials &...

www.b4x.com

 

[josejad]

i don.t understand how to use persons.php on this post https://www.b4x.com/android/forum/t...-local-php-mysql-server-xampp-with-b4a.48635/

From that post, in the php script you have:

$action = $_GET["action"];
switch ($action)

Please read

$_GET can also collect data sent in the URL.

Assume we have an HTML page that contains a hyperlink with parameters:

In that post script, you have:

switch ($action)

And "action" can be: CountPersons, GetPersons or InsertNewPerson.

i got an error undefine key "action"

So, you have to define action in the URL when you call your script, something like this (assuming you're testing in the computer you're running xampp)

http://localhost/persons.php?action=CountPersons

 

[aeric]

Since you are posting in B4A forum, I assume you made a mistake in B4A code when calling the PHP web service.

Here is an example:

Dim job As HttpJob
job.Initialize("", Me)
job.Download2("http://192.168.50.6/persons/persons.php", Array As String("action", "CountPersons"))
Wait For (job) JobDone (job As HttpJob)
If job.Success Then    
    Log(job.GetString)
Else
    Log(job.ErrorMessage)
End If
job.Release

edit: URL edited

 

[josejad]

http://127.0.0.1:8000/

Hi Aeric, in the B4A app shouldn't he change the 127.0.0.1 with the xampp server ip?

 

[suciwulans]

Since you are posting in B4A forum, I assume you made a mistake in B4A code when calling the PHP web service.

Here is an example:

Dim job As HttpJob
job.Initialize("", Me)
job.Download2("http://192.168.50.6/persons/persons.php", Array As String("action", "CountPersons"))
Wait For (job) JobDone (job As HttpJob)
If job.Success Then   
    Log(job.GetString)
Else
    Log(job.ErrorMessage)
End If
job.Release

edit: URL edited

oke i try right now