Untitled

<html>
<head>
    <title>Registartion form</title>
</head>
<body>

    <form method="post" action="registration.php">
        <table width="400" border="5" align="center">
            <tr>
                <td  align="center" colspan="5"><h1>registration form</h1></td>

            </tr>
            <tr>
                <td align="center" >User Name:</td>
                <td><input type="text" name="name"></td>
            </tr>
            <tr>
                <td align="center" >User Password</td>
                <td><input type="password" name="pass"></td>
            </tr>
            <tr>
                <td align="center">Email:</td>
                <td><input type="text" name="email"></td>
            </tr>
            <tr>
                <td colspan="5" align="center"><input type="submit" name="submit" value="Sign Up!"></td>

            </tr>
        </table>
    </form>
    <center><b>Already Registered?</b><br><a href="login.php">Login Here!</a></center>
</body>
<footer></footer>
</html>

<?php
#mysql_connect("localhost", "root", "");
#mysql_select_db("users_db");


$servername = "localhost";
$username = "root";
$password = "Kodex2000";
$dbname = "users_db";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if (isset($_POST['submit'])) {
    $user_pass =  $_POST['pass'];
    $user_email =  $_POST['email'];
    $user_name =  $_POST['name'];
    $check_email = 'select * from users where user_email = $user_email';
    $run = mysql_query($check_email);
    if ($user_name =='') {
        echo '<script>alert ("Please enter your name!") </script>';
        exit();
    }
    else if ($user_pass =='') {
        echo '<script>alert ("Please enter your password!") </script>';
        exit();
    }
    else if ($user_email =='') {
        echo '<script>alert ("Please enter your email!") </script>';
        exit();
    }
    else if (mysql_num_rows($run)>0) {
        echo '<script> alert ("email " +$user_email+ " is already registered. Please enter another email!") </script>';
    }
    else {

        $sql = "INSERT INTO users (user_name, user_pass, user_email) values  ('$user_name', '$user_pass', '$user_email')";

        if ($conn->query($sql) === TRUE) {
            echo "New record created successfully";
        }
        else {
            echo "Error: " . $sql . "<br>" . $conn->error;
        }

        $conn->close();

    }
}
?>