<?php

$db = mysqli_connect('localhost','root','','users')
or die('Error connecting to MySQL server.');

$username = $_POST['login'];
$password = $_POST['pass'];
$admin = 0;

$query = "SELECT User FROM users WHERE User='%s'";

$query = "INSERT INTO users(User, Password, Admin)
           VALUES('$username', '$password', '$admin')";


if(!mysqli_query($db, $query))
{
    echo 'wyjebalo sie';
}



$query = "SELECT User FROM users WHERE User='%s',
mysql_real_escape_string($username";

$result = mysql_query($query);
$row = mysql_fetch_assoc($result);

if(isset($row) && !empty($row))
{
    if($row['user'] == $username)
    {
        return echo "login alredy exist"
    }
    else
    {
            $query = "INSERT INTO users(User, Password, Admin) VALUES('%s', '%s', '%s'),
           mysql_real_escape_string($username),
           mysql_real_escape_string($password),
           mysql_real_escape_string($admin)";
            mysql_query($query);
    }

}















 ?>
<h3>Welcome!<br/> Here you can create your own account!</h3> <br/>

<form action="register.php" method="post">
User: <br/>
<input type="text" name="login"><br>
Password: <br/>
<input type="text" name="pass"><br>
<input type="submit" name="submit">
</form>