Customer has existing Wordpress Site. Customer is Medical / Dental practice.
Wants to add features to the site, including:
Check appointment availability
Make an appointment
Cancel appointment (within 30 days)
Make a payment
Schedule a future payment
Cancel a future payment
Add, remove, or modify payment method
Update contact info
Upload / Update / remove documents (images and pdfs)
A different backend will need to be made for the office staff to edit customer info, appointments, and to print reports.
Can I write custom php code to access a different MySQL database (not the WordPress MySQL) on the back end & integrate it with the Word Press site? Or are there existing WordPress "plugins" that provide this kind of functionality?