So, I'm a beginner by using the ethernet shield so, I really need your help guys. Let me introduce my "problem".
I need to GET an information from an online website db. I know how to send information to it but, I have no idea how I can get any information from there. so..
I thought about to create a PHP page in Arduino web client and with it, to connect to the MySQL DB (online, not local) and pick the information. so, guys, please, how can I do it, any suggestion?
Of course it is all possible.
Start with a PHP page hosted on the same server as the MySQL database, which extracts the information you require. Test this from a normal web browser ( you give a command in the the example format mywebdb.com/myQuery.php?cust=123&order=999) to ensure it all works and you have solved access rights problems etc.
Once you have that, you issue the same url in the form of an HTTP GET command from the network connected Arduino, then parse the result set that is returned.
Once you have that, you issue the same url in the form of an HTTP GET command from the network connected Arduino, then parse the result set that is returned.
Actually, that is step 3.
Step 2 is to test the PHP script from a machine that is NOT in the same local area network as the server.