Lisa23 Posted June 14, 2011 Share Posted June 14, 2011 Hi wanted to create a booking system like http://gotobus.com/ or similar check the bus tickets form on the left side, which the user choose chose time a date of traveling from city, to city. then display availability list what i wanted to know is how do i create such system what i was thinking is do i fill out a whole database with travel details like california date and times bus leaving. new york date and time bus leaving and the form would it be like some if statments like (if from california else date else time display california bus timetable. like i said i really dnt know how the concept of a system like that would be done if anyone has done it or know the way it should be done can you please give some ideas of the logic/concept to create such system. or can a achive the system with just php or should i choose different language?? thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/239360-what-would-the-conceptstructure-to-create-a-booking-system/ Share on other sites More sharing options...
redixx Posted June 14, 2011 Share Posted June 14, 2011 MTA appears to have an API to do what you want. http://bustime.mta.info/wiki/Developers/SIRIVehicleMonitoring Dig around there. Quote Link to comment https://forums.phpfreaks.com/topic/239360-what-would-the-conceptstructure-to-create-a-booking-system/#findComment-1229650 Share on other sites More sharing options...
ignace Posted June 14, 2011 Share Posted June 14, 2011 If you are wondering how you would model this at a DB-level: driver (driver_id, ..) bus (bus_id, num_passenger_seats, ..) tour (tour_id, ..) schedule (tour_id, bus_id, driver_id, date, price) customer (customer_id, ..) booking (customer_id, schedule_id, ..) This should get you started. Quote Link to comment https://forums.phpfreaks.com/topic/239360-what-would-the-conceptstructure-to-create-a-booking-system/#findComment-1229702 Share on other sites More sharing options...
Lisa23 Posted June 14, 2011 Author Share Posted June 14, 2011 no i mean how will the form retrive the data from the database exacly based on the departure city and arrival city and dependeable on the date he choses like lets say the user chooses depart from california on the 6th july 2011 so the it should display alll the schedule accordingly with the departure city and date. so how would i set the database tables? just like how he retrives the schedule on this bus timetable http://gotobus.com/ Quote Link to comment https://forums.phpfreaks.com/topic/239360-what-would-the-conceptstructure-to-create-a-booking-system/#findComment-1229706 Share on other sites More sharing options...
ignace Posted June 15, 2011 Share Posted June 15, 2011 nvm Quote Link to comment https://forums.phpfreaks.com/topic/239360-what-would-the-conceptstructure-to-create-a-booking-system/#findComment-1229896 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.