In Progress

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

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.

We will need one more table in the database, that will store only one variable. It will be : Password_table , with only one field: "password" ---> text. In there I will put a password and the user would have to insert that specific password in a simple authentication page before entering the programm. The user will not be able to change the password. Also there will not be a "sign in" button. Only one password will exist for everyone. I will only know the password and in order to reset it I will do this directly from the database.

I also attach the mockups, please review them and provide your bids.

Skills: PHP, SQL

See more: what is my name in binary code, what is my name in binary, what is binary search in c, what is binary search, what is a binary search, simple mobile phone number change, simple mobile number change, simple binary code, simple binary, search the web phone search, mysql db, my name in binary code, my name in binary, mobile php files, make web say, follow up email after application, follow up after application, creating php table, create buttons for web pages, code for binary search in c, code for binary search, c code for binary search, c binary search code, bit binary, binary target

About the Employer:
( 8 reviews ) Kallithea, Greece

Project ID: #4899781

Awarded to:

aniketnt

Sir m ready to do ur project

$25 USD in 2 days
(0 Reviews)
0.0

24 freelancers are bidding on average $49 for this job

jsr3

I understand your requirements and ready to start right now. Please check your message box for more details.

$103 USD in 3 days
(65 Reviews)
6.3
prominentsoft

I can get it done.

$53 USD in 3 days
(61 Reviews)
5.7
hrarcon

Ready to work

$105 USD in 3 days
(10 Reviews)
5.5
it2051229

Hi, I would like to do this project please. let me know if you are interested. Thanks.

$30 USD in 1 day
(44 Reviews)
5.1
codemaster7

Hi, I would like to get this done with php, I've sent you more details. Regards, Andy.

$45 USD in 1 day
(20 Reviews)
4.3
eComOS

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!

$63 USD in 1 day
(16 Reviews)
3.6
barrima

hello, check pm

$35 USD in 1 day
(5 Reviews)
3.1
webhelp4u

Hi, I am a PHP programmer for past 4 years. This is a basic PHP application and I would like to help you out. Thanks

$44 USD in 2 days
(5 Reviews)
3.0
AliSafder

Hi, Let me do this job.

$35 USD in 3 days
(3 Reviews)
1.9
acmcoder

Hi Sir I am ready to work on this project, please see PMB

$25 USD in 3 days
(3 Reviews)
1.6
hellouniverse

Hello, ready to work on web pages/mysql db. Please see PM.

$40 USD in 1 day
(1 Review)
0.6
vermarenu

Dear Hiring Manager, I am Alok having more than five years of experience in web development and I'm very much interested in your job post involving these skills. I have experience with PHP, MYSQL, JOOMLA, MAGENT More

$111 USD in 3 days
(1 Review)
0.4
ashacm

I have 10+years of experience in software development. I have experience in PHP/Mysql . I wish to take up the task.

$66 USD in 3 days
(0 Reviews)
0.0
Aarti25189

i have already done such projects and have certification in php and mysql.

$45 USD in 3 days
(0 Reviews)
0.0
acutetech10

Here we like to specify our slogan "A Right Place For Pace". we have ability and tech to close your bid within that target time. we request you to have a glance at our Private Message. we would be glad to know that you More

$30 USD in 3 days
(0 Reviews)
0.0
sptechnocrats

done 50+ sites on [url removed, login to view] pmb for more details

$47 USD in 4 days
(0 Reviews)
0.0
DevelopUK

Please read PMB

$45 USD in 1 day
(0 Reviews)
0.0
galoxsoft

Hello, Ready to start now. We would like to work on this [url removed, login to view] have gone through your requirement and can finish it within time frame. we have a team who are best at their [url removed, login to view] are ready to discuss about your More

$25 USD in 3 days
(0 Reviews)
0.0
ksantosh2007

Lets start.

$25 USD in 3 days
(1 Review)
0.0
shairyareu

I am an expert in PHP, MySql, Javascript, JSON, AJAX, CSS, HTML and I can help you achieve your goal.

$111 USD in 12 days
(0 Reviews)
0.0