I am creating a scheduling webpage where users can schedule meetings in a calendar, and have just gotten to writing the backend. The front end is basically complete, and I have created a database for it, but I am not sure how/where my HTML and PHP should interact. Currently, I have an html file (my index) and 3 javascript files that help with some dynamic features on my page. I know the code I need to INSERT, RETRIEVE, UPDATE, and DELETE from my database using PHP, but I am not sure WHERE this should go?
Should I have a separate php file with functions I call from my HTML file? For example, if I want to update a table with a meeting time and meeting description, should I make a function in a database.php file: function updateMeeting(meetingTime, meetingDescription) { ..... } and call database.updateMeeting(meetingTimeData, meetingDescriptionData); from my HTML file?
Or should I put all my HTML information into a php file and just intersperse snippets of php to manipulate the database?
Basically: Where do I put the php code to work with my database for my webpage?
I understand I am a beginner and may have some false assumptions even in my question, so please bear with me! Thank you
