Originally Posted by Ashling

I am submitting a form from my php page to mySQL to register a user. All my input text boxes are writing to the database. The page signup.php is being passed to signupck.php. Im not very good at PHP, as I have only started. The code is this........


SIGNUP.PHP

<table border='0' width='50%' cellspacing='0' cellpadding='0' align=center><form name=form1 method=post action=signupck.php onsubmit='return validate(this)'><input type=hidden name=todo value=post>

<tr bgcolor='#f1f1f1'><td align=center colspan=2><b>Signup</b></td></tr>
<tr ><td >&nbsp;User ID</td><td ><input type=text name=userid></td></tr>

<tr bgcolor='#f1f1f1'><td >&nbsp;Password</td><td ><input type=text name=password></td></tr>

<tr ><td >&nbsp;Re-enter Password</td><td ><input type=text name=password2></td></tr>


<tr bgcolor='#f1f1f1'><td >&nbsp;Surname</td><td ><input type=text name=surname></td></tr>


<tr bgcolor='#f1f1f1'><td >&nbsp;First Name</td><td ><input type=text name=first></td></tr>

<tr ><td >&nbsp;Student Email</td><td ><input type=text name=email></td></tr>


<tr ><td >&nbsp;Year</td><td><select name ="YearSelect">
<option value = "0"> Please Select.....</option>

//not sure if PHP tags supposed to be here
<option value = "1"><?php print ($YearSelect==1) ? 'SELECTED' : ''; ?>>1st Year</option>
<option value = "2"><?php print ($YearSelect==2) ? 'SELECTED' : ''; ?>>2nd Year</option>
<option value = "3"><?php print ($YearSelect==3) ? 'SELECTED' : ''; ?>>3rd Year(ERASMUS/PLACEMENT)</option>
<option value = "4"><?php print ($YearSelect==4) ? 'SELECTED' : ''; ?>>4th Year</option>
</select></td><td ></td></tr>



<tr ><td >&nbsp;Language</td><td><select name= "LangSelect">
<option value = "FR">French</option>
<option value = "GR">German</option>
<option value = "IR">Irish</option>
<option value = "IT">Italian</option>
<option value = "SP">Spanish</option>
</select></td><td ></td></tr>




<tr bgcolor='#f1f1f1'><td align=center colspan=2><input type=submit value=Signup></td></tr>
</table>

<center>
<br><br><font face='Verdana' size='2' ><a href='login.php'>Already a member? Please Login</a></font></center>

SIGNUPCK.PHP is

<?php


$userid = $_POST['userid'];
$password = $_POST['password'];
$password2 = $_POST['password2'];
$surname = $_POST['surname'];
$first = $_POST['first'];
$email = $_POST['email'];
$userid=mysql_real_escape_string($userid);
$password=mysql_real_escape_string($password);
$email=mysql_real_escape_string($email);

if(!isset($todo) and $todo=="POST")
echo "var is set";
$status = "OK";



$msg="";


// if userid is less than 3 char then status is not ok
if(!isset($userid) or strlen($userid) <3){
$msg=$msg."User id should be =3 or more than 3 char length<BR>";
$status= "NOTOK";}

if(mysql_num_rows(mysql_query("SELECT userid FROM users WHERE userid = '$userid'"))){
$msg=$msg."Userid already exists. Please try another one<BR>";
$status= "NOTOK";}


if ( strlen($password) < 3 ){
$msg=$msg."Password must be more than 3 char legth<BR>";
$status= "NOTOK";}

//tried code here but not work......
$YearSelect['1'] =$YearSelect['2'] =$YearSelect['3'] =$YearSelect['4'] = '';
if(!empty($_REQUEST['YearSelect']))$YearSelect[$_REQUEST['YearSelect']] = 'selected';else$YearSelect[1] = 'selected'; // Default selected, for first time


if($status<>"OK"){
echo "<font face='Verdana' size='2' color=red>$msg</font><br><input type='button' value='Retry' onClick='history.go(-1)'>";
}else{ // if all validations are passed.

$query=mysql_query("INSERT INTO users(userid,password,surname,firstname,email,year id,language) VALUES('$userid','$password','$surname','$firstnam e','$email','$yearid','$language')");
echo "<font face='Verdana' size='2' color=green>Welcome, You have successfully signed up<br><br><a href=login.php>Click here to login</a><br></font>";

}
?>

PLEASE HELP!!