<<?php

include "conn.php";//connection

$username = mysqli_real_escape_string($conn,$_POST['user']);
$password = mysqli_real_escape_string($conn,$_POST['pass']);
$confirmpassword = mysqli_real_escape_string($conn,$_POST['confirmpass']);
$address = mysqli_real_escape_string($conn,$_POST['address']);
$email = mysqli_real_escape_string($conn,$_POST['email']);
$phone = mysqli_real_escape_string($conn,$_POST['phone']);

if(!preg_match("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$^",$email))
{ 
	echo "<script>alert('Email format incorrect! Example: abc123@hotmail.com');";
	die("window.history.go(-1);</script>");
}

if($password !== $confirmpassword)
{
	echo "<script>alert('Password and confirmed password not same!');";
	die("window.history.go(-1);</script>");
}

$sql = "Insert into member (Mem_Name, Mem_Password, Mem_Address, Mem_Email, Mem_Phone, User_Last_Login ) VALUES ('$username','".md5($password)."','$address','$email','$phone','".date("Y-m-d H:i:s")."');";

mysqli_query($conn, $sql);

if(mysqli_affected_rows($conn)<=0)
{
	echo "<script>alert('Unable to register!\\nPlease Try Again!');";
	die("window.history.go(-1);</script>");
}

echo "<script>alert('Registered Successfully!Please login now!');";
echo "window.location.href='login.html';</script>";

?>