Suggest you get either of the beginning PHP+MySQL books that are listed in this article. The process you're describing is called "table maintenance" and it's one of the PHP 101 exercises that we all have to learn. In the books it will probably be a chapter or two, so as you can imagine it's not something we can teach in a back-and-forth email forum like EE. That's why I wrote the article. I believe that the Welling/Thompson might be the best choice. https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html
What I do is install rhe mySQL 5.1 ODBC Driver. Now you can create linked tables to the mySQL server tables. Now access sees the tables link any other linked table. You can create forms, reports, and queries against the linked mySQL tables as you normally would in Access.
NOTE: Your hosting provider myse allow remote access tot eh mySQL server. You will need to contact them to find out the connection settings to use when you set use the DSN for Access.
Our job here is to help you help yourself. Not write all of your code for you. If you can let us know exactly where you are at as far as programming skills and languages you are familiar with it would be a big help. We may need to break this out into multiple questions depending on what you are trying to do.
Please start by briefly detailing out what you want. Make a few static web pages or forms or wire frame. (how to make test cases http://sscce.org/) Let us know your skills.
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
https://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html