how to make appointments

Hi all.

I'm having a problem in designing an e-clinic website for patients to make appointments with doctors. I built the login pages for the patients and doctors and am almost gonna do the dcotors' and patients' personal pages but I don't know how to do the appointments.
Is there any "all-purpose" appointments application with php and mysql that I can customise to my requirements somewhere?
Please help me out with this people.

Thanks in advance.
Sara

Hi sara!

Look, I don't know a tutorial or a ready-code for what you need, but I can help you to build that... give me more information about what you need and I'll help you.

Hi ramz

Ok basically I want to allow patients to MAKE and SEE their appointments with a doctor.They can only see their own appointments.

And I want to allow doctors to only SEE their appointments with patients.
The e-clinic is "open" from 9am till 5pm and an appointment is only 15mins.

I don't even know how to start.

Can u help me? Thanx a lot in advance.

Hi Sara!
Sorry for taking so long... Busy =)
I've made the files, please put them in your server and check to see if this can help you. Modify them to fit your needs. Anything else just message.

P.S.: To create the tables, use this command (put the appointment.sql file in your c:\):

mysql -uyour_user -p db_name < c:\appointment.sql

Before doing anything, please change the host, user, pass and db values at Line 91 of the db.Class.php to fit your MySQL configuration.

Hi!

Oh my god!
This is so much! I'm sooo sorry for the trouble I caused u!
This is a lot of code!
Oh thank u so much ramz!It's gonna take me a while to modify it to my site though!Hehe
I won't be able to start on it yet though cuz I'm having problems with the personal pages of the patients and doctors....these cookies are driving me crazy!

THANK U SO MUCH RAMZ! XXX

Sara

Hi Sara!
No problem... you didn't cause any problem... I took only 45 minutes to develop all of that...
About modifying it... if you have problems, message here, ok?!
About the cookies... I know that you have posted a message at the PHP Forum... please, post here what you want... the files you're using and I'll solve it for you, no problem...
Anything else, just message.

Hi Ramz!

I'm trying to modify your code so that it doesn't show the "pages",u knowthe first,previous,etc...I just want to display the appointments on their own.
Sorry for troubling u so much Ramz. Thank u so much for what u've done for me.
Sara

Hi Sara!
So, let me see if I understood. You don't want to show the navigation bar, right?!
Attached is a modification of the browse.php file. If there's anything else, message me, ok?!

Hiya Ramz!
Here it is!

Hi Sara!
All the files are on the zip file.
Put it in the www dir to run, ok?!
There is a file called tables.sql, you should drop the tables in your database and add this with all the data, ok?!
You need to modify 2 files:
eclinic/inc/db.Class.php - line 20 to your DB settings
eclinic/admin/inc/db.Class.php - line 20 to your DB settings

To add doctors and patients, go to the /admin/ folder.
Like this: http://localhost/eclinic/admin/
To run the system: http://localhost/eclinic/

Any problem, message me.
Regards,
Ramiro

Hiya Ramiro!


Here are the files I did till now.
Thank u so much.

Sara

I've been working on the appointment.php file to try to remove $txtId and import_request_variables("gp") and still make it work but I keep getting errors.

Thanks again Ramiro

Hi Sara!
I've made the changes in the appointment.php file and it's attached here. I took off the $txtId. The purpose of this variable is to update an appointment. The import_request_variables("gp") is easy... if you have globals on at your php.ini file, you can remove this line from your code, else leave it there, because this line do the same think as having globals on. I prefer this way because it gets easier to work on and you don't need to always keep using $_GET['vars'] or $_POST['vars']... it automactly imports the forms and query string variables to the code.
Anything else, send me a message. If you having too much trouble to change what I've made, install ICQ and we can online in a few hours do it all over again.

Hi RAMZ,

I know it's been awhile since this thread, but I'm looking to do the same thing that Sara is doing. Would you happen to have the files that you wrote for her laying around?

I really appreciate the effort.

Just to clarify, I'm wanting to create a website that patients can log into, then create an appointment to see the doctor of their choice (via drop-down box), and it emails the clinic, so they can follow-up with the patient at the clinics' convienance (to confirm), and the user can log in and see their appointments, create another, change their existing one, etc.

These are all of course the "big-picture" but I would like something moving us toward those goals.......

I have MySQL database server, and I can do all of the database setup stuff, just don't know where to start with the PHP, or whatever is easiest to use.

Thanks in advance,
-Eric Wall