<?php
mysql_connect("127.0.0.1", "root", "") or die("db not found");
mysql_select_db("dad") or die("db not select");

if(isset($_POST['Sign Up'])) {
$username =$_POST['username'];
$password =$_POST['password'];
$password2 =$_POST['password2'];
$email =$_POST['email'];
$sql = mysql_query("SELECT * FROM users WHERE username = '$username'") or die("mysql error");
$row = mysql_fetch_assoc($sql);
$row['username'];
if($username == $row['username']) {
echo "sorry this user is found";
exit();
}
$sql2 = mysql_query("SELECT * FROM users WHERE email = '$email'") or die("mysql error");
$row2 = mysql_fetch_assoc($sql2);
$row2['email'];
if($email == $row2['email']) {
echo "sorry this email is found";
exit();
}
if($password == $password2) {
        $newPass = md5($password) ;
        $users = mysql_query("INSERT INTO users VALUES ('', '$username', '$newPass', '$email')");
        echo "sign up is done"; } else {
    echo "password not match";
    }
}

?>