How can I have different seat selection for different day

Question

1.00/5 (2 votes)

See more:

I have a database which contains 2 screen tables which contains seats of show which can be 1 or 0 according to selection.
every thing is working fine, when i choose a ticket for a day at a particular time seats get booked and all.
But suppose i booked a ticket for 25 June 2017 of 8:30 show the seat will get selected . but after that when i search for the same show but on date 26th June 2017 or any other date it should not show that it is booked but it shows it is booked.

how can i overcome this problem without using much space n easily cause rest of the program is running perfectly

What I have tried:

i didn't tried anything cause i don't have any clue about how to achieve this. i just cant go on making different screen table for different days it ain't feasible.

Posted 25-Jun-17 3:10am

chinu1d

Updated 25-Jun-17 4:20am

Add a Solution

Comments

Michael_Davies 25-Jun-17 9:41am

A lot depends on your database design. In order to understand people would need to see the schema and how you are booking.

You could have a table with a field per seat and a date field one row per day. High disk cost and data transfer.

You could have a master table holding the date joined to a table by and id field with just the id and a field to hold an integer for the the seat number; if the record exists then the seat is booked if not it is free. This would keep the disk space usage down.

chinu1d 25-Jun-17 9:49am

Thank you, helped a lot

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2017-06-25T04:20:00

Solution 1

Here is a Cinema data model that might be of interest to you: Cinema Bookings Data Model[^]
This one is for theatres, but misses an important comment about table usage: Data Model for Theater Bookings[^]
What database are you using ?

Posted 25-Jun-17 4:20am

RickZeeland

Updated 25-Jun-17 4:24am

v2