Android Tutorial Connect Android to MySQL Database Tutorial

Status
Not open for further replies.

tufanv

Expert
Licensed User
Longtime User
Erel, I know you will say use RDC but is there any way to strenghten the security for the mysql connector ?
 

tufanv

Expert
Licensed User
Longtime User
When i do this, is it safe to use this Erel ?
The main problem with this solution is that the script will execute any query it receives. You can rewrite the script and put the queries in the PHP script and only send the parameters for the queries.
 

GMan

Well-Known Member
Licensed User
Longtime User
When i do this, is it safe to use
NO, as written ANY script can be used
 

tufanv

Expert
Licensed User
Longtime User
Any query can not be executed if we pre enter the queries in php and just send parameters as i understand.?
 
Last edited:

tufanv

Expert
Licensed User
Longtime User
Erel can you clearify it. Is it safe with parammeters. If it is not still safe will try to switch to rdc but it will be much of work. So if it is safe with parameters i will change the php and coninue
 

tufanv

Expert
Licensed User
Longtime User
Isnt it the same for rdc ? I mean of course a hacker may do anything but in rdc also parameters are sent so the same danger stays for rdc also ? I mean if they are same no need to change if not i must consider rdc and change the whole system
 

tufanv

Expert
Licensed User
Longtime User
Ok Thank you Erel ! Sorry for bothering you too much about this topic =) I will stick to old system for now .
 

suciwulans

Active Member
Licensed User
Longtime User
i want try this tutorial. i have question. the connection between android and computer server using wifi? can i use locally webserver without using internet connection for this tutorial? thanks.
 

BarryW

Active Member
Licensed User
Longtime User
Can these method use to connect in Xampp database directly using wifi connection?
 

wmardian

Member
Licensed User
Longtime User
Dear Erel and forum member,
I have several questions;
1. can we use this method to insert data to mysql? I doubt about that..
2. what is the best method to upload image file to database/server folder?

Your help is very appreciated
Thanks in advance

best regards
 

wmardian

Member
Licensed User
Longtime User
Dear Erel,
Thanks, it is very appreciated.
1. thanks
2. but RDC can not be used in shared domain environment. Dedicated server is rather expensive..

Thanks in advance
Best Regards
 

wmardian

Member
Licensed User
Longtime User
Dear Erel,
Could you please giving a clue how to use it to insert data?
What is the content of the sub "Jobdone" should be?
And should php code have json if use it to insert data?

Thank in advance
Best Regards
 

tufanv

Expert
Licensed User
Longtime User
For the example Erel Published, you can use
B4X:
ExecuteRemoteQuery("INSERT INTO countries VALUES('" & "4" & "','" & "maldives" & "','" & "323233" & "')" , COUNTRY_POPULATION)
This is just an example. Under jobdone, for the jobname "COUNTRY_POPULATION" which you have used during the insert, you dont have to add a code. But for example if you want to show a message if adding is succesful you can add msgbox("Adding Complete","Warning") . The part jobdone means what to do when insert code completed.


Dear Erel,
Could you please giving a clue how to use it to insert data?
What is the content of the sub "Jobdone" should be?
And should php code have json if use it to insert data?

Thank in advance
Best Regards
 
Status
Not open for further replies.
Cookies are required to use this site. You must accept them to continue using the site. Learn more…