Setting up database with login

[bitdaf]

Hi all,

I have no idea how to do what I need to do - but I'm thinking that php and MySQL might be the best way to go.

Is there a way to have a form set up to gather info but be able to reject the submission based on a data element - then immediately pass this info to another form if the conditions are met?

Confusing I know...

We are offing a subsciption service for only our immediate area and we want to screen the access to our credit card page based on zip code. We want to set up a form that will gather all the info the credit card form will need - and if the zip code is within the accepted list - the info is passed on to the credit card folks. If the zip code is incorrect the applicant is directed to a page that explains that their zip is not acceptable...

Is this possible and if so ... any ideas on where to start?
I will probably need to set up a database as well to store current users and such.

Are there any existing scripts or services that anyone may know of?

Thanks for any suggestions!!

Bitdaf

 

[sleipnir214]

This is certainly doable.

But just as a user expectation management kind of thing, I would have the application check the ZIP code first and ask for a credit card number if and only if the user qualifies. It's bad form to ask for data you don't need, and this goes doubly so with credit card data.




Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bitdaf]

sleipnir214 - thank you for the reply.

Could you elaborate on the means for checking the ZIP code? I fully agree with the method of checking it first - then redirecting to the credit card gateway if it matches the list of valid Zips. Thing is I don't have a clue how to set up a form to check> :|

I have some rudimentary html/css skills and I'm afraid that's it.
I sure would appreciate a shove in the right direction - I'm not even sure of what this might be called or I would google it.

Thanks!
Bitdaf

 

[Shanksta]

google: javascript form validation

 

[sleipnir214]

Regardless of the solution you choose, you're going to have to implement some programming here. This is a good opportunity for you to expand your knowledge.

I disagree with Shanksta because JavaScript can't be relied on (as users can turn it off) and because I don't like giving out "Use JavaScript" advice in the PHP forum.


My elaboration:

Your HTML form is going to gather user information and submit that information to a PHP script. That script will analyze the data and produce an HTML page. That page could be the original HTML page and form again (with error messages and fields prepopulated by the user's previous input) or another page. But something is going to have to programmatically respond to user input.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[bitdaf]

Thank you sleipnir214. I understand.

As I couldn't program my way out of a wet papersack... are there existing scripts or services that would do this for me?

Should I look on Hotscripts for a particular script - if so what would call this type of program?

Thanks for your help!
Bitdaf