I have this problem and I do not understand where the error could be, when I click on the final submit it does not save anything in the DB. If they need another code fragment or show the BD they tell me.
I hope you can tell me why you are not saving, greetings!
Here is the form I use, by clicking the input submit name="btn_registrar" I should call registro_usuarios.php :
<?php
require_once "funciones/db.php";
?>
<!DOCTYPE html>
<html lang="en" >
<head>
<meta charset="UTF-8">
<title></title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/meyer-reset/2.0/reset.min.css">
<link rel="stylesheet" href="css/style_formulario.css">
</head>
<body>
<div class="gradDynamic">
<h1 class="color_letra"> Regístrate y sé parte de nuestra comunidad!</h1>
<!-- multistep form -->
<form role="form" action="funciones/registro_usuarios.php" id="msform" method="POST">
<div id="signupalert" style="display:none">
<p>Error</p>
<span></span>
</div>
<!-- progressbar -->
<ul id="progressbar">
<li class="active">Creacion Cuenta</li>
<li>Detalles Personales</li>
<li>Redes sociales</li>
</ul>
<!-- fieldsets -->
<fieldset>
<h2 class="fs-title">Crea tu Cuenta</h2>
<h3 class="fs-subtitle"> Paso 1</h3>
<input type="text" name="run" placeholder="Run alumno Inacap" >
<input type="text" name="email" placeholder="E-mail institucional" >
<input type="password" name="pass" placeholder="Password" >
<input type="password" name="cpass" placeholder="Confirmar Password" >
<input type="button" name="next" class="next action-button" value="Siguiente" >
</fieldset>
<fieldset>
<h2 class="fs-title">Detalles Personales</h2>
<h3 class="fs-subtitle">Muestrate al mundo!</h3>
<input type="text" name="nombre" placeholder="Nombre" >
<input type="text" name="apellido" placeholder="Apellido" >
<select class="" name="carrera">
<option selected disabled hidden>Selecciona Tu Carrera</option>
<option value="1"> Diseño Web & mobile</option>
<option value="2"> Diseño Grafico</option>
<option value="3"> Diseño Profesional</option>
</select>
<textarea name="about" rows="8" cols="80" placeholder=" Describete a ti mismo!"></textarea >
<input type="button" name="previous" class="previous action-button" value="Anterior" />
<input type="button" name="next" class="next action-button" value="Siguiente" />
</fieldset>
<fieldset>
<h2 class="fs-title">Redes Sociales</h2>
<h3 class="fs-subtitle">Tu presencia en las Redes Sociales</h3>
<input type="text" name="twitter" placeholder="Twitter" >
<input type="text" name="facebook" placeholder="Facebook">
<input type="text" name="linkedin" placeholder="Linkedin" >
<input type="text" name="github" placeholder="Github" >
<input type="text" name="pinterest" placeholder="Pinterest">
<input type="text" name="instagram" placeholder="Instagram" >
<input type="button" name="previous" class="previous action-button" value="Atras" />
<input type="submit" name="btn_registrar" class="submit action-button" value="Crear" />
</fieldset>
</form>
<div class="cuadro">
<img src="css/titulo.png" width="200" height="100">
</div>
</div>
<script src='http://cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script>
<script src='http://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js'></script>
<script src="js/index.js"></script>
</body>
</html>
Here is the part of the file functions / registro_usuarios.php:
<?php
if (isset($_POST['btn_registrar'])){
include_once 'db.php';
// Guardamos los Post del Registro.php
$run = mysqli_real_escape_string($link,$_POST['run']); //mysqli_real_escape_string -- Metodo seguridad, convierte
$email = mysqli_real_escape_string($link,$_POST['email']); //a texto dentro de input para prevenir sql inyection !
$pass = mysqli_real_escape_string($link,$_POST['pass']);
$cpass = mysqli_real_escape_string($link,$_POST['cpass']);
$nombre = mysqli_real_escape_string($link,$_POST['nombre']);
$apellido = mysqli_real_escape_string($link,$_POST['apellido']);
$about = mysqli_real_escape_string($link,$_POST['about']);
//Errores! - Chequeo para campos en blancos!
if(empty($run) || empty($email) || empty($pass) || empty($cpass) || empty($nombre) || empty($apellido) ){
header("Location: ../registro.php?registro=empty");
exit();
} else {
// Chequeamos si los caracteres del input son validos
if(!preg_match("/^[a-zA-Z]*$/", $nombre) || !preg_match("/^[a-zA-Z]*$/", $apellido) || !preg_match("/^[1-9]*$/", $run) ){
header("Location: ../registro.php?registro=invalid");
exit();
} else { // Chequeamos si email es valido
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
header("Location: ../registro.php?registro=email");
exit();
} else{
$sql = "SELECT * FROM usuario WHERE nombre ='$nombre'";
$resultado = mysqli_query($link, $sql);
$resultadoCheck = mysqli_num_rows($resultado);
if($resultadoCheck > 0){
header("Location: ../registro.php?registro=nombreRegistrado");
exit();
} else {
// Hashing la password
$hashedpass = password_hash($pass, PASSWORD_DEFAULT);
// Ingresamos al usuario dentro de la database!
$sql ="INSERT INTO usuario (nombre, apellido, pass, run, email, about) VALUES ('$nombre', '$apellido', '$hashedpass', '$run', '$email', '$about'); ";
mysqli_query($link, $sql);
header("Location: ../registro.php?registro=success");
exit();
}
}
}
}
} else {
header("Location: ../registro.php");
exit();
}
?>
and finally my file functions / db.php:
<?php
function conectar(){
$servidor = "localhost:3306";
$usuario = "root";
$password = "";
$baseDatos = "valpocrea";
$link = mysqli_connect($servidor, $usuario, $password, $baseDatos);
return $link;
}
?>