SQL & PHP Validation

[wolf788]

I just have a quick question:

If I create a form that checks the database in table 'betab' to see if the inputted code is in the table that if true, it proceeds with the form, however, if false, it wont allow the user to proceed.

 

[JayC]

If I create a form

Where is the question? You continue to say what the form will do but you don't say a question? lol

 

[wolf788]

Lol sorry my bad, how would i do this?

 

[Khalil]

I would presume you already have a form with the key input, right? If yes then:

if(mysql_num_rows(mysql_query("SELECT `key` FROM `betab` WHERE `key` = '".$_POST["key"]."'")) > 0) {
// continue the form or w/e
} else { // error message here }

If you don't have a form then do something like this:

<form method="POST">
<input type="text" name="key" placeholder="The key here!" maxlength="5" /> <!-- add this line if you don't already have it, and if you do have it then change to the name to "key"! -->
</form>

If you don't have a column in your table called "key" then run this sql code:

ALTER TABLE `betab`
ADD COLUMN `key` VARCHAR(5) NOT NULL;

Change the number between the varchar brackets to what ever the length of the key is!

Now, was that so hard?