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 Complete Forum Thread with Replies
Related Forum Messages:
Online Reservation
im a beginner in using php.can u help me in doing my project online sea reservation. im using a looping statement but he problem is its not working.is there anyone could help me with this problem.
View Replies !
Ticket ( Reservation) Php -refresh
In IE, we need to refresh buttom we get the latest information ( from the table of mysql). If the a ticket ( reservation) e.g. train ticket selling count with 50 office. HE /SHE has to click "refresh" buttom to get the latest information else the same compartment was sold. Is there is built-in function to refresh the table in mysql by mean of php?
View Replies !
Simple Reservation System
I am trying to create a tee time reservation script. I have already created a login system for golf course members, but now I am stuck trying to figure out how to schedule a time and hole for each member. I need some help to figure out how I will setup the table in the mysql and how to send the values from the php form into the fields. I also need to know how to view teetimes day by day.
View Replies !
Web Calendar Reservation Systems
Hi, does anyone know a php5 based web calendar and reservation system? I'm looking for the following features: 1. two types of users: a calendar owner, and guests 2. guests can see what slots are free or reserved, can make a reservation, cancel a reservation 3. owner can confirm a reservation
View Replies !
Passing Variables - Reservation
i have a project to finish by tomorrow and it's really not going well. I can try to simplify this as much as possible so u guys understand. Reservation form online. so say we have a reservation.inc that includes the form and it has 1 field at this point cause if I figure out the problem with one of them, the rest is ok. 2- there is also login2.php that recieves data, checked if its ok, if so, writes into a database. Code:
View Replies !
Restaurant's Reservation System [functions]
I'm currently doing the restaurant's reservation system. I wanna do this function. The function i needed is when the date arrival of guest is more than the actual server time, a label called "reservation cancelled" will be show to inform to the user that the reservation is cancelled by looking at the label. Code:
View Replies !
Variable Problem - Integrate A Reservation Module Into
I have a realty application I am trying to integrate a reservation module into. All is well in that a user can view a particular listing and can make a booking. The system updates the correct tables per listing etc.Tables affected are: guests, (reservation add on) Reservations, (reservations add on) Listings, (original app) users. (original app) My problem is in the ADMIN area where the admin.php is not pulling the correct reservation data for the logged in user. the problem appears to be in this code within the admin.php. (I am using the username etc from the realty app.) " $listingID = $_GET['listingID']; if ($listingID == "" ) { $listingID = $g_default_listingID; (this is in the reservation app config.php file) So when I go to the admin area which I have incorporated into the main application admin area, I can login ok but cannot view the reservations applicable to the user loged in. The system keeps defaulting to the default_listingID contained in the config.php file. I also have a feeling that the RESERVATION table must somehow be linked to the other tables .
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 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 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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 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 !
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 !
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 !
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 !
|
TRACKER
