I’m a beginner PHP & MySQL user, but just curious.
A dental office I’m doing a website has a form for new clients on the contact page. I was wondering if this information could be sent to a database that the dentist can access through a login page. Is this possible? Would he be able to delete items in the database? How much work goes into this? I’ve seen a bunch of PHP/MySQL code for this, but wasn’t sure if I was getting in over my head.
Thanks,
Jeff
its possible, but it can be a lot of work and fustration if you don’t know what you’re doing. I’d start off with something simple, then go from there. You’re basically creating a custom cms.
So before you get to far into it, sit down with the client and see what needs to be accomplished with it. There’s not a whole lot thats more that’s more annoying than a client that changes things after the fact.
we are here if you need help.
The book Head First PHP MySQL has the exact thing you are looking for in their projects and shows step by step how to do it. You would just need to update some of it.
Jeffrey,
I always say, “Everything is possible in programming!” But, as Richei says, it can be very complicated.
Working on many sites that have a “front-end” for clients and a “back-end” for the administrators or the
owners, what you are talking about is standard these days.
But, again as Richei says, you should start out simple. Get the front-end going for the clients first.
Once all of your system is working and your data is storing and protected inside your database, then
work on a back-end page for your dentist or assistant to access. This would be really and admin panel
which would give access to all the data.
CMS systems prebuilt for this type of system are available for free. One common one that is used by
millions is the WordPress system. You might want to search around for a free WordPress system which
gives you control with a front-end/back-end type of layout. Something to think about.
As a beginning, a full fledged system for a dental office is a big job. A pre-built system might be easier for
you to start with. Good luck!