By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

Registration Form

P: 3
Need to know if there is a sample code out there that I could use for this one
Customer Interaction with the application
1.1 Registering with the system
Customer provides their credit card number or other acceptable tenders and the name associated with it:
1.1.1 Select between visa, MasterCard, discover, and PayPal
1.1.2 Enter Credit Card Number
1.1.3 Enter Expiration Date
1.1.4 Enter Name exactly as appeared on the account
1.1.5 Enter physical address where credit card bills are sent
1.1.6 Enter e-mail address
1.1.7 Enter password (twice)
1.1.8 Enter primary phone number (home or mobile phone)
1.1.9 Click Submit

Need to know if there is a sample code out there that I could use for this one! Thanks for your time
Feb 16 '09 #1
Share this Question
Share on Google+
5 Replies


OuTCasT
100+
P: 374
This is a pretty simple insert query question.
Feb 16 '09 #2

P: 3
I understand that it is a very simple INSERT functions. But there is a little bit more to it than that:

1. When the customer selects VISA, MasterCard, or Discover, he/she gets a field that accepts no more than 16 digits.
2. When the customer selects paypal, he/she gets a field that accepts input in the format of xxxx@xxx.xxx
3. When the customer selects e-Check, he/she gets a field just for a limited amount of digits.

4. After all other information are entered, an e-mail is sent to the customer which he/she must click on to activate the account.

Instead of writing everything from scratch, I wonder if there is a code someone might which I may re-use.

I am new to sql.

Thanks for the help

Ps
Feb 16 '09 #3

OuTCasT
100+
P: 374
This is not a SQL question but anyways. You could set the fields according to your selections. Set the max characters for the textbox if you want to.

The email part of it is also very easy. Use the SMTP function to send the email.
Add a field to the DB called Activated and set it to NO. When the client clicks on the link then you can set the activated to yes according to the ID of the client in the email.
Feb 17 '09 #4

P: 3
OutCast:

What do you mean by this is not an SQL question? Should I be doing this with a different utilitty?
Feb 18 '09 #5

ck9663
Expert 2.5K+
P: 2,878
He means your question is more of a front-end tasks than a back-end one.

-- CK
Feb 18 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.