clbrown68 Posted March 22, 2009 Share Posted March 22, 2009 Hi there, I wonder if someone can point me in the right direction? I'm a complete newbie to PHP and database management systems. I do the general web design for my work but a new challenge has come up and this is where I need some advise please. We are a DMC and we need to go live with an on line booking form that has a choice of multiple hotel options for clients coming to our island and been able to book a room in the time of the conference been held. Here is the link to the form. http://www.alpinemalta.net/onlineForms/APV/PBPform.html What I need help in is the following. Is there a ready made database system like MRBS that I could get hold of that can act as the backend to this form? What I would need is that when the user chooses which hotel they want it automatically checks the database to see if there is any rooms available for that time period and answer yes or no for availability. Is there anything out there that can do it? Look forward to hearing any advise please - cheers Christopher - (Malta) Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/ Share on other sites More sharing options...
FaT3oYCG Posted March 22, 2009 Share Posted March 22, 2009 There is probably something similar that someone has created along the line but the will have done it themselves as they had customised requirements just like you do. Any off the shelf package that you may find wont ever be 100% what you want and most of the time they take more time and effort to modify than learning how to or just creating your own. Most off the shelf packages will be generalised which is why they usually need modifying and im pretty convinced that you might aswell just create you own custom built package yourself to cope with this specific task. You can create a databse for that yourself quite simply as it does not require much data to be held. I would go about it like this: 1. normalise: figure out what tables you need - any repeated feilds that are in two tables should either be in one or the other and if not then they should be in another table on their own. 2. create a databse connector: simply connects to the databse - create functions that you can access when you include the file into a script. 3. create a file to analyze the form data: see if it has all been entered correctly etc. - then use the database connector to connect to the database and query the data to see if the accomodation is available if so ad the data to the database otherwise simply report to the user. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790759 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 Hi there - thanks for the answer - but as I said I'm a newbie and this all went right over my head Could you possibly explain it more easily - I know - I'm being like an idiot....but I have the mind for graphic design and not for databases and programming.... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790760 Share on other sites More sharing options...
Yesideez Posted March 22, 2009 Share Posted March 22, 2009 If you're a complete newbie to PHP and databases then your course of action could probably decide how urgently something like this is required. If this is needed tomorrow and finances are there you could post a request in the "PHP Freelancing" section of these forums and ask someone to make it for you. If you're lucky and have time on your side then learning everything yourself would ultimately be the best option as you'll be able to make changes yourself without having to pay someone else. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790763 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 Well I would prefer to learn to do it myself.....As we are not making much money out this project I dont think finances will be much of an option.... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790771 Share on other sites More sharing options...
Yesideez Posted March 22, 2009 Share Posted March 22, 2009 Have you got any prior programming experience? If you've used HTML before you'll know that it's purely for formatting stuff to appear in a browser. When you use PHP you're writing scripts (small programs) to parse data and build HTML depending on what circumstances you want. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790772 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 What your asking is fairly simple. unfortunately you said you want to do it your self, and it sounds like it needed know. i say unfortunately because the truth is even php programmers that have been programming for 6 months couldn't achieve this sort off project. learning php is not a language that you just say i got a i dear now let create the project off the top off your head. 1. your have to learn mysql. 2. php this really does not seem a project to dive, into to learn php sorry. that unless you got a month or two. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790774 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 Well I do have some html experience and presently learning php which I'm finding pretty tough....but previously I made a website that included the MRBS - which a friend of mine installed for me... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790781 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 my database contribution. please remember your need a admin page to add the hotel info your self. This database structure does not reflect your web site information, your need to do that your self, it a simple example of a normalized database table for a hotel booking system. i love the web site Theo grate page. (very nice lay out.)) will need extending Theo. table hotels hotel_id hotel_name hotel_rooms hotel_date table conference room conference_room_id hotel_id bookings_id conference__date table bookings bookings_id bookings_name bookings_surname business_name bookings_date Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790782 Share on other sites More sharing options...
FaT3oYCG Posted March 22, 2009 Share Posted March 22, 2009 well the link that he provided looking at all of the booking dates is until 2010 so im sure he could spare a coupple of months to figure this out not that it should take that long, there is plenty of documentation on php and mysql aswell as the functions on the net the starting place of all learning should be w3schools.com and then from there you learn from things that other users have created and then you lean from doing things yourself. this really is quite simple all you need to know is how to access a database and manipulate the data which means that all you need to do is basically just learn the functions. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790783 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 Well - this form go's live in the middle of next month. thats when the people will be able to start booking the accomondation for next year.... I just wish there was a pre-made system like the MRBS..... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790787 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 If it was not mothers day i would off done this just for fun, so sorry, i am guessing because it a easy task, and all database, and a little php involved, someone will do it for you here and now. but if i get home, and it not done, i shall have a bash promise. this is only because your html is smart and correctly presented. see how php controls my life, i don't cot roll php it got me. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790788 Share on other sites More sharing options...
Yesideez Posted March 22, 2009 Share Posted March 22, 2009 this is only because your html is smart and correctly presented. I agree - makes a change to see such well-written HTML. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790791 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 Yesideez mate, I thort i was at the desk off my collage looking at that page years ago lol. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790795 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 getting upset now, you got a thou mistakes sunny, but it a very nice page, correct them before i get home to much of a simplistic web page to have warnings or errors. http://validator.w3.org/check?uri=http%3A%2F%2Fwww.alpinemalta.net%2FonlineForms%2FAPV%2FPBPform.html&charset=(detect+automatically)&doctype=Inline&group=0 tears are coming from my eyes seeing them errors and warnings. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790798 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 wow - thanks for the compliments - really appreciate it - I just follow what I've been taught. I bought a few tutorials through learnwebdevelopment.com but if it was such a simple task as previous posts have said I wish to learn how to do it... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790800 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 You trust me, If you carry on scripting like that and learn php/mysql and seo your be a professorial programmer. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790803 Share on other sites More sharing options...
Yesideez Posted March 22, 2009 Share Posted March 22, 2009 You were lucky - never studied HTML at college, only Pascal and BASIC - the web wasn't around back then! As for the validation errors I wouldn't bother about them too much they can easily be fixed. Line 33, Column 23: there is no attribute "background". Can be fixed instantly with CSS. Line 734, Column 75: character "&" is the first character of a delimiter but occurred as data. Just replace every & with & to fix this. Line 772, Column 76: required attribute "alt" not specified. Even if an image doesn't have an ALT talg - create an empty one - XHTML is fussy like that. Line 88, Column 34: reference to non-existent ID "label". That label seems to have a bar/pipe symbol there instaead of a lower case L. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790805 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 Hi there - wow - thanks for the advice - will make the changes when I get back to the office tomorrow. APPRECIATE the help with the HTML. Now I still need to find a solution to the my database challenge.... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790808 Share on other sites More sharing options...
FaT3oYCG Posted March 22, 2009 Share Posted March 22, 2009 not to be picky but i got this from my normalisation, i might be wrong but i have been taught to do it this way and unless I'm missing something id say that my word can be taken that it is right, for a fully formatted word document download the attachment Observations: Information is stored on: - Customers - Hotels - Conference Rooms - Bookings 0NF: Fields(Gender, First Name, Family Name, Passport no / ID Card, Institution Organisation or Company, Department, Job Title, Address Type, Address, Postcode, Country, Telephone no, Mobile no, Email Address, Visa or Master Card Number, Holders Name, Expiration Date, Conference Room, Type of Room, No of People, Price, Hotel Name, Star Rating, Number of People, Date of Arrival, Date of Departure) 1NF: Can't be bothered, most useless NF stage I have ever seen. 2NF: Customer(Customer ID, Gender, First Name, Family Name, Passport no / ID Card, Institution Organisation or Company, Department, Job Title, Address Type, Address, Postcode, Country, Telephone no, Mobile no, Email Address, Visa or Master Card Number, Holders Name, Expiration Date) Hotel(Hotel ID, Hotel Name, Star Rating) Conference_Room(Room ID, Conference Room, Type of Room, No of People, Price) Booking(Booking ID, Number of People, Date of Arrival, Date of Departure) 3NF: Customer(Customer ID, Gender, First Name, Family Name, Passport no / ID Card, Institution Organisation or Company, Department, Job Title, Address Type, Address, Postcode, Country, Telephone no, Mobile no, Email Address, Visa or Master Card Number, Holders Name, Expiration Date) Hotel(Hotel ID, Hotel Name, Star Rating) Conference_Room(Room ID, Hotel ID, Conference Room, Type of Room, No of People, Price) Booking(Booking ID, Customer ID, Hotel ID, Room ID, Number of People, Date of Arrival, Date of Departure) p.s. nice to see a HTML coder that works by hand and not with a generator you have my respect for that. [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790810 Share on other sites More sharing options...
Yesideez Posted March 22, 2009 Share Posted March 22, 2009 Just noticed - Requesting credit card numbers? I'm not sure of the law in Malta but here (UK) if you record these details the server containing the data must be physically locked in a cage and loads of other stuff. Best look into it before starting as this alone could be a significant cost involved. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790812 Share on other sites More sharing options...
redarrow Posted March 22, 2009 Share Posted March 22, 2009 FaT3oYCG you picking on me i can smell it joking, my table was a 1 sec attempt and for a 1 sec out off the brain attempt was good i say as a example. Just noticed - Requesting credit card numbers? <<< not allowed use a paying gateway. paypal or google. never hold any body's personal banking details it a night mere. dont need to be accessed of any think trust me. The best advice on this forum/posts today wish every body would lesion. Just noticed - Requesting credit card numbers? I'm not sure of the law in Malta but here (UK) if you record these details the server containing the data must be physically locked in a cage and loads of other stuff. Best look into it before starting as this alone could be a significant cost involved. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790815 Share on other sites More sharing options...
clbrown68 Posted March 22, 2009 Author Share Posted March 22, 2009 The credit card thing is no problem... we are going to get an SSL certificate and use one of 3 options: Payment Processor Payment Gateway or Process the payments ourselves... Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790817 Share on other sites More sharing options...
Yesideez Posted March 22, 2009 Share Posted March 22, 2009 I was going to mention SSL myself but thought it'd crop up in the "best research it" bit. Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790818 Share on other sites More sharing options...
FaT3oYCG Posted March 22, 2009 Share Posted March 22, 2009 lol, nah, i had already started doing that n then i saw that you had posted while i checked back when doing it haha. erm n yeah im not very legally aware myself but i wouldnt want to give my credit card details to a company like this you should make them pay a small deposit instead that may be refunded or taken away from the full ammount when they have completed the transaction. and then yuo made your post, but mine is still relevant, i would not trust a small organisation with my bank details Link to comment https://forums.phpfreaks.com/topic/150543-php-multiple-hotel-room-booking-system/#findComment-790819 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.