Searching for something special....

[Anon]

Hello, I´m searching for a script that enables the user to book or reservate a seat in a theatre or hall or big top by simply clicking on a self actualising seatplan (mysql-powered)

Scripts like this are used by lanparty sites allover, contacting them brought nothing but the answer, it would be a part of php-nuke.

I really can´t believe that i have to install php-nuke to get it work.

As nonprofi in php & mysql tips or script samples would be helpful.

Thanks to all!

Hb

[sarahk]

Have you got the seating plan worked out. How are you doing it.

Two ways, a simple table (for a simple venue) or an image for a complex venue (say arced like the circle at the theatre). If image then use image map, if table then simple clicks.

Either way, you map it so that the hyperlink is <a href="bookit.php?seat=123&showid=123">Seat 123</a>

I'd use a template to parse in the showid which the user is looking at. If you used phplib (free) the html would look like <a href="bookit.php?seat={SEAT}&showid={SHOWID}">Seat {SEAT}</a>

Then in your php you'd run through the available seats and parse in the seat number and the showid. The only minor problem with this approach is a bug in phplib but leave your email and I can send you a good version.

Better still, you know, is to parse in the whole thing from <a to </a> and then if the seat is booked you'd just give the seat number without the link so people can't click on it.

Should be fun to do, and shouldn't be too hard.

Good luck