<a href="Register.html">Register</a><?php     //start php tag
//include connect.php page for database connection
$hostname="localhost:3306"; //local server name default localhost
$username="root";  //mysql username default is root.
$password="heng0711";       //blank if no password is set for mysql.
$database='SSC';  //database name which you created
$con=mysqli_connect($hostname,$username,$password,$database);




if(! $con)
	{
        die('Connection Failed'.mysqli_error());
	}
else
	{
		echo "connected";
	}


//if submit is not blanked i.e. it is clicked.
if (isset($_REQUEST)) {
	$complete = true;
	/* this is much more readable */
	$reqParams = array(
		'studentid',
		'email',
		'password',
		'repassword',
		'streetaddress',
		'postalcode',
		'city',
		'state',
		'DOB',
		'contact',
		'gender',
		'school',
		'programme',
		'semester',
		'role'
	);
	foreach ($reqParams as $key) {
		if($_REQUEST[$key] == '') {
			$complete = false;
			break;
		}
	}
	if(!$complete) {
		echo 'Please fill the empty fields.';
	}
	else {
		/* your code here */

			$studentid=$_REQUEST['studentid'];
			$fname=$_REQUEST['fname'];
			$lname=$_REQUEST['lname'];
			$email=$_REQUEST['email'];
			$password=$_REQUEST['password'];
			$repassword=$_REQUEST['repassword'];
			$streetaddress=$_REQUEST['streetaddress'];
			$postalcode=$_REQUEST['postalcode'];
			$city=$_REQUEST['city'];
			$state=$_REQUEST['state'];
			$DOB=$_REQUEST['DOB'];
			$email = $_REQUEST['email'];
			$contact=$_REQUEST['contact'];
			$gender=$_REQUEST['gender'];
			$school=$_REQUEST['school'];
			$programme=$_REQUEST['programme'];
			$semester=$_REQUEST['semester'];
			$role=$_REQUEST['role'];

			$pattern = '/^[_A-z0-9-]+((\.|\+)[_A-z0-9-]+)*@[A-z0-9-]+(\.[A-z0-9-]+)*(\.[A-z]{2,4})$/';
            if (preg_match($pattern, $email))
            {
                echo "<p>Please enter a valid email format<p>";
                }
                else{
                $studentid = strtolower(trim($_POST['studentid']));
                $_SESSION['name'] = $_POST['studentid'];
                $pattern1 = '/^[a-z0-9]*$/i';
                if (preg_match($pattern1, $studentid))
                    {
                    echo "<p>Member name must contain only letters, space and hypen</p>";
                    }
                    else{

                    $pattern2 = '[a-zA-Z0-9]';
                    if (preg_match($pattern2, $password))
                        {
                        echo "<p>Password must only contain numbers and letters!</p>";
                        }
                        else{

                                if($password<>$repassword)
                                {
                                    echo "<p>Passwords does not match!</p>";
                                    $password="";
                                    $repassword="";
                                }




                        }
                    }
                }


			$sql="insert into student(student_ID, student_fName, student_lName,student_Password, student_repassword ,
student_StreetAddress, student_PostalCode, student_City, student_State, student_DOB, student_Email, student_contact, student_Gender, student_School, student_Programme, student_Semester, student_Role)values($studentID,$fname,$lname, $email, $password, $repassword, $streetaddress, $postalcode, $city, $state,$DOB, $email, $contact, $gender, $school, $programme, $semester, $role);";

$res=mysqli_query($con,$sql);
			If($res)
			{
				Echo "Record successfully inserted";
			}
		Else
		{
			Echo "There is some problem in inserting record";
		}
		}
			}





?>