Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Kozan Fahri
Courses Plus Student 1,118 PointsHow to build a database similar to a hotel/travel website?
I am currently working on a project where I am building a website similar to that of a travel/hotel website.
I was interested to find out what type of back-end coding most of these website use (i.e. skyscanner, expedia, trivago, airbnb etc.).
I have studied the fundamentals of SQL and I am currently learning PHP on treehouse. I thought both of these would be enough to get started - but I am not sure. Aside from the front-end coding, is there anything else I should consider?
For clarity, I need a search function which allows the user to input dates and location and hit search. The relevant information will follow.
Any advice or tips would be greatly appreciated.
Thank You.
2 Answers
John Steer-Fowler
Courses Plus Student 11,734 PointsHi Kozan,
This is easily doable with any dynamic language, so you are able to use PHP to achieve this.
You could also use any language such as: Python, Ruby, Javascript etc
You will need to access a database, so you will need to know SQL, or use a framework such as Ruby on Rails or Django that takes care of this for you.
Also, you might like to know that many CMS, especially Wordpress has a lot of themes that you could set up in no time that have this functionality, you might find one that saves you from building a custom system.
I hope this helps
Good luck
John Steer-Fowler
Courses Plus Student 11,734 PointsHave a look at some of these Wordpress plugins (a quick search brought these up):
https://en-gb.wordpress.org/plugins/oganro-reservation-widget/ https://en-gb.wordpress.org/plugins/travelpayouts/ https://en-gb.wordpress.org/plugins/bookingcom-affiliate-plugin/ https://en-gb.wordpress.org/plugins/travel-search/
Kozan Fahri
Courses Plus Student 1,118 PointsKozan Fahri
Courses Plus Student 1,118 PointsThanks John.
Quick question on the "access a database part". I am fairly new to all this coding so excuse me if it is a silly question. I happen to have the MySQL Workbench available - is that another type of framework that I could use rather than Ruby on Rails and Django??
Thank You!
John Steer-Fowler
Courses Plus Student 11,734 PointsJohn Steer-Fowler
Courses Plus Student 11,734 PointsSQL is a language that allows data to be sent between the website and a database.
I don't actually have any experience with MySQL Workbench, I only use Ruby on Rails so I don't have need for it.
Frameworks for those languages are just pre-made structures that mean you don't have to build everything from scratch.
I hope this helps in any way. I recommend having a look into Wordpress. Search the plugins until you find something similar to what you are looking for, I am sure there will be something out there.