Re: [PHP] Booking form, please

2007-06-14 Thread David Giragosian
All our folks here love MRBS. http://webscripts.softpedia.com/script/E-Commerce/MRBS-24375.html Just substitute 'computers' for locations/rooms... David On 6/14/07, Timothy Murphy <[EMAIL PROTECTED]> wrote: I'm looking for a form to allow people to book an hour on a computer system. Is there

[PHP] Booking form, please

2007-06-14 Thread Timothy Murphy
I'm looking for a form to allow people to book an hour on a computer system. Is there a standard PHP program for this? Or can you point me to such a program, please? -- Timothy Murphy e-mail (<80k only): tim /at/ birdsnest.maths.tcd.ie tel: +353-86-2336090, +353-1-2842366 s-mail: School of Math

Re: [PHP] BOOKING SYSTEM

2005-09-21 Thread php @ net mines
eas3"]); $thead3 = stripslashes($thes["thead3"]); $theat3 = stripslashes($thes["theat3"]); $theaq3 = stripslashes($thes["theaq3"]); } } if (($theas - $theas3<=0) || ($thead - $thead3<=0) || ($theat - $theat3<=0) || ($theaq - $theaq3<=0)) { $z++; } $

Re: [PHP] BOOKING SYSTEM

2005-09-20 Thread adriano ghezzi
well I did it in the past, at the end after a lot of tests and simulation i decided for warehouse table id_hotel, date, num_total_rooms, num_booked_rooms this is day by day handling it is really flexible you can satisfy each kind of request with very simple queries you also gain more flexibility

[PHP] BOOKING SYSTEM

2005-09-20 Thread php @ net mines
Hi all I have a hotel booking system where for sppecific periods we have specific availability e.g. hotel_id, hotel_name, hotel_fromperiod, hotel_toperiod, hotel_availablesinglerooms 1, Hilton, 20/06/05, 20/08/05, 20 We have a second table for recording the bookings e.g.hotel1_id, hotel1_n

Re: [PHP] booking

2005-04-01 Thread Zareef Ahmed
Hi , read about uniqid() function, it may be usefull. zareef ahmed On Apr 1, 2005 12:03 PM, Rob Agar <[EMAIL PROTECTED]> wrote: > hey up all, > > anyone have a snippet for generating a unique booking reference string, > say 6-10 characters long? The kind of thing you get when you book a > f

[PHP] booking

2005-03-31 Thread Rob Agar
hey up all, anyone have a snippet for generating a unique booking reference string, say 6-10 characters long? The kind of thing you get when you book a flight or whatnot online. it's friday afternoon and I'm too dim to figure one out myself :-/ Rob Agar Web Site Consultant Wild Lime Media - [EM

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-22 Thread Jeff Armstrong
overboard. [soapbox.off] Kiora -Original Message- From: Jon Snell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 10:54 PM To: Thomas Edison Jr. Cc: [EMAIL PROTECTED] Subject: RE: SV: [PHP] Booking by Date/Time in mySQL Yes, I would recommend locking your tables before doing this ju

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-21 Thread Jon Snell
statement and worry about race conditions... -Original Message- From: Jeff Armstrong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:36 PM To: Thomas Edison Jr. Cc: [EMAIL PROTECTED] Subject: RE: SV: [PHP] Booking by Date/Time in mySQL the logic goes: $start

[PHP] Booking by Date/Time in mySQL : my CoDe!!

2001-03-20 Thread Thomas Edison Jr.
Mr. Jeff, following is the code i'm using in my page, could you tell me what i'm doing wrong, besides of course the famous "uh ohh i got a row back()" code that needs to be replaced =sdate and '$realsdate'<=edate) or ('$realedate'>=sdate and '$realedate'<=edate)",$db); if (uh_ohh_I_got_a_r

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
ike you are just > > testing > > the FIRST one. > > > > why not turn it round and do: > > select * from booking where > > ('$start'>=startdate and '$start'<=enddate) or > > ('$end'>=startdate and '$en

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
ike you are just > > testing > > the FIRST one. > > > > why not turn it round and do: > > select * from booking where > > ('$start'>=startdate and '$start'<=enddate) or > > ('$end'>=startdate and '$en

[PHP] Booking with Date/Time in mySQL : My Code!!

2001-03-20 Thread Thomas Edison Jr.
Jeff, following is the code as it comes out in my page...can u tell me what i'm doin wrong, besides the fact that i have to replace that famous "uh ohh i got a row back()" with an actual snippet : =sdate and '$realsdate'<=edate) or ('$realedate'>=sdate and '$realedate'<=edate)",$db); if (uh_

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Jeff Armstrong
aranteed safe, as you can end up with double bookings in the pico seconds between the select and the insert - but hey, how many hits a second do you expect. Regards Jeff's Granny -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 5:08

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
e','$purpose','$r > es')"; > $result = mysql_query($sql) or Die ("An > unexpected > error occured. Please go back and book again."); > echo " color=#140057>Thank you! color=#ff>$rooms, has been booked from > $realsdate t

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Jeff Armstrong
AM To: Peter Chr. Hansen Cc: [EMAIL PROTECTED] Subject: Re: SV: [PHP] Booking by Date/Time in mySQL Peter, what do you mean by Newdate between date1 & date2?? the logic i'm using is that i'm checkin if the new Start Date & End date lies between the old Start Date & End Date

Re: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
AIL PROTECTED]> wrote: > Can't you use " > Newdate between date1 and date2 > > > -Oprindelig meddelelse- > Fra: Thomas Edison Jr. > [mailto:[EMAIL PROTECTED]] > Sendt: 20. marts 2001 12:25 > Til: [EMAIL PROTECTED] > Emne: [PHP] Booking by Date

[PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Thomas Edison Jr.
I'm facing this problem. I have made a room booking application. There is a Start Date & Time and End Date & Time of Booking a room. Problem is that once booked, you can't book a room with a date or time that falls between an Already booked Date & Time. For example, if someone's booked a ro