I have researched about this topic on forums, and know that this issue is faced by many. But the suggestions on forum is overwhelming, and out of my understanding therefore asking it again. Sorry.
My program talks well with the MySQL locally, but when I moved my "applet" folder to web server (is Java required to be installed?, I think its LAMP/supports CGI scripts only -- if Java is required? how to check if Java is installed in my web server? if not, please ignore this concern), and created MySQL database remotely, its not working. I wrote a PHP script, and created a Data.pde. Hardcoding something, my PHP script is talking well with the MySQL database. And, my Data,pde has the data (there are few variables - int and floats).
I am clueless how to make Data.pde talk with PHP script I have. If the variables' data can be sent from Data.pde to the PHP script, I think that would be done. Please help me with a code snippet if possible. I am on tight time constraints, quick help will be greatly/deeply appreciated. Thanks in advance.
Some database providers allows only local scripts (PHP or other) to talk to the database, ie. they block external accesses. Indeed, a solution is to talk to the PHP script which will access the DB. For this, if there isn't much data to transmit, you can use the GET protocol, with a simple loadStrings() by building an URL with the proper parameters, like http://www.example.com/p5/dbaccess.php?a=15&x=3.14
Leave a comment on PhiLho's reply
Change topic type
Link this topic
Provide the permalink of a topic that is related to this topic