Untitled

<?php
require "db.php";
// Comienza código  de registro.
$mysql_table = 'usuarios';
$success_page = '#';
$error_message = "";
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['form_name']) && $_POST['form_name'] == 'quickregister')
{
   $newusername = $_POST['username'];
   $salt = $_POST['username'];
   $newemail = $_POST['email'];
   $newpassword = $_POST['password'];
   $confirmpassword = $_POST['confirmpassword'];
   $firstname = $_POST['firstname'];
   $surname = $_POST['surname'];
   $phone = $_POST['phone'];
   $role = $_POST['role'];
   if ($newpassword != $confirmpassword)
   {
      $error_message = 'Las claves ingresadas no coinciden';
   }
   else
   if (!preg_match("/^[A-Za-z0-9_!@$]{1,50}$/", $newusername))
   {
      $error_message = 'No puedes utilizar caracteres especiales con el usuario, intenta con otro';
   }
   else
   if (!preg_match("/^[A-Za-z0-9_!@$]{1,50}$/", $newpassword))
   {
      $error_message = 'La contraseña seleccionada no es segura, intenta con otra';
   }
   else
   if (!preg_match("/^.+@.+\..+$/", $newemail))
   {
      $error_message = 'Debes ingresar un formato de e-mail válido';
   }
   if (empty($error_message))
   {
      mysqli_select_db($conn, $_db) or die('Ocurrió un error al seleccionar la base de datos<br>'.mysqli_error($conn));
      mysqli_set_charset($conn, 'utf8');
      $sql = "SELECT username FROM ".$mysql_table." WHERE username = '".$newusername."'";
      $result = mysqli_query($conn, $sql);
      if ($data = mysqli_fetch_array($result))
      {
         $error_message = 'Ya hay un usuario utilizando este nombre de usuario, intenta con otro.';
      }
      mysqli_select_db($conn, $_db) or die('Ocurrió un error al seleccionar la base de datos<br>'.mysqli_error($conn));
      mysqli_set_charset($conn, 'utf8');
      $sql = "SELECT email FROM ".$mysql_table." WHERE email = '".$newemail."'";
      $result = mysqli_query($conn, $sql);
      if ($data = mysqli_fetch_array($result))
      {
         $error_message = 'Parece que ya has usado este correo para registrar a otro usuario';
      }
   }
   if (empty($error_message))
   {
      $crypt_pass = md5(md5($salt).md5($newpassword));
      $newusername = mysqli_real_escape_string($conn, $newusername);
      $newemail = mysqli_real_escape_string($conn, $newemail);
      $firstname = mysqli_real_escape_string($conn, $firstname);
      $surname = mysqli_real_escape_string($conn, $surname);
      $phone = mysqli_real_escape_string($conn, $phone);
      $role = mysqli_real_escape_string($conn, $role);
      $sql = "INSERT `".$mysql_table."` (`username`, `password`, `firstname`, `surname`, `phone`, `email`, `role`) VALUES ('$newusername', '$crypt_pass', '$firstname', '$surname', '$phone', '$newemail', '$role')";
      $result = mysqli_query($conn, $sql);
      if($result ==false)
      {
        echo "Error al insertar datos en la tabla<br> sql = $sql<br>";
        return;
      }
      else
      {
      	echo "Inserido com sucesso<br> sql = $sql<br>";
      }
      mysqli_close($conn);
      header('Location: '.$success_page);
      exit;
   }
}
?>
<html>
<head>
</head>
<body>
<!-- page content -->
<div class="right_col" role="main">
  <div class="">
    <div class="page-title">
      <div class="title_left">
        <h3>Registro de usuarios</h3>
      </div>
    </div>
    <div class="clearfix"></div>
    <div class="row">
      <div class="col-md-12 col-sm-12 ">
        <div class="x_panel">
          <div class="x_title">
            <h2>Nuevo usuario</h2>
            <div class="clearfix"></div>
          </div>
          <div class="x_content">
            <br />
            <form id="quickregister" data-parsley-validate class="form-horizontal form-label-left" action="web_register.php" method="post">
              <input type="hidden" id="form_name" value="quickregister">
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align" for="username">Usuario <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input type="text" id="username" required="required" class="form-control" value="<?php echo $newusername ?>">
                </div>
              </div>
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align" for="password">Contraseña <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input type="password" id="password" required="required" class="form-control" value="<?php echo $newpassword ?>">
                </div>
              </div>
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align" for="confirm_password">Confirmar contraseña <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input type="password" id="confirmpassword" required="required" class="form-control" value="<?php echo $confirmpassword ?>">
                </div>
              </div>
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align" for="firstname">Nombre <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input type="text" id="firstname" name="firstname" required="required" class="form-control" value="<?php echo $firstname ?>">
                </div>
              </div>
              <div class="item form-group">
                <label for="middle-name" class="col-form-label col-md-3 col-sm-3 label-align">Apellido </label>
                <div class="col-md-6 col-sm-6 ">
                  <input id="surname" class="form-control" type="text" name="surname" value="<?php echo $surname ?>">
                </div>
              </div>
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align">Teléfono <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input id="phone" class="date-picker form-control" required="required" type="number" value="<?php echo $phone ?>">
                </div>
              </div>
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align" for="first-name">Correo <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input type="text" id="email" required="required" class="form-control" value="<?php echo $newemail ?>">
                </div>
              </div>
              <div class="item form-group">
                <label class="col-form-label col-md-3 col-sm-3 label-align" for="first-name">Rango <span class="required">*</span>
                </label>
                <div class="col-md-6 col-sm-6 ">
                  <input type="text" id="role" required="required" class="form-control" value="<?php echo $role ?>">
                </div>
              </div>
              <div class="ln_solid"></div>
              <div class="item form-group">
                <div class="col-md-6 col-sm-6 offset-md-3">
                  <button class="btn btn-danger" type="button">Cancelar</button>
      <button class="btn btn-warning" type="reset">Eliminar datos</button>
                  <button type="submit" class="btn btn-success">Confirmar</button>

                  <?php echo $error_message ?>
                </div>
              </div>

            </form>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
</body>
</html>


<!-- /page content -->