create registration page ?

behzad

I wish create a register page that this page get a product key and check this product key existing in a mysql database in table1.
and if this exist then check this product key in table2.
if this exist in table1 and not exist in table2 then register this code.
I know how create this code but i dont know location of code?

thanks

ab4net

i did not understand what really u want to ask about .. ?
please be more clear and specific .. !!

kinadian

What do you mean by location? Do you mean where on a computer to put the scripts? Do you mean how to layout the scripts (and how they reference one another)? Do you mean that you need hostspace?

--kinadian

behzad

my page ( register page ) is a submit form and in submit form are several textfilde. and mysql database are tow table , table1i s contents all productkey(1000 row) . and table2 is contents all registered productkey that register by register page . i wish when click in submit button :
first : check if productkey textfilde.value is empty , dont submit this form .
second : check if productkey textfilde.value is existing in tabel 1 (to understand this value is correct) then check productkey textfilde.value is not exist in tabel2 ( to understand this value is not registered ) . if is exist in tabel 2 then alart ( this productkey is registered ) else register this productkey ( write this value in tabel2 ) . and if this value is not exist in table1 alart (this value is not correct ).

plese help me that layout php code for this action is where ? is in the head or in the cgi file or in the function or in . . .

thanks

arelgee

" i wish when click in submit button :
first : check if productkey textfilde.value is empty , dont submit this form ."
You can't put the cart before the horse here. In other words, to check if a text area is blank, the user has to click on the submit button. Then you check to see if the variable (that is assigned to the text field) is blank ( == "") and if it is cancel the action and tell the user he messed up, that if he wants to go farther, the field must be filled in.
I haven't done it so far in php and forms, but in my C++ Builder programs, I make a mandatory field red and change to white when the user enters it (onEnter) I then use the onExit event to check that they entered what is needed.
arelgee

ab4net

OK, i think this will give you an IDEA ..

The form Page will contain :
<form method='post' action='page.php'>
<input type='text' name='x' size=20'>
<input type='submit' name='submit' value='GO'>
</form>

and in the page of PHP u have to incode:
<?php
#check if the user entered any thing in the form and if not #WARNING

if ($x==''){
echo "No Data Entered, please go back ... "
exit();
}
#Place tha connection to DB
$db=mysql_connect(....etc
#and select the database u wanna work on it ..

#Check if the value entered in Table1:

$statment="select *from table1 where field_name='$x' ";
$result=mysql_query($statment,$db);
if (!$result){
echo" Bad Query, Call webmaster ...";
exit();
}
$y=mysql_affected_rows();
#this will return 0 if not entered in the table 1 and 1 if presented #in table 2

and work on it as follow:

if ($y==0){
--- do here whatever u want to do if it is in TABLE1 ---
}else{
---do here whatever u want to do if not in TABLE1 ---
}

thats the way i think u want ...

any way come back for any troubles😉 good luck