Forum Moderators: open

Message Too Old, No Replies

Query database with drop down boxes?

Use drop down boxes to query database and return results

         

jublack2000

5:39 pm on Jan 28, 2005 (gmt 0)

10+ Year Member



Hi there,

I'm a complete newbie here. I've been searching on the net for a tutorial on how to accomplish this but I don't even know where to start.

I am creating a website for an apartment I own which I'll be renting to tourists. I basically would like it to work like how hotel sites work.

Users can select their check in and check out dates, as well as how many guests, and hit "submit". The next page should return results on if those dates are available or not and pricing based on the number of guests and the dates (i.e. the rates are higher in the winter season).

I was thinking of just using drop down boxes for the users to select their dates and number of guests. Something really simple. From what I've read so far, I figure I'll need to create a database and somehow get that drop down boxes selections to query the database and return the results. It seems easy in theory I just don't know the steps in between.

Is this really hard to do? I'm pretty good with web design, but not a programmer by any means, however I'm willing to tackle the programming myself if I could just find a tutorial or if someone could point me in the right direction.

Do you think this is too advanced of a task (I learn quickly) or should I just hire a programmer?

I know this is a big question, but I really really apreciate any help. Thanks a million.

Sincerely, Juliana

adni18

4:00 am on Jan 29, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



This is not a job for Javascript; it's a job for perl. Try checking out a book on Perl Server-side scripting language from your local library to get started.

rocknbil

6:52 pm on Jan 29, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I agree, being a perl-monkey myself, :-) but PHP and ASP will also do that.

You could also search the web for tutorials for any of these technologies. Don't expect to hit the ground running, if you don't know the technology there's a bit of a learning curve between idea and functioning.

The path of least resistance would be mysql (mysql.com,) manipulated with the dynamic language of your choice. Perl, PHP, or ASP tutorials will help.

jublack2000

7:07 pm on Jan 29, 2005 (gmt 0)

10+ Year Member



Hi guys,

Thanks for your help. I installed a PHPbb forum at mysite so I know my web host works with MySQL and PHP, so I'm going to try that route.

I'm studying a tutorial on PHP and MySQL right now. If I have any other questions I know where to come.

Thanks again.