How do I remotely updating my database?

OldMoon

First, I need to provide clients with their inventory and order status. I plan on using PHP to pull the data from mySQL on a 3rd party web server and display it to the customer via their browser. That part is easy.
Secondly, I want to periodically run a program at my company to get up to date inventory and order status information from my ERP system. That part is also easy.
Third, I want my program that I am running at my company to then send this data to the PHP server in the first item above to update it's data. I have no clue how to do this!
What technology or methods do I use to accomplish this? Does PHP provide a mechanism for this? What do I need to do in my program running on my company's side. Beholden and grateful to anyone who can point me in the right direction.

dalecosp

That's a huge project for a small/one-man team. How I know this: www.ombe.com/ezlink

The good news, perhaps: MySQL servers can be accessed remotely, so if you can write "a program at my company to get up to date inventory and order status information from my ERP system", you can, perhaps even during that process, hold open a handle to "the PHP server in the first item above", and write that data.

NogDog

Depending on the nature and amount of data, it might be sufficient to just have an API endpoint you can use to send input and update (and delete?) requests to, and then build a script on the "local" side to read your new data and call the API.

Or you could simply(?) dump your data to a CSV file, then post that to an endpoint that will either read/process that file, or just do a load data infile MySQL command. Alternatively, you could SFTP that file to the server, and have a cron job watching for new files and which would then process the CSV file when found.