Here's the html code
when I try to submit the data it just opens the 'signup.inc.php' file that is in the includes folder, and it does not post the data into the table
<?
session_start();
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<!-- Navbar [Navigation] -->
<nav class="navbar">
<!-- Right buttons -->
<div class="nav-btn-right">
<ul>
<li><a href="#">Login</a></li>
<li style="padding-right: 2rem;"><a href="#">Signup</a></li>
</ul>
</div>
<!-- Left Buttons -->
<div class="nav-btn-left">
<ul>
<li style="padding-left: 2rem;"><a href="#">Database</a></li>
</ul>
</div>
</nav>
<!-- background image -->
<div class="login-container">
<div class="login-input">
<div class="login-header">
<h2>LOGIN</h2>
</div>
<form action="includes/signup.inc.php" method="POST">
<fieldset>First Name</fieldset>
<input type="text" name="first_name">
<fieldset>Last Name</fieldset>
<input type="text" name="last_name">
<fieldset>Email Address</fieldset>
<input type="text" name="email_address">
<fieldset>Password</fieldset>
<input type="text" name="password">
<div class="login-submit-btn">
<button name="submit" type="submit">SUBMIT</button>
</div>
</form>
</div>
</div>
</body>
</html>
and here's the php code for signup that is in a separate folder (includes)
<?
if (isset($_POST['submit'])){
include_once 'dbh.inc.php';
//user data variables
$first_name = ucwords($conn, $_POST['first_name']);
$last_name = ucwords($conn, $_POST['last_name']);
$email_address = strtolower($conn, $_POST['email_address']);
$password = mysqli_real_escape_string ($conn, $_POST['password']);
if(empty($first_name) || empty($last_name) || empty($email_address) || empty($password)){
header("Location: ../index.php?empty");
exit();
}else {
if(!filter_var($email_address, FILTER_VALIDATE_EMAIL){
header("Location: ../index.php?email=invalid");
exit();
}else {
if ($password < 6 || $password <33) {
header("Location: ../index.php?password=invalid");
exit();
}
$sql = "INSERT INTO db_lab (first_name, last_name, email_address, password) VALUES ('$first_name', '$last_name', '$email_address', '$password');";
mysqli_query($conn, $sql);
//signup success
header("Location: ../index.php?success");
exit();
}
}
}
}else{
header('Location: ../index.php');
exit();
}
and here's the database connection code that is in the separate folder with the signup code file
<?php
$dbServername = "127.0.0.1";
$dbUsername = "root";
$dbPassword = "";
$dbName = "databasse";
$conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
Aucun commentaire:
Enregistrer un commentaire