<?php
$servername = "localhost";
$username="root";
$password="asd123ftw";
$dbname="l2saviors_nice_team";
try{
$conn = mysqli_connect($servername, $username,$password,$dbname);
echo("successful in connection");
}catch(MySQLi_Sql_Exception $ex){
echo("error in connection");
}
if(isset($_POST['submit'])){
$user = $_POST['login'];
$pass = $_POST['password'];
$register_query = "INSERT INTO `accounts`(`login`, `password`) VALUES ('$user','$pass')";
try{
$register_result = mysqli_query($conn, $register_query);
if($register_result){
if(mysqli_affected_rows($conn)>0){
echo("registration successful");
}else{
echo("error in registration");
}

}
}catch(Exception $ex){
echo("error".$ex->getMessage());
}
}

?>