<?php

//connect to database

 $db =mysqli_connect('localhost','connect','3xzF&?ve&jiV&+','bliss') or die("could not connect to database");

	if(mysqli_connect_errno())

	{

		echo"Error!!!".mysqli_connect_errno();

	}

session_start();

//initialise variables

$username="";

$email="";

$errors=array();

//register users

$username =mysqli_real_escape_string($db,$_POST['username']);

$email =mysqli_real_escape_string($db,$_POST['email']);

$password_1 =mysqli_real_escape_string($db,$_POST['password_1']);

$password_2=mysqli_real_escape_string($db,$_POST['password_2']);

// validating form inputs

            if(empty($username)){array_push($errors,"username is required");};

            if(empty($password_1)){array_push($errors,"password is required");};

            if(empty($email)){array_push($errors,"email is required");};

            if( $password_1!=$password_2){ array_push ($errors,"password should match");};

//check db with existing same username and email

$user_check_query="select * FROM manager_login WHERE username=$username or email=$email LIMIT 1";

$result= mysqli_query($db,$user_check_query);

$user= mysqli_fetch_assoc($result);

if($user){

 if($user['username']==$username){array_push($errors,"username already exists");};

 if($user['email']==$email){array_push($errors,"This email is already has a registered username");};

//register the user if no error

if (count($errors)==0){

    $password=md5($password_1);//this will encrypt the password

    $query="INSERT INTO manager_login (username,email,password) VALUES ('$username','$email','password')";

    mysqli_query($db,$query);

    $_SESSION['username']=$username;

    $_SESSION['success']="You are now logged in";

    header( 'location: manager.php' );

}

}

/*$count= mysqli_num_rows($result);

if($count==1){

    echo "username/email already exist!please use provide unique details";

}else{

$user_check_query="insert  into manager_login(username,email,password_1,password_2)values($username,$email,$password_1,$password_2)";

$result= mysqli_query($db,$user_check_query);

if($result){

    echo "registered successfully";

}

}*/

?>