Fix this script attempt?

Shorty · 03-01-2007, 03:09 PM

Hey guys, I've got to make a hotel booking system in PHP and MySQL for a project, and i've ran into a brick wall. I'm working on the part where I check to see if the slot a user wants is available.

This a bit more complicated than it sounds. First of all the user also specifies a room type, so I first have to get a list of all rooms in the room table where the room type is what the user inputted.

I then have to take the roomid, and check the bookings table to see if there's a booking with that roomid during the given period, based on a start date and duration given in the form.

I have this:
http://pastebin.com/891815

As a rough idea, but I wrote it on the fly so I didnt test it as it went along. I'm hoping thats a sound enough basis for a kind person to repair the script, mainly the SQL query which I basically guessed.

If you want paying post your price here and i'll consider it. Thanks!

artofmobile · 04-03-2007, 02:49 AM

Check this link, http://pastebin.com/891815, I gotta an error 145:

Query failure: Can't open file: 'pastebin.MYI'. (errno: 145)
select *,date_format(posted, '%a %D %b %H:%i') as postdate from pastebin where pid='891815' and domain=''

Error 145 refers to:

# perror 145
MySQL error code 145: Table was marked as crashed and should be repaired

Peter · 04-03-2007, 08:32 AM

Yes looks like pastebin have got database problems at the moment.

Hitch · 04-03-2007, 08:39 AM

The PasteBin Error is still there for me too.

Though, i suggest you read up on LEFT JOIN

bliss · 04-03-2007, 08:56 AM

Sounds pretty easy to code. What is the exact problem?

chicker · 04-03-2007, 09:51 AM

Past bin is amiting to problems:

Quote:

Problems

Sorry folks, this hasn't been performing too well recently. Fixes are coming!

Maybe use another paste bin type site

Shorty · 04-03-2007, 09:59 AM

Dont worry about this any more guys, thanks for your replies though.

On a side note, how long has pastebin been malfunctioning?

superprogrammer · 04-04-2007, 06:59 PM

Are you talking about this?
http://pastebin.com/

Peter · 04-05-2007, 12:00 AM

yes, if you look at the original post and click on the link you will see the problem.

03-01-2007, 03:09 PM	#1 (permalink)
Shorty Senior Member Join Date: Sep 2005 Location: England Posts: 1,035 102.05 NP$ (Donate)	Fix this script attempt? Hey guys, I've got to make a hotel booking system in PHP and MySQL for a project, and i've ran into a brick wall. I'm working on the part where I check to see if the slot a user wants is available. This a bit more complicated than it sounds. First of all the user also specifies a room type, so I first have to get a list of all rooms in the room table where the room type is what the user inputted. I then have to take the roomid, and check the bookings table to see if there's a booking with that roomid during the given period, based on a start date and duration given in the form. I have this: http://pastebin.com/891815 As a rough idea, but I wrote it on the fly so I didnt test it as it went along. I'm hoping thats a sound enough basis for a kind person to repair the script, mainly the SQL query which I basically guessed. If you want paying post your price here and i'll consider it. Thanks!

04-03-2007, 02:49 AM	#2 (permalink)
artofmobile NamePros Member Join Date: Sep 2005 Posts: 32 40.60 NP$ (Donate)	Check this link, http://pastebin.com/891815, I gotta an error 145: Query failure: Can't open file: 'pastebin.MYI'. (errno: 145) select ,date_format(posted, '%a %D %b %H:%i') as postdate from pastebin where pid='891815' and domain='' Error 145 refers to: # perror 145 MySQL error code 145: Table was marked as crashed and should be repaired __________________ Art of Mobile: A place for mobile resource Her Fancy: Girls' fancy to talk about technology Gaming Toy: Gaming related reviews and report Friend Place*: Online Image Gallery

04-03-2007, 08:39 AM	#4 (permalink)
Hitch Adrian Join Date: Aug 2005 Location: Uk, South Yorkshire Posts: 1,227 16.00 NP$ (Donate)	The PasteBin Error is still there for me too. Though, i suggest you read up on LEFT JOIN __________________ NamePros

04-04-2007, 06:59 PM	#8 (permalink)
superprogrammer Senior Member Join Date: Aug 2004 Location: Washington Posts: 4,319 0.13 NP$ (Donate)	Are you talking about this? http://pastebin.com/ __________________ Download youtube videos at www.HugYouTube.com and free domains list atwww.FreeDroplists.com Anonymous access at www.Banned.net

04-03-2007, 08:32 AM	#3 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	Yes looks like pastebin have got database problems at the moment.

04-03-2007, 08:56 AM	#5 (permalink)
bliss NamePros Regular Join Date: Dec 2005 Posts: 952 176.95 NP$ (Donate)	Sounds pretty easy to code. What is the exact problem?

04-03-2007, 09:59 AM	#7 (permalink)
Shorty Senior Member Join Date: Sep 2005 Location: England Posts: 1,035 102.05 NP$ (Donate)	Dont worry about this any more guys, thanks for your replies though. On a side note, how long has pastebin been malfunctioning?

04-05-2007, 12:00 AM	#9 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	yes, if you look at the original post and click on the link you will see the problem.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)