Please Read URGENT!!!

Solar2D General Questions/Discussion
#1

Hey guys, A client wants me to build them an app that allows the user to put in their first name, last name, and email and store it into an sql database on their web server. Is this possible with corona? [import]uid: 122076 topic_id: 22135 reply_id: 322135[/import]

#2

Yes, not hard at all, although “Please Read URGENT!!!” doesn’t have anything to do with user input, emails, or databases, so I kind of feel bad for answering. :wink:

Jay

PS - I don’t know that it’s possible for a Corona SDK app to push the data straight into a remote database, but you could pass the info to a PHP script that would store the data. [import]uid: 9440 topic_id: 22135 reply_id: 88026[/import]

#3

As J.A. said, Please read the forum rules RE using proper post titles, specifically point 3 :wink:
http://developer.anscamobile.com/forum/2011/05/05/forum-rules-and-guidelines

This is possible in Corona, I asked another member of the team for some input, he says;

"This can be done using network.request API. There needs to be some code on the server (e.g., PHP) to receive the data from his app and write it into the SQL database. This is a not a limitation of Corona, but how the SQL database is updated.

There are issues with “SQL injection” in general, and precautions must be taken to protect the SQL database and the server from the data to be written into the database."

So, very similar to the above :slight_smile: [import]uid: 52491 topic_id: 22135 reply_id: 88051[/import]

#4

I’ll echo what Jay and Peach said, having some web based scripts that can access the database and scrub your submissions is by far the easiest and best way to do this.

But if you’re insistent and your database ports are exposed (bad security btw), you can use TCP/IP sockets with Corona and read and write directly from the database. But your code complexity will go up by an order of magnitude and did I say its bad security to do that?

But it’s possible. CoronaSDK network socket code is pretty solid, but like any direct TCP/IP socket code, it’s not for the feint of heart.

[import]uid: 19626 topic_id: 22135 reply_id: 88060[/import]