December 29th, 2011, 07:47 PM
How to remotely FTP data to individual fields of MySQL database?
I have an embedded microcontroller with an iWiFI application that permits me to FTP data to a website via the internet. What I want to do is to FTP specific data items to specific fields in a remote MySQL database I have set up on a website. I currently do this by FTPing each of the data elements to separate .txt files on the website, but this then requires someone to login and refresh the webpage so that its .php file will run and read the new data values from the files to their respective fields in the database.
I want a more direct way of doing this so that the webpage doesn't have to be refreshed to execute the .php script that reads the .txt files into their database fields.
Can anyone advise me how to do this.
December 29th, 2011, 09:04 PM
You can use a CRON job or scheduled task to automatically run your PHP script on a regular basis.
December 31st, 2011, 08:04 PM
Thanks! I installed a cron job and will evaluate this as a solution.
Originally Posted by E-Oreo