Crear un Registro de usuarios con PHP y MySQL

Crear un Registro de usuarios en PHP con MySQL link: https://www.youtube.com/watch?v=Jy5ij1t9TJU link: https://www.youtube.com/watch?v=kcUmma2K350 link: https://www.youtube.com/watch?v=sciqTfZyKAI index.php connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM usuarios WHERE Username = '$user' AND Password = '$pass'"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $_SESSION['user']=$row["Username"]; header("Location: perfil.php"); } } else { echo "Sus datos estan incorrectos!"; } $conn->close(); } if (!empty($_POST['submit'])) { $nameF=$_POST['NameF']; $nameL=$_POST['NameL']; $username1=$_POST['Username']; $email=$_POST['Email']; $emailR=$_POST['EmailR']; $password2=$_POST['Password2']; $password1=$_POST['Password']; $servername = "localhost"; $username = "root"; $password = ""; $date=""; $dbname = "loginandregister"; //echo $nameF."//
".$nameL."//
".$username1."//
".$email."//
".$emailR."//
".$password2."//
".$password1."//"; if ($email==$emailR) { # code... if ($password2==$password1) { if (!empty($nameF)) { if (!empty($nameL)) { # code... if (!empty($username1)) { $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $email = strtolower($email); $password1=md5($password1); $date=date("F j, Y, g:i a"); $sql = "INSERT INTO usuarios (id, NameF, NameL, Email, Password, Date1, Username) VALUES ('', '".$nameF."', '".$nameL."', '".$email."', '".$password1."', '".$date."', '".$username1."')"; if ($conn->query($sql) === TRUE) { echo "Se ha registrado con exito"; } else { echo "Error: " . $sql . "
" . $conn->error; } $conn->close(); } else{ echo "Ingrese su usuario"; } } else{ echo "Ingrese su segundo nombre"; } } else{ echo "Ingrese su primer nombre"; } } else{ echo "Sus contraseñas no son iguales"; } } else { echo "Sus correo no son iguales"; } } ?> perfil.php Cerrar "; ?> cerrar.php check.php