Untitled

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Registration</title>
<link rel="stylesheet" href="css/style1.css" />
</head>
<body>

<?php
                  require('db.php');
                    // If form submitted, insert values into the database.


               if (isset($_REQUEST['username'])){
                            // removes backslashes
                   $username = stripslashes($_REQUEST['username']);
                            //escapes special characters in a string
                    $username = mysqli_real_escape_string($con,$username);

                    $email = stripslashes($_REQUEST['email']);
                    $email = mysqli_real_escape_string($con,$email);

                    $telefono = stripslashes($_REQUEST['telefono']);
                    $telefono = mysqli_real_escape_string($con,$telefono);

                    $empresa = stripslashes($_REQUEST['empresa']);
                    $empresa = mysqli_real_escape_string($con,$empresa);

                    $password = stripslashes($_REQUEST['password']);
                    $password = mysqli_real_escape_string($con,$password);

                    $trn_date = date("Y-m-d H:i:s");

// validacion de usuario registrado

            include 'db.php';

                $buscarUsuario = "SELECT * FROM users WHERE email = '$_POST[email]' ";
                $result = $con ->query($buscarUsuario);
                $count = mysqli_num_rows($result);

            if($count == 1) {header("Location: registration_duplicated.php");}

                else{

                      $query = "INSERT into `users` (username, password, email, telefono, empresa, trn_date)
                                        VALUES ('$username', '".md5($password)."', '$email', '$telefono','$empresa', '$trn_date')";

                       $result = mysqli_query($con,$query);

                     if($result){header("Location: Registro_exitoso.php");}

                        }}

                        else{
                    ?>

    <div class="wrapper fadeInDown1">
    <div id="formContent">

                <a href="login.php"><h2 class="inactive underlineHover"> Ingresar </h2></a>
                <h2 class="active"> Registrarte </h2>


                        <form name="registration" action="" method="post">


                            <input type="text" class="fadeIn regitration" name="username" placeholder="Usuario" required />

                            <input type="email"  class="fadeIn regitration" name="email" placeholder="Correo" required />

                            <input type="password" class="fadeIn regitration" name="password" placeholder="Contraseña" required />

                            <input type="tel" class="fadeIn regitration" name="telefono" placeholder="Telefono" required />

                            <input type="text" class="fadeIn regitration" name="empresa" placeholder="Empresa" required />

                            <input type="submit" class="fadeIn regitration" name="submit" value="Registrarse" />

                        </form>


    </div>
    </div>


<?php } ?>
</body>
</html>

<!DOCTYPE html>
    <html>
    <head>
    <meta charset="utf-8">
    <title>Registration</title>
    <link rel="stylesheet" href="css/style1.css" />
    </head>
    <body>

    <?php
                      require('db.php');
                        // If form submitted, insert values into the database.


                   if (isset($_POST['submit'])){
                                // removes backslashes
                       $username = stripslashes($_POST['username']);
                                //escapes special characters in a string
                        $username = mysqli_real_escape_string($con,$username);

                        $email = stripslashes($_POST['email']);
                        $email = mysqli_real_escape_string($con,$email);

                        $telefono = stripslashes($_POST['telefono']);
                        $telefono = mysqli_real_escape_string($con,$telefono);

                        $empresa = stripslashes($_POST['empresa']);
                        $empresa = mysqli_real_escape_string($con,$empresa);

                        $password = stripslashes($_POST['password']);
                        $password = mysqli_real_escape_string($con,$password);

                        $trn_date = date("Y-m-d H:i:s");

    // validacion de usuario registrado

                include 'db.php';

                    $buscarUsuario = "SELECT * FROM users WHERE email = '$email' ";
                    $result = $con ->query($buscarUsuario);
                    $count = mysqli_num_rows($result);

                if($count > 0) {

                      header("Location: registration_duplicated.php");

                    }else{

                          $query = "INSERT into `users` (username, password, email, telefono, empresa, trn_date)
                                            VALUES ('$username', '".md5($password)."', '$email', '$telefono','$empresa', '$trn_date')";

                           $result = mysqli_query($con,$query);

                         if($result){
                       header("Location: Registro_exitoso.php");

                           } else{

                         echo"hubo un error.mysqli_error($con)";


                        }
                    }
                        ?>

        <div class="wrapper fadeInDown1">
        <div id="formContent">

                    <a href="login.php"><h2 class="inactive underlineHover"> Ingresar </h2></a>
                    <h2 class="active"> Registrarte </h2>


                            <form name="registration" action="" method="post">


                                <input type="text" class="fadeIn regitration" name="username" placeholder="Usuario" required />

                                <input type="email"  class="fadeIn regitration" name="email" placeholder="Correo" required />

                                <input type="password" class="fadeIn regitration" name="password" placeholder="Contraseña" required />

                                <input type="tel" class="fadeIn regitration" name="telefono" placeholder="Telefono" required />

                                <input type="text" class="fadeIn regitration" name="empresa" placeholder="Empresa" required />

                                <input type="submit" class="fadeIn regitration" name="submit" value="Registrarse" />

                            </form>


        </div>
        </div>

    </body>
    </html>