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 Complete Forum Thread with Replies
Related Forum Messages:
Ticket System
if anyone had any recommendations for a fully developed Customer Trouble Ticketing system written in PHP/MySQL. The only caveat is that i would like it to easily snap in to our existing infrastructure (& preferrably look n feel). At the very least, the system should be able to draw from our user table & authentication (via sessions) we are already using. Anyone have any ideas or be able point me in the right direction? I've done a bunch of digging, but i thought this could save me some research time.
View Replies !
Help Desk Ticket System
I am looking for a good, but free, open source help desk ticket system written in PHP and MySQL. There seem to a be a lot out there. I would like to narrow my search before I begin installing and testing the many varieties. Can anyone suggest a good one in particular that you have used? Although I doubt there is a free alternative with such high quality, I am looking for something that comes close to the Cerberus Helpdesk system.
View Replies !
Ticket System Generated In Pdf
I would like to make some sort of ticket system, but I'm still a newbie with php. What I'd like to have is the folowing: someone fills in his name and adress, these will be stored in a database. (this part I can make myself ) after I have checked there payment I want to send them a code. the user can now fill in this code in a form, when he does that a ticket will be generated in pdf with a unique code on it. (ofcourse this unique code needs to be send to the database too, because I have to be able to check if the code is valid).
View Replies !
Trouble Ticket System
I have had an extremely difficult time finding a trouble ticket script to suit my needs. I either find something that is complete overkill or something else that isn't enough. I have literally installed at least 8 or 9 trouble ticket systems and none have worked for me in terms of ease of use and functionality. I am looking for a php trouble ticket system that is plain and simple. I like a clean look and good functionality. I would also like it to be able to create and update tickets via email. I want to be able to copy and paste html emails and not spend 5 minutes formatting the post. If possible I would like to have something that does have built in reporting functions but I can get around that with my own reports. That's all. Every time I find something that is simple it can't create via email. Every time I install something that can do what I want it does 20 different things like knowledgebase and inventory or the ticket system itself is really complicated and for large shops.
View Replies !
IT Helpdesk/Ticket Managing System?
I work in a small 5 man IT department with about 250+ nodes. I have been trying to track down a decent IT Helpdesk/Ticket managing system that will run on windows/iis6/php/mysql or any other flavor with some form of LDAP integration.
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 !
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 !
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 !
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 !
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 !
Support Ticket Systems
Does any one know of a good PHP support ticket system? I have been looking around and not had much look finding a stable one. So i would like some opinions on the available ones out there.
View Replies !
Switch Statement - Ticket Price
I'm not understand why this doesn't work: echo '"'. $default_class . '"' // Set ticket price based on chosen class switch($default_class) { case "coach": $ticketprice = 99.99; case "business": $ticketprice = 149.99; case "first": $ticketprice = 199.99; default: $ticketprice = 89.99; } echo '"'. $ticketprice . '"' It echos the right $default_class, but doesn't set the right ticket price. It always defaults to 89.99. Any ideas?
View Replies !
Need Php/mysql App To Handle Event Ticket Sales
I don't know if this is the right place for this, but I'm looking for a free/cheap/resonable priced php/mysql app that I can use to sell Event tickets and manage the people signing up for the Events. Can someone point me in the right direction? I've looked on hostscripts, webbuilder, etc...but haven't found anything. More specifically the events happen similiar to: Mon/Wed/Fri at 6 pm for 3 weeks. So the person would pay $10 per session or $90 total for 3 sessions for the full 3 weeks.
View Replies !
MT_Rand Function Duplicating Ticket Id's
I've been running Epix Power support ticketing system for a few months now and it's been working very well. Recently however, it's started to duplicate the ticket id's. So from a ticket entered a few months back, someone entering a new ticket would put their information on that original ticket. This obviously is not good for a support site. The code that is running the generation of the number is the following: for($id=0; $id<10; $id++){ $p_id .= substr("ABCDEFGHIJKLMNOPQRSTUVWXYZ123456789", mt_rand(1,35), 1);//Randomize Ticket ID } Is there a way to make the generation of that ID more random than it is now? If there is, how would I go about doing it?
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 !
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 !
Php -f With System()
the php path, "php -f" for the system function started not working. It used to be fuctional till this yesterday evening. PHP Code: system(php -f myscript.php); Instead if I use. "/usr/local/bin/php" it works.
View Replies !
Rating System
Im tring to create a top10 rating system for my site.. but i have one problem.. i cant see to be able to find a way to code.. the sites levels ( ex: 1 - 10 ) i tried counting the tables.. but.. when i do count then.. then all sites with have the same number level.. forexample.. lets say.. 1 first hightest url here 2 second highest url here 3 etc..... but.. when i count it with mysql_num_array( ); then all numbers will be that number of the colums that i have in my database instead of 1 2 3 it will just say 2 2 2 does anyone knows a good way of doing this..
View Replies !
|
TRACKER
