Mobile app accessing 1&1 MySQL db
I'm running a MySQL database on a 1&1 shared server account.
I'm developing a mobile app that needs to be able to read from and update the database.
As far as I'm aware, 1&1 does not allow non-local communication with their databases.
Now I'm sure there should be some way I can work around this using a server side script that can act as the middle man between the app and the database but absolutely no idea where to start.
Does anyone have any ideas?
sure. what you need is script sitting between ckient and database server
Nobody in their right mind would even try to communicate directly from a mobile app (or any client side app) directly with a database. To do so, you would have to pass the DB username and password--along with *ALL* the SQL queries--from the mobile device to the DB server. And that means that anybody who managed to sniff the communications or read the coding of your app would now have full access to your database and could do all sorts of nasties to it. *CLEARLY* you want and need to have server side code that protects you from this kind of stuff. The server-side code knows what kind of requests it will accept from the app and will reject anything else. And it would then never just take a SQL command from the app and execute it, as is. It would always validate and "sanitize" the requests.
What I'm not too sure about is the reading half though.
How can my app retrieve information from the server? Once my php script authenticates and gets the database info that's been requested, how can I provide this to my app?
|All times are GMT +1. The time now is 04:44 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.