'Sweetalert2 insert php
I have this code and I have the following error when I implement .js with sweetalert2 with the error messages it does not insert the post in the database, so how much do I remove the .js from the code if it inserts the post in the database data.
Even if I write mismatched passwords it tells me that they match the implemented sweetalert code, so if the trac works all right.
$('#formLogin').submit(function(e){
e.preventDefault();
var password =$.trim($("#password").val());
var cpassword =$.trim($("#cpassword").val());
if(password == cpassword){
Swal.fire({
type:'success',
title:'¡Registre exitos!',
confirmButtonColor:'#3085d6',
confirmButtonText:'Ingresa'
}).then((result) => {
if(result.value){
//window.location.href = "vistas/pag_inicio.php";
window.location.href = "dashboard/index.php";
}
})
return false;
}
else{
Swal.fire({
type:'warning',
title:'Registre erroneo',
});
}
});
@font-face {
font-family: Poppins-Regular;
src: url('fuentes/poppins/Poppins-Regular.ttf');
}
@font-face {
font-family: Poppins-Medium;
src: url('fuentes/poppins/Poppins-Medium.ttf');
}
@font-face {
font-family: Poppins-Bold;
src: url('fuentes/poppins/Poppins-Bold.ttf');
}
@font-face {
font-family: Poppins-SemiBold;
src: url('fuentes/poppins/Poppins-SemiBold.ttf');
}
*{
margin: 0px;
padding: 0px;
box-sizing: border-box;
}
body, html {
height: 100%;
font-family: Poppins-Regular, sans-serif;
}
input {
outline: none;
border: none;
}
button {
outline: none !important;
border: none;
background: transparent;
}
button:hover {
cursor: pointer;
}
/*-- contenedor del Login--*/
.container-login {
width: 100%;
min-height: 100vh;
display: -webkit-flex;
display: flex;
flex-wrap: wrap;
justify-content: right;
align-items: center;
padding: 15px;
/*background-image: url(../images/Portada/portada1.jpg)
/*background: -webkit-linear-gradient(to right, #00dbde, #fc00ff);
background: linear-gradient(to right, #00dbde, #fc00ff);*/
}
.wrap-login {
width: 400px;
background: #eceff1;
border-radius: 20px;
overflow: hidden;
padding: 77px 55px 53px 55px;
margin-right: 105px;
-webkit-box-shadow: 25px 40px 28px 0px rgba(0, 0, 0, 0.38);
/* box-shadow: eje-x | eje-y | blur-radius | color */
}
/*----Formulario de user y password----*/
.login-form {
width: 100%;
}
.login-form-title {
display: block;
font-family: Poppins-Bold;
font-size: 40px;
color: #333333;
line-height: 2;
text-align: left;
}
/*------------------------------------------------------------------
[ Input ]*/
.wrap-input100 {
width: 100%;
position: relative;
border-bottom: 2px solid #adadad;
margin-bottom: 37px;
}
.input100 {
font-family: Poppins-Regular;
font-size: 15px;
color: #555555;
line-height: 1.2;
display: block;
width: 100%;
height: 45px;
background: transparent;
padding: 0 5px;
}
/*---------------------------------------------*/
.focus-efecto {
position: absolute;
display: block;
width: 100%;
height: 100%;
top: 0;
left: 0;
pointer-events: none;
}
.focus-efecto::before {
content: "";
display: block;
position: absolute;
bottom: -2px;
left: 0;
width: 0;
height: 4px; /*ancho de la linea que hace el efecto de barra de progeso en el input al hacer foco*/
-webkit-transition: all 0.4s;
-o-transition: all 0.4s;
-moz-transition: all 0.4s;
transition: all 0.4s;
background: #6a7dfe;
background: -webkit-linear-gradient(left, #2196f3, #0058b1);
background: -o-linear-gradient(left, #2196f3, #0058b1);
background: -moz-linear-gradient(left, #2196f3, #0058b1);
background: linear-gradient(left, #2196f3, #0058b1);
}
.focus-efecto::after {
font-family: Poppins-Regular;
font-size: 15px;
color: #999999;
line-height: 1.2;
content: attr(data-placeholder);
display: block;
width: 100%;
position: absolute;
top: 16px;
left: 0px;
padding-left: 5px;
-webkit-transition: all 0.4s;
-o-transition: all 0.4s;
-moz-transition: all 0.4s;
transition: all 0.4s;
}
.input100:focus + .focus-efecto::after {
top: -15px;
}
.input100:focus + .focus-efecto::before {
width: 100%;
}
.has-val.input100 + .focus-efecto::after {
top: -15px;
}
.has-val.input100 + .focus-efecto::before {
width: 100%;
}
/*---------------------------------------------*/
/*------------------------------------------------------------------
[ Button ]*/
.container-login-form-btn {
display: -webkit-box;
display: -webkit-flex;
display: -moz-box;
display: -ms-flexbox;
display: flex;
flex-wrap: wrap;
justify-content: center;
padding-top: 13px;
}
.wrap-login-form-btn {
width: 100%;
display: block;
position: relative;
z-index: 1;
border-radius: 40px 5px;
overflow: hidden;
margin: 0 auto;
}
.login-form-bgbtn {
position: absolute;
z-index: -1;
width: 300%;
height: 100%;
background: #a64bf4;
background: -webkit-linear-gradient(right, #2196f3, #0058b1, #2196f3, #0058b1);
background: -o-linear-gradient(right, #2196f3, #0058b1, #2196f3, #0058b1);
background: -moz-linear-gradient(right, #2196f3, #0058b1, #2196f3, #0058b1);
background: linear-gradient(right, #2196f3, #0058b1, #2196f3, #0058b1);
top: 0;
left: -100%;
-webkit-transition: all 0.4s;
-o-transition: all 0.4s;
-moz-transition: all 0.4s;
transition: all 0.4s;
}
.login-form-btn {
font-family: Poppins-Medium;
font-size: 20px;
color: #fff;
line-height: 1.2;
text-transform: uppercase;
display: -webkit-box;
display: -webkit-flex;
display: -moz-box;
display: -ms-flexbox;
display: flex;
justify-content: center;
align-items: center;
padding: 0 20px;
width: 100%;
height: 50px;
}
.wrap-login-form-btn:hover .login-form-bgbtn {
left: 0;
}
/*--- Para dispositivos small responsive ---*/
@media (max-width: 576px) {
.wrap-login {
padding: 77px 15px 33px 15px;
}
}
@media (max-width: 820px) {
.wrap-login {
margin-right: 0px;
}
.container-login {
justify-content: center;
}
}
<html>
<head>
<title>Sign In</title>
<link rel="icon" type="image/png" href="../images/favicon.png" sizes="52x52"/>
<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="estilos.css">
<link rel="stylesheet" href="plugins/sweetalert2/sweetalert2.min.css">
<link rel="stylesheet" type="text/css" href="fuentes/iconic/css/material-design-iconic-font.min.css">
</head>
<body>
<div class="container-login">
<div class="wrap-login">
<form class="login-form validate-form" id="formLogin" action="bd/create.php" method="post">
<span class="login-form-title">Sign In</span>
<div class="wrap-input100" data-validate = "Usuario incorrecto">
<input class="input100" type="text" name="username" placeholder="Nom" required="required">
<span class="focus-efecto"></span>
</div>
<div class="wrap-input100" data-validate = "Usuario incorrecto">
<input class="input100" type="text" name="email" placeholder="Email" required="required">
<span class="focus-efecto"></span>
</div>
<div class="wrap-input100" data-validate="Password incorrecto">
<input class="input100" type="password" name="password" placeholder="Contrasenya" required="required">
<span class="focus-efecto"></span>
</div>
<div class="wrap-input100" data-validate="Password incorrecto">
<input class="input100" type="password" name="cpassword" placeholder="Confirma Contrasenya" required="required">
<span class="focus-efecto"></span>
</div>
<div class="container-login-form-btn">
<div class="wrap-login-form-btn">
<div class="login-form-bgbtn"></div>
<button type="submit" class="login-form-btn">CREAR USUARI</button>
</div>
</div>
</form>
</div>
</div>
<script src="jquery/jquery-3.3.1.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
<script src="popper/popper.min.js"></script>
<script src="plugins/sweetalert2/sweetalert2.all.min.js"></script>
<script src="codigo_registro.js"></script>
</body>
</html>
<?php
require('../dbconnect.php');
// When 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);
$password = stripslashes($_REQUEST['password']);
$password = mysqli_real_escape_string($con, $password);
$query = "INSERT into `usuaris` (username, email, password)
VALUES ('$username', '$email', '" . md5($password) . "')";
$select_email = mysqli_query($con, "SELECT * FROM usuaris WHERE email = '".$_POST['email']."'");
if(mysqli_num_rows($select_email)) {
echo 'This email already exists';
}
//Comprovar si les contrasenyes coincideixen
else if ($_POST["password"] === $_POST["cpassword"]) {
$result = mysqli_query($con, $query);
if ($result) {
echo "You are registered successfully.";
} else {
echo "Click here to ";
}
}
else {
echo "Les Contrasenyes no coincideixen";
}
} else {}
?>
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
