I need to build a database that will basically handle online sign up for web hosting.

The hosting plans are pre defined, with set details and prices, and there are also extra features that can be added to hosting plans depending which plan is chosen

The domain extension prices are also pre defined.

Ideally I’d like the database to work like this using asp pages..

First Sign up page

Customer sees a form to enter the following

Username
Password
Company/Project name
Contact name
Address1
Address2
Town or city
Postcode
Telephone
Email

They submit this form which checks username / password for duplication and if they are already taken, reloads the same page requesting another username / password

If user / password is unique, the next page loads a form which requests what domain name the customer wants and what they want to happen with it, something like this..

Domain name – just a text field
Domain extension – drop down list with all the various extensions (.com / .co.uk etc), and their price per year
Domain action – drop down menu listing the following
Please register new if available
Please arrange transfer
Please supply me with new name servers

Once this form is submitted, the next page loads with a form requesting what hosting plan the customer would like, something like this…

Hosting plan – Drop down menu showing list of hosting plans, and the price per month and per year

And then once that form is submitted, at list of extra features can be chosen from, relevant to which hosting plan was picked, (eg asp.net framework option would not show if linux hosting plan is picked) something like this

Asp.net framework – checkbox and price
Email Virus scanning – checkbox and price
Spam free email – check box and price

Once this form is completed, a confirmation screen shows all the completed fields and the total price of the domain name, hosting plan and any extra features chosen, as a yearly subscription and as a monthly one. From there the customer can either accept buy clicking the relevant paypal button (there will be two, one for per month and one for per year, the amount will be pulled into the paypal button script from the data collected.

And that’s it. I know this probably very easy to an access guru.. but me, I’m bamboozled!


Party On!

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Rich,

What you are asking is a bit outside of the scope of a forum....all that you ask can be done but it cannot be described through the forum......

I suggest you start looking at the tutorial on MX to get to grips with the basics of a database driven website and then pose questions as you get stuck.

I dont want to demoralise you but I cannot see anyone answering all you ask in one hit as you are trying to build a small application here.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

of course yes I understand I have kind of asked all the questions in one go! basically, I know how to build insert record pages and amend pages, so I'll start at the top, the first page, how can I check for a duplicate username and password?

Party On!

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

SELECT Username, Password FROM &lt;table&gt; Where username = Request("username" and password = Request("password"

If rsLogin.EOF then
Response.Write("Illegal login. try again."
else
Response.Redirect("loginpassed.asp"
end if

Hope this helps...


L8R,
Vitoman, M CIW D, MMCP

right great... I think I can get the login bit working! Thanx!

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Party On!

Rich...<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>