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 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 !
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 !
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 !
Check Room Availability System
I am super new to php/mysql etc. i am just trying to do a room availability system. I have 5 rooms in 5 different category. i like to know how to design a DB and write a php that takes two different dates[checkin date / checkout date] and verifies the DB for availble rooms.
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 !
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 !
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 !
Php Chat Room On Irc
Does anyone know of the name of the mirc server address, that i can connect to to join a php chatroom where people talk about php. i used to go in to one, but I have new computer and have lost the detail.
View Replies !
No Room To Explain
Right now when I use this script <? ' echo $row['name']; echo '- ' ?><? ' echo $row['category']; echo '- ' ?>TITLE OF MY SITE I get this when there is no 'name' or 'category' --TITLE OF SITE I want it so that - only shows if there is indead a 'name' or 'category'.
View Replies !
Irc Php Chat Room
I used to use a IRC and go in to a php chat room, does anyone know of the IRC network that i need to connect to to talk to other people interested in php.
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 !
Chat Room Needed
I'm in a need of a chatroom for my website, and I'm assuming PHP would be the best option. There is one feature I must have: I need to be able to assign a user mod powers so any time he logs in, he'll have that power. I also would like for his text to show up in a different color than everyone else's.
View Replies !
Small Bug With My Chat Room.............................................. .....
Take a look at PHP chat with no login screen! Try changing your alias from guest, and click the SEND button, it works. But change it and then press ENTER and the input frame dissapears . This is the main parts of the message and alias text boxes, they are in different forms, how can I stop it going blank when people hit enter? ************************************************** ** <FORM NAME="MsgForm" ACTION="<?php echo($action); ?>" METHOD="POST" AUTOCOMPLETE="OFF" TARGET="<?php echo($target); ?>" onSubmit="return window.parent.validateSubmission();"> <INPUT TYPE="text" NAME="M" SIZE="45" taborder=1 tabindex=1 MAXLENGTH="299" VALUE="<?php echo(htmlspecialchars(stripslashes($ValM))); ?>"> <INPUT TYPE="hidden" NAME="sent" VALUE="0"> <INPUT TYPE="submit" NAME="sendForm" VALUE="<?php echo(L_OK); ?>"> </FORM> <form name="aliasform"> <INPUT TYPE="text" NAME="ZU" SIZE="5" MAXLENGTH="29" VALUE="<?php echo(htmlspecialchars(stripslashes(urlencode($U))) ); ?>"> </form> ************************************************** ** Can I detect if they hit Enter while in the alias text box, then set focus somewhere? Its like it submits a blank form and goes nowhere. is there a setting I can use on <form name="aliasform"> to stop that?
View Replies !
PHP Chat Room Server
I'm looking for a chatroom server - one that has an API, so I can use a non-web GUI. All searches on Google have yielded the wrong stuff.
View Replies !
Very Simple Chat Room
I would like to set up a very simple chat room for my daughter to use with her friends. I am reasonably competent in PHP and MySQL and was wondering if anybody could suggest a simple way to create a script. The obvious way using what I alredy know would be to have the page auto refresh at regular intervals but I can think of several disadvantages of having the chat updated in this way. Is there an alternative way to update new message without refreshing the whole page?
View Replies !
A Busy PHP Chat Room
I know phpfreaks has its own chat room but whenever I visit its only got about 18 vistors and no chat going on! Anyone know of a bigger and more active php chat room?
View Replies !
Members To Chat Room
i have got a website and I want members to log in to the chatroom when when they are loged in to the website without having to enter a nick name I know it is something like <param name="username" value="<?php print("$sql_array->member[ID]"); ?>"> <param name="password" value="<?php print("$sql_array->member[Password]"); ?>">
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 !
Chat Room For Paid Members
I have a dating site that I want to put a chat room on. I just want the paying members to be able to have access to it. I already have the chat room installed on the site. Whats the best way to go about doing this? I understand that you have to use cookies but I have no clue how to put that in the coding. Is there a reference where I can look it up?
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 !
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 !
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 !
$system = New Java('java.lang.System');
I am trying to get Java to work from within PHP. I have been looking at: http://us2.php.net/java The error and line of PHP code: $system = new Java('java.lang.System'); Fatal error: Class 'Java' not found in C:Documents and SettingsEd TaylorMy DocumentsProjects Eclipseworkspacesworkspace PHPScrapboardJavaExample.php on line 3 I have looked at the 'User Contributed Notes'. It seems there is a proliferative of different way people have defined the Java configuration options. Some have links in quotes some do not. Not sure if I am suppose to use the eight byte Windows dir name? I am a Java programmer. Sun's JAVA_HOME points to the base directory name for the JDK installed. In PHP it looks like it points to the bin subdirectory. This is what is documented: java.class.path The path and name of the PHP jar file (usually called php_java.jar) as well as any other jar files or directories where PHP will search for compiled Java classes. java.home The root directory of the installed JDK java.library The location of the Java virtual machine library java.library.path The location of the PHP java library (usually in the modules/ directory) This is what I have defined in my PHP.ini: extension=php_java.dll java.class.path = "C:php5.2extphp_java.jar" java.home = "C:Program FilesJavajdk1.5.0_07" java.library = "C:Program FilesJavajdk1.5.0_07jreinserverjvm.lib" java.library.path = "C:php5.2ext" I am running: - Windoze XP SP 2 - PHP 5.2 - Java JDK and JRE 1.5.0_07 - Eclipse 3.2 - PHPEclipse 0.2.0
View Replies !
MLM System
Is there anyone who has developed some online MLM System, i need to develope a system where i need to calculate the total numbers of members in the downline both, seperately for left and right leg. This system works on 2 x 2 matrix.
View Replies !
Pat System..
How would you use patsystem for your templates in php? How would it make it easier? Where can i learn more about this? Also, Is their a script for making a today's featured sites? Thanks a lot.. I am learning more php with my books, i also want some good tutorials online.
View Replies !
Doc System...
Any one have any idea where I ca get a documentation system like the one php.net uses? Have a list (and sub lists) of topics, display details about a topic, and allow users to BLOG that item at the bottom.
View Replies !
An API System?
I am creating widgets on my website. but right now I am limited. because the ones I have are hard coded into the page. Like (if i have the notepad widget, then show it here), etc. How would I make an API type system to allow people to make their own, similar to Facebok, Google, and now Meebo. Well not like Google. more like Facebook.
View Replies !
System?`
I need i Affiliate tracking system so i can see what person there have registered on my sponsers products like mattcashback and other rewards site. Is there somewhere i can but i system like that?
View Replies !
POS System
it is possible to use PHP to built a POS system which connect to cashier and bar code scanner ?? Any information related to this?
View Replies !
CRM System
May be somebody have any wish to make a CRM system with me? It would be great if you have experience in a pear or some other high level scripts for php.
View Replies !
A Help System
I am developing a CMS/web-building website, and I need to include a good help system to help my customers learn how to use the features of what my project offers. Does anyone have suggestions about what help products I could incorporate into my site? I want the standard outline system, with a column showing chapters, an index, and search box.
View Replies !
System() Help
Having a bit of an issue here. I am wanting to do a database backup using the system command. This is the command I am runing: $systemcmd="mysqldump -hlocalhost -uuser -ppass db_name > backups/`date +\%d-\%Y--\%H:\%M`-Backup.sql"; system($systemcmd,$retval); echo $systemcmd."<br>"; echo $retval."<br>"; The command works fine from SSH, but when running the system function, all that gets returned is the number 1 from $retval (outputs $systemcmd fine as well). No backup is made using system(). Can anyone think of a reason as to why this is happening?
View Replies !
System()
I try to do a mysql backup using mysqldump. I've written a php script that uses system() to execute mysqldump. I have two unix servers and the script runs fine on the frist one but fails without any error on the second server. I have following script to test it: ---------------------------------- <?php print system ('/usr/bin/mysqldump --opt -u user -ppassword database 2> /home/user/public_html/backup/error.txt | gzip > /home/user/public_html/backup/bck120404.sql.gz'); ?> ---------------------------------- This script doesn't return anything. No error.txt and no bck120404.sql.gz are written. It's a unix server and register_globals is off. All directories should be fine and "print system ('ls');" runs ok. I also tried exec(), passthru() and shell_exec().
View Replies !
On An IIS System
I have to run PHP on an IIS system as I have to also code in (cough, cough) ASP. Trouble I'm having is with sessions, I can write them, I can see them, I can see them being written. BUt I can't get them back when I go to another page. My session.save_path = c:sessions (backslash for windows) my sessions folder has write permissions set, but I'm must be doing something wrong. If someone could please shed some light on this.
View Replies !
System
i am not able to run rsh command from php. my code is: system("rsh -n -l username machine_name perl perl_script.pl input_file > output_file");
View Replies !
CMS System
I want to start a little site where i display rss feeds from several sites. Actually i don't need much more than just displaying a lot of rss feeds. script that can do so? It would be great if i could put them into categories etc. I've taked a looong look at hotscripts, but haven't been able to find anything so far, so all help is appreciated :-)
View Replies !
PM System
I have built a PM system, where user's of my site can send each other private messages. In SQL it's store as MessageID the primary key for messages Sender The Account name who sent it Reciver The account who is receving. Now When a user opens the message, they can see what the person said, but if it's a reply Like say i sent you a message, and you replied back.
View Replies !
|
TRACKER
