Completed

2 simple php web pages and a Mysql db with 3 small tables

This project was successfully completed by aniketnt for $25 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $30 USD
Completed In
2 days
Total Bids
25
Project Description

Hello,
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:
1)Home
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online