Online Hotel Booking System
I want to build an online hotel booking system, where by people can book hotels online and make payment with a credit card. There will be extra goodies for registered members.
I want idea of how to go about this especiall with the online payment with the credit card. Online payment with credit card is something i honestly have no idea of it. I will be grateful if i can get explanation how to implement such a system or sample script.
View Complete Forum Thread with Replies
Related Forum Messages:
Checking Room Availability For Hotel Booking System
I was wondering if anyone could help me with a problem I'm having. I've been using Dreamweaver to create a hotel booking system for a friend of mine, using MySQL (version 4.0.21) and PHP 5. The bit I'm struggling with is checking the Room Availability based on dates that are typed into a textfield and then returning a list of the available rooms on the next page. The three tables involved in this function are: CREATE TABLE `room` ( Room_Number tinyint(1) UNSIGNED NOT NULL, Price_Double_per_Night decimal(5,2) NOT NULL, Price_Twin_per_Night decimal(5,2) NOT NULL, Price_Single_per_Night decimal(5,2) NOT NULL, Price_Double_per_Week decimal(5,2) NOT NULL, Price_Twin_per_Week decimal(5,2) NOT NULL, Price_Single_per_Week decimal(5,2) NOT NULL, PRIMARY KEY(`Room_Number`), ) TYPE=InnoDB ROW_FORMAT=fixed; CREATE TABLE `room_booking_link_entity` ( Room_Number tinyint(1) UNSIGNED NOT NULL, Room_Booking_ID int(11) NOT NULL, Single_Double_Twin enum('Single','Double','Twin') NOT NULL, PRIMARY KEY(`Room_Number`, `Room_Booking_ID`), INDEX `Room_Number`(`Room_Number`), INDEX `Room_Booking_ID`(`Room_Booking_ID`), FOREIGN KEY `Reference_14`(`Room_Number`) REFERENCES `room`(`Room_Number`) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY `Reference_85`(`Room_Booking_ID`) REFERENCES `room_booking`(`Room_Booking_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB ROW_FORMAT=fixed; CREATE TABLE `room_booking` ( Room_Booking_ID int(11) NOT NULL AUTO_INCREMENT, Customer_ID int(11) NOT NULL, Bill_ID int(11) NOT NULL, Date_of_Arrival date NOT NULL, Date_of_Departure date NOT NULL, Number_of_Nights tinyint(3) NOT NULL, Date_Booking_Made date, Status_of_Booking enum('Booked','Arrived','Departed') NOT NULL, Total_Cost decimal(7,2) NOT NULL, PRIMARY KEY(`Room_Booking_ID`), INDEX `Room_Booking_ID`(`Room_Booking_ID`), INDEX `Customer_ID`(`Customer_ID`), INDEX `Bill_ID`(`Bill_ID`), INDEX `Date_of_Arrival`(`Date_of_Arrival`), INDEX `Date_of_Departure`(`Date_of_Departure`), INDEX `Status_of_Booking`(`Status_of_Booking`), FOREIGN KEY `Reference_03`(`Customer_ID`) REFERENCES `customer`(`Customer_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION, FOREIGN KEY `Reference_14`(`Bill_ID`) REFERENCES `bill`(`Bill_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION ) TYPE=InnoDB ROW_FORMAT=fixed; I've just discovered that MySQL 4.0.21 does not support subqueries. I'm basically stuck with this version of MySQL. I think I've got round the subquery problem by using a multi query option as follows: 1.Create a temptable that will store all of the room numbers that have bookings for the particular dates requested as follows: SELECT DISTINCT a.room_number INTO temptable FROM booking_link_entity AS a INNER JOIN room_booking AS b WHERE b.departure_date >$_POST[‘ARRIVAL'] And b.arrival_date < $_POST[‘DEPART']; 2.Left join this with the room table and pull out rows with no match SELECT a.room_number, b.room_number FROM room AS a LEFT JOIN temptable AS b ON a.room_number=b.room_number WHERE b.room_number IS NULL; 3.Delete temp table I've tried doing this in Dreamweaver, but to no avail. I have a feeling it is too complex for Dreamweaver. My php knowledge is very basic and was wondering if anyone could give me some pointers as how to do this in PHP?.
View Replies !
Online Booking System
I've been scouring the web for an example, but just need pointing in the right direction. Ultimately I want to do this myself, just a simple booking system is required. Essentially how the system works is that when someone comes to the show they need a website assessing. The first stage is to select an engineer which will carry out the assessment. Once you have done this a screen appears with the available time slots with text fields which needs to be completed for that specific engineer to fill in the site requirements. An idea perhaps is to create an online calender which I've already coded so that they can click on a specific date, and on the same page the time slots available.
View Replies !
Mail Problem - Online Booking System For Equipment.
I am writing an online booking system for equipment. I want to be able to automatically email those who have booked equipment, say one or two days before to remind them of their booking. Does anyone have any ideas of how I could do this (I am familiar with the mail() function in PHP).
View Replies !
Hotel Inventory System
I am writing an application for a hotel booking service. I am trying to figure out the easiest way to create the pricing system. I need a little guidance on how to take a begin date and a end date and write to a seperate table the rate for each date. The rate at the beginning is the same for the range but they want to be able to go in an adjust the rate on the fly for a date, say for a rate change the hotel gives them.
View Replies !
Online Booking Calender
I wanted to put a calender on my website to allow people to see up coming clasess we have and allow them to booking/pay for them also. I would add them in the back end and how many spots are availble and when someone clicks on to pay for the class and checks out all the way it would subtract it from the total amount. I would also like it to show on the date when all spots are gone Sold out and when only one is left only 1 spot left. I would like to see if there is a script out already that does this now. I am new to php/mysql so it would be great to find this.
View Replies !
Booking System
I just wrote an incredibly complicated bookings system for a client, it worked marvelously. implemented in a cms & everything. The problem is: I needed to allow for cross year bookings, so I tried to implement that, thinking it would be easy. think again. The whole things gone gaga. Like the absolute moron I am, I didnt save it. does anyone have a suggestion for a script I can leech? Im desperate, ill lose my job if the presentation doesnt go off smoothly. I cant pay anyone, but id help anyone if they had a problem like this.
View Replies !
Booking System
I am trying to do a booking system concerning my project at the university(using PHP &MySQL)I am hasving the following problem: Code:
View Replies !
Ticket Booking System
I am prototyping a ticket booking system and just wanted to ask a few questions. 1 - What is the standard way of temporarily reserving a number of tickets throughout the purchasing process (to stop other people reserving those seats or whatever). 2 - What do you do to release these 'seats' if someone closes their browser? Is it just a cron job set for every 20 mins? I am sure I have seen a solution to this before but can't find it now.
View Replies !
Room Booking System
Loooking for a simple script to help reserve rooms in a building, 10 rooms where some times are booked week - on - week and also have two diffrent time tbale weeks?
View Replies !
Compare Two Dates In A Booking System
i want to compare two dates called booking_start_date and booking_end_date to make sure that the booking start date comes before the booking end date. at the moment both dates are just stored as dates in the mysql database. anybody know how i could do this? and also does anybody know how i can find the number of days that the booking is for based on the dates that the user has entered as it will be needed for me to calculate the price of their overall booking.
View Replies !
Wanted: Open Source Php Course Booking System
we are looking for a slim open source course booking system with the following features: * users can enroll for courses, cancel their bookings * maximum number of participants * administrator's pages: list of participants and their contact details (email, phone etc.) So far, we have found an extension to the mambo CMS http://mamboxchange.com/projects/akreservations/ and a rather smaller application (privately developed) However, are there better alternatives? Desired features: * open source * currently active development * as "slim" as possible (mambo is quite a heavy weight!), may be even without using a mysql database (like for example the slim version 1.x of the gallery php application).
View Replies !
PHP Online Learning System
Does anyone know of a good software package written in PHP for online learning. I am looking for something taht would allow me to add and remove students, track their progress, edit / content. Does anyone know of a package like this, or should I start writing my own?
View Replies !
Online Payment System
I am developing a site for a client who wants to sell courses. I have looked at paypal and it looks like the best choice, but the site needs to be able to give special offers for courses based on what courses the user has bought before. So, although I need a simple payment system, I need to have some feedback from the provider of who has bought what. I have looked at the paypal site and sent an email to no avail. Does anybody know if this is possible with either paypal or perhaps another provider.
View Replies !
Setting Up An Online Chat System
I have been asked by my manager to look into the possiblily of setting up an online chat system for the external website. We run an Apache server with PHP (hence the reason Im posting here) so it would need to run on that. Basically, it will run on the website and its purpose will allow members of the public to access the chat room and discuss current topics with experts. Similar to a doctors interactive website where patients can speak and get advice from their GP. Anyway, Ive never set up anything like this before so dont really know where to begin. The chat system may be something that we would need to pay for but ideally it will have a professioanl appearance and be easy to implement.
View Replies !
[MySQL] Extend Who's Online System
I'm using this query to retrieve the screen- and usernames of al the members who were on-line in the past 15 minutes. My website has got larger and there's added an option for users to define who their friends are, stored in a new MySQL table called 'thijs_friends'. Now I want this query to select the on-line users whereby it the users who are on-line and also are marked as friends of the user executing the query separates from the 'normal' users. Anybody knows how this can be done? The SELECT statement may look something like this 'SELECT ..., is_friend FROM ...' where the fake 'is_friend' column can have the value 0 or 1? Perhaps with a temp-table or another JOIN? Current query .....
View Replies !
Time Online User System
I'm building something special but dont really know whats the best way to start this i want to messure time online from users that signup for it So i can make a toplist of the best visitors that where online and active But how do i messure time and how do i abort it when they are not active for a <? while ?>?
View Replies !
Online Live Support System
i want do display followign screen by entering userid and password by mentioning them staticly like i will give admin and password adm123 once when i open admin.php it should directly take me to admin screen.
View Replies !
PHP / MySQL Online Status For User Authentication System
I'm working on a user authentication system. My problem is with an "online status" element. So far, I have that when the user logs in, a field in my members MySQL table, called loggedinstatus is set to 1. This means that that certain user is currently logged in. The problem is, is that the only way that loggedinstatus is set to 0 (the user is not logged in) is when the user clicks the logout link. If the user just goes to another website or closes his or her browser, the loggedinstatus is left at 1. How would I get around this problem?
View Replies !
Booking
I have a system to for booking books online. I have start date,end date, start_time and end_time. I'cant figure out how to validate those fields not to book one book 2 times in same time. For example if the book is already booked than you get message this book is already booked Any idea?
View Replies !
Booking Code
i cant even get it to work in the browser at the moment it gives me the error: Parse error: parse error, unexpected T_ELSE in C:APACHE2Apache2htdocsadd_book.php on line 91 which is the else in the lines which is before the form starts: else { $accommid = $_POST['accommID']; i have confused myself completly with all the if's and elseif's and the brackets that go with each. however i am trying to do a booking script that will search to see if the dates that the users have entered are avaialable for a particular accommodation. also i need to be able to solve the concurrent user problem to ensure that an accommodation cant be double booked. Code:
View Replies !
Booking Dates
I'm familiar with easy php/mysql-applications, but i've run into a problem now. I'm trying to build a booking system(for training purpose), and I'm kind of stuck when it comes to this: * each booking record in db has a "from" and a "to" date(DATE format) * how can i return available objects when a user searchs for "available objects from 2006.01.01 to 2006.03.01 ?
View Replies !
Booking Purpose
I need to do a functionb of select seat for booking purpose using php. This function is like we can choose or select the seat when we make movie tickets reservation online.
View Replies !
Simple Room Booking App?
I'm lazily looking for a simple app that will let us match up teachers, classes, and instructors, preferably with a php/mysql infrastructure so that it's accessible via the web. If there is a single good repository of free scripts that would be useful as well.
View Replies !
Reservation / Booking Scripts
I have been looking for some time for a php/MySQL booking / reservation scripts for a tourism business. Bughotel is the right type of thing but a little top heavy. Any others out there people might recommend. I have done some pretty intensive searches at sourceforge et al.
View Replies !
Script To Allow Booking Of A Timeslot
I'm trying to write a script to allow booking of timeslots between 6am and 6pm - 1 min intervals. Only 1 owner per slot. Once their booked - they're gone. Here's where I'm at - Database called time - 2 tables called timeslot (time_id,time) and owner(owner_fname,owner_lname,email,time_id). Code:
View Replies !
Calculation Problem - On-line Holiday Booking
I have a calculation problem in this system i am doing for on-line holiday booking. Rates are given for a particular date range as follows in the "rate" table: E.g. $10 for 2005/10/01 - 2005/10/05 $20 for 2005/10/05 - 2005/10/10 If client wants to travel from 2nd to 9th, the cost should be $120.00 Calculation: 2nd to 5th @ $10 per day = $40 6th to 9th @ $20 per day = $80
View Replies !
System(); Command Not Working On Remote System. Windows.
My server is a windows machine, on the same domain as python(also a windows machine). Apache is running as a service as an administrator. This is a test only environment to whom it may concern(I hate people telling me how insecure my system is) I'm just trying to run: $last_line = exec('dir pythonc$', $retval, $g); print_r($retval); echo '<br>'.$g.'<br>'; echo '$last_line= '.$last_line.'<br>'; Which outputs: Array ( ) 1 $last_line= The command from the command line works fine. And apache can access directories that only administrators can access on the local machine.
View Replies !
Login System - News System
i have to do a news system wich use php/mysql. i need 3 accounts: * a 'reader' who doesn't need to log in to read the news * a 'writer' who can write news in a pending news table * a 'moderator' which validate a pending news, and make it a regular news, viewable from the site (by the 'reader') This is a small web site, so i can't use SSL; and i use php sessions. Right now, i deal with account from a mysql users point of view, which means, that a 'reader' can access all the admin part of the site, but will ger errors when trying to read/write by sql query. I was wondering if somedody could give me a trick to deny access to the admin pages. Rigth now, i though about these: * by decoding mydql rights? (how) * by doing only-to-test query? (bad i think, especially for write right)
View Replies !
Who Is Online?
i want to show how many visitors are on my homepage "index.php" at the same time. i do not want nor do i need them to register for membership or anything. i just want to simply show how many people are on at the same moment.
View Replies !
Whose Online
I'd like to find and use a PHP script that like Vbulletin can display a list of those who are online within a set limit of time. I see the opposing language by MS plastered all over the net (dont post the a word as I trued -a.p in my search so others smart like myself in their search may find this page in the future). Anyway does anyone have or know of such a php script? The reason I can't continue using it is because the chgdir is messing with my another script. I do not know how to reset chgdir once set and no one has posted that. If they did I'd not have to post this alternatively.
View Replies !
Who's Online?
How do you determine how many users are logged into a site at once or viewing a certain page? Obvious examples are all over this board. If I use a session or cookie, how do I wipe it clean when the user closes his browser?
View Replies !
Who's Online...
i'm going to build a who's online for a client, but I have a problem. I don't know how to do it with this kind of db. (done by a past programmer). Here it is +----------------+--------------+ + user_id + int(11) + +----------------+--------------+ + real_time + datetime + +----------------+--------------+ now i don't understand, if i wanted to collect all users active in the last 5 minutes, how i would go about doing this because what the db does is stores them, and when they were last active. Any ideas on how to do it? (DB is MySQL) (PHP 4.3.11)
View Replies !
Users Online Help!
I have a column in my datasase and whenever you login, it sets it to "yes". The Users online just retrieves all users that have "yes" in that column. However, the only way to get the user off the Users Online list (make the column "no") is to go via logout. I don't want this to be the users only choice. I want the online column in the database to be set to "no" if they have been on a page for 30 minutes. Now I figured out most of the code, but I can't seem to find a way to track the number of minutes (or any time) that the user has been on the page. I tried incorporation JS but I can't get that to work. I tried cookie's but I got nothing. BTW: I'm using sessions so $_SESSION['online'] controls the online status. Can someone please help me track the minutes the user has been on the page?
View Replies !
Who's Online - Timestamp
i am trying to make a "whos online" type thing. the following code returns all members as being online within the last 5 mins, but i dont think my "$last_hit" variable is working properly a when i return it i get "Resource id #3" i have tried: $last_hit[0] and $last_hit[0][0] but neither seem to work, anyone have any ideas ? PHP Code:
View Replies !
User Online
I need to be able to tell and post it out to a web page when/who is on my website. There is a login screen, a members mysql database, and the rest of the site is php.
View Replies !
Online Questionnaire
i need to create an html questionnaire form that depending on how many correct answers the user answers a different message will display. how do i go about doing that in PHP?
View Replies !
Who's Online Script
I'm trying to use a whos online script that shows how many vistors are online my site at a time. I'm getting an error message though and cant seem to figure it out. Here's the error that shows up where i want the script to display Warning: Supplied argument is not a valid MySQL result resource in /home/jbs/public_html/pages/clsOnlineUsers.php on line 215 And here's line 215 in the clsonlineusers.php script PHP Code:
View Replies !
Online PHP Editor?
I'm looking for a php editor that I can use online to modify files on my server. I did a search on the forums here, but most of the posts relating to this are rather old. The two things it needs to have is line numbers, and syntax highlighting. And it needs to be free, if possible. Ones I've found so far: 1) Helene Has weird bugs with the line numbers, if you erase lines, etc. 2) IDE.PHP Doesn't have syntax highlighting. 3) AboutEdit The plugin version is very nice -- very close to what I need. Not free, though, and I need to use this on many servers, so the cost starts getting prohibitive. Has anyone else run across something that might work? Plain text area with javascript, flash, java applet, I don't care.
View Replies !
Users Online?
How would I go about implementing a feature that lists the number of users that are currently visiting my site (registered users with user info stored in a cookie)?
View Replies !
Online Calendar
some quick facts to get ya started: it supports multiple calendars, custom fields within calendars. users/groups and permissions. it will include: import/export to .ics format, event validation, and searching.
View Replies !
Best Online PHP Editor?
what are some of the best php editors that are available for online use. As in using to edit php directly taken from a database. Requirements: Syntax Highlighting, Line # Display I've seen examples of this on forums and such, but not for editing my personal code.
View Replies !
Online Indicator
I ran into some problems with a really cool Perl script that enables websites to tell visitors if the owner is currently online. I am trying to translate it into PHP because the Perl script forces site owners to use SSI. Basically, there are three scripts and a .dat file (for anyone who may be familiar with this, it comes from a script called "I am Online"). A config file (onlineconfig.php) An online checker file (check_online.php) I am online file (i_am_online.php) that site owners most use with a browser to tell visitors they are online Code:
View Replies !
How Many User's Online
im new here and i just want to know where can i get a hit counter that say's the hit's and how many user's online that's all i want or could some one give me some tip's on making one or give me a url of a place to learn php.
View Replies !
Looking For Online PHP Editors
I've seen lots of posts regarding PHP development environments, and I already have some good ones to use offline. Still, there has been many times when I'm away from home and need to get in and edit a file. Has anyone run across a good web based editor for PHP? Ideally, the editor would allow for updating a file and checking it's syntax using the built-in PHP functions for syntax checking and color highlighting. Once the result is accepted, the edited file could then replace the original. Pushed further out, it is easy to imagine an online editor with versioning ability to allow rollback to an earlier saved version. Another nice feature would be working on the code on one website and then either copying or uploading it to another site. All should be possible, and straight forward, but I'm not sure if anyone has put the pieces together in an open source project.
View Replies !
Practise Php Online?
is there a site where you can practise your php coding online? I'm at work and don't get ftp access to my server because they have it blocked. I would like to try some scripts to see how they responde.
View Replies !
Redirect If Online
Ive been looking for a nice Redirect if online script, but there i didnt manage to find one. I know its probably easy to create one, but i dont understand a single bit of PHP making this very hard for me . I found this code to redirect though: <?php header("Location: http://website.com/"); exit;?> My question: Whats the best way to extend this into a "redirect if server is online" script. should i add a "if http://website.com is online, then redirect" like rule? and how could i do this?>
View Replies !
|
TRACKER
