Who has made the appointment of registered doctor scheduling procedures, give a train of thought.

An online appointment registration, in the Doctor row scheduling, you can customize the number of times can be reserved for each time period, of course, the time period can also be customized, I here time is one hours, such as 8:00-9:00.......17:00-18:00, 8 hours a day into 8 time periods. The scheduling time is from Monday to Sunday. Who gives a specific idea, thank you.

Reply to discussion (solution)

First with a??????? Paragraphs and each??? Can I have the most?? , or with?? Tables are also available.
For example, every??? Paragraph only?? 20 people.
$t = Array (
Array (' 08:00 ', ' 09:00 ', 20),
....
.....
Array (' 17:00 ', ' 18:00 ', 20),
);

Then, use a table???? Man, the approximate field is as follows
ID self-increment
What is mid used for? ID or what's the only identity?? West, or email can also, with?? Check if it weighs??? Use.
Date Dates
T?? In the???? can also be
Num?? People?

Do you want to be a good judge? Is it permissible to????? If so, what is the sentence???? Is the paragraph????, if not? Add a???。

For example, there is a 8:00-9:00???? The paragraph??? Sentenced?.
Select num from table where date= ' 2014-06-10 ' and t=0;

If the returned NUM is less than 20,?insert.

If you want to add a cancellation?? function, can also? 10 minutes before 9:00? cannot be canceled,??? Good. Probably the idea is??。

If the Monday and Sunday, etc. can be???? Different, that $t????? One more, the key to the week. If it is?? Build??? Table for easy management.

$t = Array (
' MON ' = = Array (
Array (' 08:00 ', ' 09:00 ', 20),
....
.....
Array (' 17:00 ', ' 18:00 ', 20),
),
' TUE ' = Array (

)
);

First design database, table Doctors (doctor), form order (appointment), table work (schedule)
Each time the reservation number is generated, the first to retrieve the schedule, the schedule if the day is not created, first create.
You can manually modify the settings by scheduling additional tables.

The kind of upstairs, although reasonable, but you can not guarantee that the doctor that day that point will work, may encounter certain circumstances do not work or delay
So can't write dead in the program.

The time period of time, stored in the database or array, as a category processing, when scheduled, select the category.

Learn a bit ~

First with a??????? Paragraphs and each??? Can I have the most?? , or with?? Tables are also available.
For example, every??? Paragraph only?? 20 people.
$t = Array (
Array (' 08:00 ', ' 09:00 ', 20),
....
.....
Array (' 17:00 ', ' 18:00 ', 20),
);

Then, use a table???? Man, the approximate field is as follows
ID self-increment
What is mid used for? ID or what's the only identity?? West, or email can also, with?? Check if it weighs??? Use.
Date Dates
T?? In the???? can also be
Num?? People?

Do you want to be a good judge? Is it permissible to????? If so, what is the sentence???? Is the paragraph????, if not? Add a???。

For example, there is a 8:00-9:00???? The paragraph??? Sentenced?.
Select num from table where date= ' 2014-06-10 ' and t=0;

If the returned NUM is less than 20,?insert.

If you want to add a cancellation?? function, can also? 10 minutes before 9:00? cannot be canceled,??? Good. Probably the idea is??。

A little dizzy, I don't know what you mean.

LZ with the plan of the 3 floor. In fact, your needs are nothing more than to figure out what doctors, schedules, and appointments are. Be flexible with database operations.

Since complexity is done with data sheets, it is easy to manage

The data table is structured as follows:

Doctor table, record doctor information
doctor_id Doctor ID PK
Name Doctor

timeline table, record each doctor every day each time of the information that can be scheduled, this need to do once a time to add and delete, new add new Date appointment time, delete expired. The week is useless, because it is better to use the date directly.
Tid Timeline ID PK
doctor_id Doctor ID FK
Date Dates
Quota number of people allowed to book
StartTime Period Start Example 8:00
Endtime Period End Example 9:00
Status whether the session is allowed to reserve 0 No 1 allow

Order Reservation form to record user's appointment
order_id Appointment ID PK
UserID User ID--Membership system This is your own wish FK.
TID Appointment time ID FK
Addtime Appointment Time

Process:
First enter the doctor and timeline data, as follows

A total of two doctors
doctor_id Name
1 D1
2 D2

In 2014-06-11 this day of the class, Doctor1 8 time period full, Doctor2 only 6 time period need to work
Tid doctor_id Date quota starttime endtime status
1 1 2014-06-11 10 08:00 09:00 1
2 1 2014-06-11 10 09:00 10:00 1
3 1 2014-06-11 10 10:00 11:00 1
4 1 2014-06-11 12 11:00 12:00 1
5 1 2014-06-11 12 14:00 15:00 1
6 1 2014-06-11 8 15:00 16:00 1
7 1 2014-06-11 10 16:00 17:00 1
8 1 2014-06-11 5 17:00 18:00 1
9 2 2014-06-11 10 08:00 09:00 1
10 2 2014-06-11 10 09:00 10:00 1
11 2 2014-06-11 10 10:00 11:00 1
12 2 2014-06-11 12 14:00 15:00 1
13 2 2014-06-11 10 16:00 17:00 1
14 2 2014-06-11 5 17:00 18:00 1


Appointment
The first user useid=1 to make an appointment 2014-06-11 11:00~12:00 Doctor1
First, determine whether the record of doctor_id=1 date=2014-06-11 starttime=11:00 endtie=12:00 quota>0 in timeline is present
If it does not exist, return to the prompt without an appointment or the quota is full
If there is
1. Add a record to the order table
order_id userid Tid addtime
1 1 4 2014-06-09 10:29:29
2. Timeline Tid=4 's quota-1, the record will become

4 1 2014-06-11 11 11:00 12:00 1

The process is like this, it should be clear.

Can not afford to read everyone, the recent business trip, yesterday only came back, looked at the next 8 floor method, so that every time to add a time, and are manually input data, if by week, that no one weeks to update. It's like Time is written dead.

Can not afford to read everyone, the recent business trip, yesterday only came back, looked at the next 8 floor method, so that every time to add a time, and are manually input data, if by week, that no one weeks to update. It's like Time is written dead.

?? No, it's dead. What are you? Need to work in order to add to the class list.

Can you set up the schedule and? Class table.

For example, health A, every Monday ~ five are 8:00~12:00 work. Can I have one more? Table??? Schedule, and then another table???? Class table.

For example, today, Monday, Normal is 8:00~12:00 A to work, but?? Something needs to be changed into an afternoon 14:00~18:00.?? Just put 14:00~18:00 into today?? Class table. However, today there is a sentence. The class watch, the press?? Ban Bu to??。 No, according to the schedule of the course? Can. What is the approximate idea?? The

Can not afford to read everyone, the recent business trip, yesterday only came back, looked at the next 8 floor method, so that every time to add a time, and are manually input data, if by week, that no one weeks to update. It's like Time is written dead.

What exactly do you want to do? Get the idea straight!
Aren't you an "appointment"? How could it be the same every week?
If I had an appointment tomorrow, would tomorrow also be effective? The date is, of course, dead!

I only need 7 days to cycle, the same day to make an appointment for tomorrow, for example: 2014-6-25 (Wednesday)? 2014-7-1 (Tuesday), no matter how the Schedule I was 7 days, the specific how to reflect it, according to your method I do not know how to reflect on the page and program.

Can not afford to read everyone, the recent business trip, yesterday only came back, looked at the next 8 floor method, so that every time to add a time, and are manually input data, if by week, that no one weeks to update. It's like Time is written dead.

?? No, it's dead. What are you? Need to work in order to add to the class list.

Can you set up the schedule and? Class table.

For example, health A, every Monday ~ five are 8:00~12:00 work. Can I have one more? Table??? Schedule, and then another table???? Class table.

For example, today, Monday, Normal is 8:00~12:00 A to work, but?? Something needs to be changed into an afternoon 14:00~18:00.?? Just put 14:00~18:00 into today?? Class table. However, today there is a sentence. The class watch, the press?? Ban Bu to??。 No, according to the schedule of the course? Can. What is the approximate idea?? The

In this way, you do the first row of a day, and then change it to a 7-day cycle.

In this way, you do the first row of a day, and then change it to a 7-day cycle.

Do you think that way I can understand that? I made this, this is the 7-day automatic cycle, the time of day and the number of people custom, but how to write this SQL statement? Trouble you, the first customer dissatisfied with the idea, the Philippines made this get

Fields:
Date, experts, session 1, Session 2 ... Session 10
That is, each expert records a daily

Fields:
Date, experts, session 1, Session 2 ... Session 10
That is, each expert records a daily

In that case, it's not a daily schedule.

Why is it?
It's just that every day in your form (#14) is saved as a single record.
If your form is set for a week, then you can save it as 7 records by the day after submission.

Why is it?
It's just that every day in your form (#14) is saved as a single record.
If your form is set for a week, then you can save it as 7 records by the day after submission.

In that case, the time to save is to insert the data (or arrays) with multiple loops, and I want to save the period and the number of people for each time period.

First of all, what's the main thing????? Paragraphs and??? Zhenyun??? Or the other information is provided by each?? The family own? Placed

What if it's the home? OK??
First you?? There was a??? The Configuration information table for the segment,???? Geru 8.00, 9.00 or half? Small, such as 8.30, 9.00, 9.30, etc., per??? is a???

And then the home is in? All listed?, by the birth of their own to decide??? Paragraph, such as 8:00-9:00, permissible?? People, etc information, set up and then enter??

Patients looking at the information, the last seven days of the home? Paragraph and phase information?

First of all, what's the main thing????? Paragraphs and??? Zhenyun??? Or the other information is provided by each?? The family own? Placed

What if it's the home? OK??
First you?? There was a??? The Configuration information table for the segment,???? Geru 8.00, 9.00 or half? Small, such as 8.30, 9.00, 9.30, etc., per??? is a???

And then the home is in? All listed?, by the birth of their own to decide??? Paragraph, such as 8:00-9:00, permissible?? People, etc information, set up and then enter??

Patients looking at the information, the last seven days of the home? Paragraph and phase information?

I have this system set up, discouragement after the doctor to do their own scheduling.

If your input box is named in this form:
Session 1
Session 2
Does it all correspond after submission?

If you are extending with mysqli or PDO, you can loop through the parameters and have no overhead
It's not difficult to assemble a command string with MySQL.

For system compatibility, it is best to save the database in a separate setting each time of the day.

If your input box is named in this form:
Session 1
Session 2
Does it all correspond after submission?

If you are extending with mysqli or PDO, you can loop through the parameters and have no overhead
It's not difficult to assemble a command string with MySQL.

You this way I am confused, do not know that I am dead, or do not understand this, again

If one is so kind, just write me a code, please, problem solved, I'll add 50 points.

What do you know about the idea??

If you do not understand, even if you do, it is useful.

No one wants it?

What do you know about the idea??

If you do not understand, even if you do, it is useful.

What do you know about the idea??

If you do not understand, even if you do, it is useful.

Everyone to help see this thing, http://jcy.xys.gov.cn/has been put to the server, how or local path, this solves my knot to points, dragged time too long, sorry everyone.

You're in the template? Http://localhost/xyjcy_network/templates/default/images/xjweibo.jpg

Can not afford to read everyone, the recent business trip, yesterday only came back, looked at the next 8 floor method, so that every time to add a time, and are manually input data, if by week, that no one weeks to update. It's like Time is written dead.

What exactly do you want to do? Get the idea straight!
Aren't you an "appointment"? How could it be the same every week?
If I had an appointment tomorrow, would tomorrow also be effective? The date is, of course, dead!

Moderator, ask the next
The doc file on the Web site is opened without prompting whether to download or open, directly open is garbled, do not know how this is going?

You did not send the downloaded headers?

You did not send the downloaded headers?

Files are directly uploaded by the editor, in the virtual space are good, put on the client server is not, open the content is garbled.

