I guess this is something simle for someone who is a bit experienced. Firstly I ll say what is my target with this and then what I am asking for. My target is to make a simple web based application and put it up on the internet so that a doctor will access it and add his customers, scheduled appointments and follow up for these [url removed, login to view] web files for this will be uploaded from me (I have the server background ready,) and I will also run the sql code for creating the database tables on a Mysql db that I will create on my server. What you need to do is:
a) Create 3 database tables:
1)Customers (Customer_ID=numeric-the table primary key), (Name&Surname=text), (Date of birth=date),(AMKA=numeric), (Phone=numeric), (Mobile=numeric), (Street & number = text), (City=text), (Email= text), (Main Comments = text)
From the above only Customer_ID will is not allowed to be empty will submiting a new customer
2)Appointments (Appointment_ID =numeric-the table primary key) (Date = date), (Customer_ID= taken automatically when the user will pick the customer), (Comments = text), (Done = binary) , (Cancelled=binary)
3)Medical history (Medical_history_ID =numeric-the table primary key)( Customer_ID = taken automatically when the user will pick the customer) , (Comments=text)
Create the below web pages:
It will have 3 buttons - "Customers" , "Appointments" , "Quich search"
When the user clicks on "Customers" it will open a page that will have a search field so that the user will be able to search for customers using all the fields found in "Customers" table. It will also have a button "add customer" so that he will be able to add customer.
The search results will give a catalogue with customers and the user will be able to click next to their name the buttons: "review". After this he will go into the customers page where he will be able to click and see all the appointments history and also medical history (using data from the tables mentioned above).
When the user clicks on "Appointments" he will be able to search for Appointments from the search field (using all the fields from the appointments tabel)
It will also have a button "add appointment" so that he will be able to add appointment.
The search results will give a catalogue with appointments and the user will be able to click next to them the button: "review". After this he will go into the appointment page where he will be able to click and right down comments about the appointment, make it "done" , cancel it, change its date etc. (using data from the tables mentioned above).
This is it! I will also provide some mockups regarding the above. The layout will be the simplest [url removed, login to view] someone believes that he could make this using some other tool rather than php and mysql I could listen to any suggestion.
24 freelancers are bidding on average $49 for this job
Hello kerville7, I have read your requirements, I'm a PHP/MySQL Expert and I am very confident to do this project. I guarantee COMPLETE satisfaction before payment. Please check PM for more details!