<?php
	session_start();
	$serverhost = "localhost";
	$server_name = "root";
	$server_password = "";
	$dbName= "avatar fight";


	$username = $_POST["usernamePost"];
	$userpassword = $_POST["passwordPost"];

	//Make Connection
	$conn = new mysqli($serverhost, $server_name, $server_password, $dbName);

	//Check connection
	if(!$conn){
		die("Connection failed.". mysqli_connect_error());
	}

	$sql= "SELECT user_id, user_password FROM user WHERE user_name = '".$username."' ";
	$result = mysqli_query($conn ,$sql);

	//Get the result and Login
	if(mysqli_num_rows($result) > 0){
		//Show Data for each row
		while($row = mysqli_fetch_assoc($result)){
			if($row['user_password'] == $userpassword){
				echo "Logged in";
				$_SESSION['user_logged'] = $row['user_id'];
				//echo("{$_SESSION['user_logged']}");
			}
			else{
				echo "password wrong";
			}
		}
	} else {
		echo "User not found";
	}


?>