khan.sikki Posted December 7, 2016 Share Posted December 7, 2016 (edited) i learned php, mysql and css from w3schools and designed my personal website www.sikki.in and got stuck-ed at complex part of designing cinema online ticket reservation system to multiple located screens for exhibitor and producer. i am using php and mysql for Back end, but problem in designing Front end system like generating seats dynamically and mapping seats with rows and column please assistance in making a "how to" for this details : in screen table all the particulars of screen will present like no. of classes in screen, no. seats in each class, screen location, ticket price etc booking table will have all the details of ticket booking details like movie name, screen name, show date, show time, booking status, reserved by(exhibitor username) etc seats table will have all the details of screen_id, no_rows now of columns Edited December 7, 2016 by khan.sikki Link to comment Share on other sites More sharing options...
Ingolme Posted December 7, 2016 Share Posted December 7, 2016 Is there a question or are you just asking somebody to make that? Nobody is just going to build such a complex system for you without compensation. Link to comment Share on other sites More sharing options...
khan.sikki Posted December 7, 2016 Author Share Posted December 7, 2016 (edited) Thank you very much for the reply brother i think forum is here to solve the complex things by discussing i am not asking to prepare this design, where as i am asking to assist where i stuck, as i designed the site learnng from w3schools asking to help as i was confused a bit in generating seat layout dynamically (front end) how to dynamically generate the seat layout based on the rows retrieved from the seats DB table here screen, rows and columns details will in seats table, screen details will be in screens table and booking info will be in booking table regards Edited December 7, 2016 by khan.sikki Link to comment Share on other sites More sharing options...
Ingolme Posted December 7, 2016 Share Posted December 7, 2016 The question is still not specific enough. How do you want to display the seats? Are they images? Text? What HTML structure do you want to use? Furthermore, what is your current database structure and what code have you written so far? Link to comment Share on other sites More sharing options...
khan.sikki Posted December 7, 2016 Author Share Posted December 7, 2016 (edited) in general every one uses check boxes or images to display as seats www.sikki.in is my website i am using php and mysql storage engine is Myslam Edited December 7, 2016 by khan.sikki Link to comment Share on other sites More sharing options...
justsomeguy Posted December 7, 2016 Share Posted December 7, 2016 You can do something as simple as a table layout with a bunch of checkboxes or something, or something more complex like a canvas element with a drawing of the seats where they actually are in the auditorium (assuming it isn't laid out in a perfect grid like a table structure). That is design, it's up to you to design it to look how you want it to look, and then you can figure out how to build your design. Link to comment Share on other sites More sharing options...
khan.sikki Posted January 25, 2019 Author Share Posted January 25, 2019 seating should be retrieve from the rows and columns of database Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now