Android Question SQL Connect from Android App

[hasexxl1988]

Hello,
I have an Android app and would now like to create a user login as well as manage the game's gameplays in this SQL database.
The app is supposed to be able to write data to the SQL database as well as to read.

I have already tried this but without success:
https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/#content

I have so far only experience with the MySQL LocalDB system in Android, but not how to exchange a DB online claim or data.

Is it advisable to manage this via a PHP interface?

I dont understand the RDC Logic.


Can I also use "CloudKVS" for the intended purpose?

The mirror data could thus be stored locally in an SQLDB.

 

[ronell]

you can use okhttputils2

Dim job As HttpJob
    job.Initialize("job1", Me)
    job.Download2(url, _
    Array As String("user_id",userid,"user_pass",userpass)) ' <-- send login credentials to webservice

Sub JobDone (Job As HttpJob)

Log("JobName = " & Job.JobName & ", Success = " & Job.Success)
'do what you want here

End Sub

 

[hasexxl1988]

you can use okhttputils2

Dim job As HttpJob
    job.Initialize("job1", Me)
    job.Download2(url, _
    Array As String("user_id",userid,"user_pass",userpass)) ' <-- send login credentials to webservice

Sub JobDone (Job As HttpJob)

Log("JobName = " & Job.JobName & ", Success = " & Job.Success)
'do what you want here

End Sub

I have testbed a SQL database.

Do I then have to enter the loginname and the password of the SQL fix in the app that the data can be stored and read?
So the SQL Admin login name I created myself?

 

[ronell]

I have testbed a SQL database.

Do I then have to enter the loginname and the password of the SQL fix in the app that the data can be stored and read?
So the SQL Admin login name I created myself?

sorry.. i didnt get your question, can you explain it more clearly?

 

[hasexxl1988]

sorry.. i didnt get your question, can you explain it more clearly?

Sorry, I meant:
The database has a fixed login password to get access to it.
Do I have to enter this password in the app? Is not that a safety risk?

 

[ronell]

Sorry, I meant:
The database has a fixed login password to get access to it.
Do I have to enter this password in the app? Is not that a safety risk?

no need .. just set the db password in your phpscript

 

[hasexxl1988]

no need .. just set the db password in your phpscript

Can not the PHP script be downloaded externally simply and thus the password be read? : D

 

[ronell]

Can not the PHP script be downloaded externally simply and thus the password be read? : D

your phpscript will be downloaded by who? users? i dont think that will happen

 

[hasexxl1988]

your phpscript will be downloaded by who? users? i dont think that will happen

Okay thanks for replys i try this Weekend