<?php
include('db.php');


if($_POST)
{	
	if(!isset($_POST['username']) || strlen($_POST['username'])<1)
	{
		//required variables are empty
		die('<div class="Msg-Error">Username field is empty!!</div>');
	}
	if(!isset($_POST['name']) || strlen($_POST['name'])<1)
	{
		//required variables are empty
		die('<div class="Msg-Error">name field is empty!!</div>');
	}
	

	if(!isset($_POST['password']) || strlen($_POST['password'])<1)
	{
		//required variables are empty
		die('<div class="Msg-Error">Password field is empty!!</div>');	
	}
	
	$CheckPass = $mysqli->escape_string($_POST['password']);
	$conformpassword = $mysqli->escape_string($_POST['password2']);
	
	if($CheckPass != $conformpassword)
	{
		//required variables are empty
		die('<div class="Msg-Error">password missmatch.</div>');
	}


	$username			= $mysqli->escape_string($_POST['username']); // file title
	$password		  	= $mysqli->escape_string($_POST['password']);//Image Source
	$encodepassword		= md5($password);
	$name	        	= $mysqli->escape_string($_POST['name']);//Image Source
	$school			    = $mysqli->escape_string($_POST['school']); // file title
    //$date				= date("F j, Y");

	$mysqli->query("INSERT INTO users(username, password, school, name ) VALUES ('$username', '$encodepassword', '$school','$name' )") or die (mysqli_error());
	
die('<div class="Msg-Ok">สมัครสมาชิกเรียบร้อย</div>');
		
	}else{
		die('<div class="Msg-Error">There seems to be a problem. please try again.</div>'); //output error
	}
	
?>