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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 !
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 !
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 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 !
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 !
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 !
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 !
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 !
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 !
Simple Script For Doing A Simple Photo Album And Journal?
I'm looking to quickly get a photo album online. Very simple, thumbnails, a few pages, maybe a description, but hopefully a small script that's easy to edit and work into my existing site. I know about hot scripts, etc. but I was wondering if any one could recommend one? Secondly, I also want to setup a journal. It's not really a "blog" although I guess blog software may work. But it isn't going to be a message board or anything like that. Just a place to put out random bits of news. Once again, same premise, I'm trying to find the most simple script possible that could basically traverse a directory of simple textfiles and produce a list. I know all about Blosxom and stuff like that, but I'd like a script that just did the above and didn't overtake my site like PHPNuke or something like that. I'll probably roll my own, but I thought I'd check first.
View Replies !
Simple Simple String Question
When I take the input from a textarea and insert it into a mysql-base and then retrieve it and show it, all the line feeds/breaks are gone. It is shown as one giant string. How can this be fixed, so the text will be shown as it was entered? Does it have something to do with stripslashes/addslashes or am I way off?
View Replies !
Simple Row
I have this code that doesn't work - all it does is display "5 products returned" i want it to display the 5 records that are in my database - can someone tell me what stupid thing i've done wrong? <?php $query="SELECT * FROM products"; $result = mysql_query($query); $num_results = mysql_num_rows($result); echo "<p>$num_results products returned</p>"; for ($i=0; $i <num_results; $i++) {$row = mysql_fetch_array($result); echo "<p><strong>".($i+1).". ID: "; echo $row["ID"]; echo "</strong><br>Product: "; echo $row["Product"]; echo "<br>Description: "; echo $row["Description"]; echo "<br>image: "; echo $row["Image"]; echo "<br>Cost: "; echo $row["Cost"]; echo "</p>"; }?>
View Replies !
Simple PHP IF, ELSE IF
the levels staff and member have been defined on another page to determine a users access level. What i want to do is pretty obvious, if a staff member has logged in then it shows different content to when a member is logged in, and if nobody has logged in, it shows a generic login message. <?php if ($_SESSION['level'] == "staff") { ?> <p><b>Welcome staff member <br /> <a href="../chooseupdate.php"> <?php echo $_SESSION['username']; ?> </a> you're logged in.</b> <? } elseif ($_SESSION['level'] == "member") { ?> <p><b>Welcome user member <br /> <a href="../memberspage.php"> <?php echo $_SESSION['username']; ?> </a> you're logged in.</b> <? } else { ?> <p><b>You are not Logged in!</b> <a href="../login.php">Log in</a> to check your messages.<br /> Do you want to <a href="../login.php">Log in</a> or <a href="../register.php">register</a>?</p> <? } ?> Now when i add to this a page, i get the error "Parse error: parse error, unexpected $end" Happens with this one aswell <?php if ($_SESSION['loginFlag'] == 1) { ?> <p>Would you like to log-out? <a href="../log-out.php">Log-out</a> </p> <? } else { ?> <p>Please <a href="../login.php" class="style2" accesskey="6"><strong>[6]</strong>Sign in</a> or <a href="../register.php" class="style2" accesskey="7"><strong>[7]</strong>Register</a></p><? } ?> Now, I'm positive this worked on my colleges server, so it's got me thinking that maybe my php.ini file is messed up? Because this is also happening with my log-out file also, which is; <? // you must start session before destroying it session_start(); session_destroy(); sleep(1); header( 'Location: login.php' ) ; ?> On my college server it works perfectly, at home it just loads the log-out.php page and doesn't redirect back to login.php, it also doesn't destroy the session.# My php.ini is basically the default one, i got with WAMP. Except i enabled the header command to be used. Thanks in advance.
View Replies !
Simple If/else
I know, it's sad, but I can't figure it out for the life of me. The update works if you comment out the insert statement; if you comment out the update, the insert statement works. If you combine both, then only update works. I know it's with the if/else (or the actual placement/naming of the query), but I can't figure out where to place it. Â Â Â Â Â <input type="hidden" name="submitted" value="TRUE" /> Â Â Â Â <div align="center"><input type="submit" name="submit" value="Submit" /> Â Â <? ob_start(); session_start(); include ('./marketing/includes/post.php'); $date = date('m.d.Y'); if (isset($_POST['submitted'])) { //Handle form if(empty($_POST['name'])) { echo '<br /><i>Please insert an artist name. </i>'; ......................
View Replies !
Simple Bit Of PHP - HELP!
I have a site for use by some freinds, its basically a privacy proxy,but I want it to be password protected and have to get them to agree to terms and conditions. I have an index.php page in a subdomain, that has a short list of terms and conditions. I want them to have to check a box to say they agree & then also enter just a password to continue. It doesn't need to be secure. The password can be one for all. It would be good if it was all contained in the one Index file. Then when both the tick box and checkbox is checked it takes you onto a difficult domain that can't be remembered. Does that make sense? It would be good if a pop up said that you need to agree to the terms if the check box is not checked and a different message is a password is not entered or is incorrect.
View Replies !
Get Localhost - Very Simple
This is a very simple question I think, but I can't find a straight answer from the php documentation. What is the function or variable that I can use to get localhost information?
View Replies !
Simple Script
what i am doing is when a user goes to mysite and let's say that he is looking for a friend. Then he selects gender,country,age(selections). I have three categories to choose. Whatever a user select, the results comes from my database. If the results are 10 datas, it is 2pages. That's what I am trying to do but I got an error. PHP Code:
View Replies !
Simple Mark-up For CMS
I'm designing/coding a content management system in PHP and am currently considering how the users will add textual content. I would like them to be able to use some kind of simple mark-up, like a very limited subset of HTML, probably with a more friendly naming scheme. Does anybody have experience of such a thing? I'm thinking an XML application is the proper answer but when I consider the DTD and parser it seems like an overkill solution if I'm starting from scratch. Does anybody have any advice or suggestions on this? I'm sure it's been done before but I don't know where to look, is there something existing I can use or adapt? Has anybody tried this kind of thing before?
View Replies !
Simple URLs
I want to have a lot of control over my short urls. My site has guitar lessons and articles and I want to have short urls of the form: mysite.com/guitarlessons-scalelesson.html The original url is of the form: mysite/modules.php?op=modload&name=mainlessons&file=index&req=view_fulllesson&lessonid=8 In this case $lessonid 8 refers to scalelesson. All short URL examples I have seen take the original URL and directly translate it. In may case, the short URL scheme would have to query the database. I would like my forum to function similarly. That is, forum posts and forum pages would have forum category and post title in the short URL. Anyone know how to do advacned simple URLs of this sort? I really like how this forum does short urls actually. I can't imagine this is done with mod_rewrite() since the simple urls appear to be generated dynamically based on database calls.
View Replies !
Simple Redirect?
I've been searching through the forum, and the only solution offered for redirecting to another page seems to be this: header("Location: http://www.thispage.com "); Apparently, this doesn't work if it is not in the absolute beginning of the page. My question is the following: Isn't there a more simple command in PHP to tell this simple thing:"Go to this or that page now!".
View Replies !
Simple AJAX Example
Several times some members even me post for simple AJAX example with PHP. Some of experts will give URL of tutorial. Now with this attachment I send my simple test of AJAX +PHP with the help of w3schools. There is no alternative to study good tutorial but this simple example may give the fell of AJAX ...
View Replies !
Some Simple Security
I want to be able to add some simple security to one of my pages, basically my page allows users to submit a text field which gets parsed into MySQL db and displayed on other pages. At the moment anyone can submit text which opens the page to abuse. I don't want to implement a user login system. I had envisaged the addition of a password entry box which the Submit button checks against the db before proceeding, so if any user has the correct password then they can submit. Having never done password stuff before, could somebody please point me in the right direction? Also, if I have the config data to connect to the mysql db in a PHP file on my server, can anybody just open it?
View Replies !
Simple If Statement
How come this doesn't work? What am I doing wrong? $type = $_GET['functionType']; if ($type == 'Add'){ $AddSQL = "INSERT INTO..."; echo $AddSQL; }elseif ($type == 'Update'){ $UpdateSQL = "Update ..."; echo $UpdateSQL; }elseif ($type == 'Delete'){ $DelSQL = "DELETE FROM ..."; echo $DelSQL; }
View Replies !
Simple Opt-in Script?
I'm looking for a most simple but save opt-in mailing list script in php (linux Apache CGI, but shouldn't matter) best: * all in one single .php file; different functions by input vars / passwords; config vars on top of script * uses MySQL or a plain file (still no doubles) next to the .php (best both options) * double opt-in not necessary but nice * good would be "default topic" and at least up to 5 different lists/topic * takes directly my web forms like email=...&listname=...&sign=in ; repsonse page can be very simple. * I can read out the lists plain formatted also by web through the same ..php & password like: cmd=getlist&listname=...&password=... * hopefully no extreme installation tricks (thus php4, ..) looking at more than 10x google'd ones, always something was wrong, big or jerky or not as is should be...
View Replies !
Simple String
Heres my code: Its the result of a simple AJax login form. The problem I am having is with the & sign in the $page variable. Keeps coming up with the following error: "A semi colon character was expected. Error processing resource " Im sure I just need to escape the & sign but not sure how. Code:
View Replies !
Simple Parser In PHP?
I'm coming to the end of a large and exhausting project, done in my new favorite language PHP, and its time for a diversion. I'm wondering if anyone has experience with writing simple parsers. I've never done it myself, but I know they are not as mysterious as they may seem, it's a matter of finding the tools. The idea is to take something like CSS format, except that it allows nesting, and turn it into associative arrays, such as: anykey { property: value; property: value; nestedkey { property: value; property: value; } } could be processed by a command like: <?php $parsed = ParseMyFile(...) ?> and $parsed would hold the same as if we'd done this: $arr = array( anykey("property"=>"value",...
View Replies !
Simple Include
I have an include file called "my_inc_file.php" located in a subdirectly called "inc_files". I have a file both in my root directory, and in another subdirectory called "subdir", that uses the include file. My include is called in a template common to both, so has to have the exact same file structure. My local pc uses Windows, and my remote server uses Linux. How can I change my include statement so it works for both cases and both operating systems? include_once '/inc_files/my_inc_file.php'
View Replies !
|
TRACKER
