View Full Version : Mobile app accessing 1&1 MySQL db
04-03-2013, 02:17 PM
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?
04-03-2013, 07:10 PM
sure. what you need is script sitting between ckient and database server
04-03-2013, 11:45 PM
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.
04-04-2013, 10:59 AM
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.
So would I have my app access a php script using a URL loaded with $_GET vars to define the action required and to authenticate the source? I can understand doing something along those lines.
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?
Powered by vBulletin® Version 4.2.2 Copyright © 2015 vBulletin Solutions, Inc. All rights reserved.