I have a client in the medical services field who needs a database driven website to enable their customers to book appointments online and view their records. Their current system runs on FoxPro. What I would like to know is:
- What would be the best way to access the data from the website? 1: Have a connection between the webserver and their system. 2: Have the system data uploaded to the webserver periodically?
- Is their any software that can automate this?
- Has anyone had any experience in doing this (not necessarily FoxPro)?
Seeing as you will be taking bookings, which I assume occurs offline as well as through the website, you will need to use one database (otherwise two people could double book, one offline and one through the website).
If you are using FoxPro, I think you need PHP's DBase functionality, but you would be much better off with a multiuser database server such as MySQL, Interbase, etc.
I'm afraid I don't know any particular software you can use, save perhaps for phpMyAdmin.
"If youíre not using valid HTML, then you havenít created a Web page. You may have created something else, but it isnít a Web page." - Joe Clark