i am creating an login form and earlier it worked, it did login but now it wont it is just hard stuck here in invalid password even if i put a correct password
i did try using ai or watching yt vids but nothing seems to help, it also wont even show the scripts code. please help this is my first time working in this so bear wth me
<?php
session_start();
$host = 'localhost';
$dbusername = 'root';
$dbpassword = '';
$dbname = 'enrollment_form';
// Connect to the database
$conn = mysqli_connect($host, $dbusername, $dbpassword, $dbname);
// Check for connection errors
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
if (isset($_POST['email']) && isset($_POST['password'])) {
function validate($data){
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
$email = validate($_POST['email']);
$password = validate($_POST['password']);
if (empty($email)) {
header("Location: login.php?error=email is required");
exit();
}else if(empty($password)){
header("Location: login.php?error=Password is required");
exit();
}else{
$sql = "SELECT * FROM registration WHERE email='$email' AND password='$password'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) === 1) {
$row = mysqli_fetch_assoc($result);
if ($row['user_name'] === $email && $row['password'] === $password) {
$_SESSION['user_name'] = $row['user_name'];
$_SESSION['name'] = $row['name'];
$_SESSION['id'] = $row['id'];
header("Location: home.php");
exit();
}else{
header("Location: login.php?error=Incorect email or password");
exit();
}
}else{
header("Location: login.php?error=Incorect email or password");
exit();
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Login</title>
<link rel="stylesheet" href="new.css">
</head>
<body>
<div class="login-container">
<header>
<a href="index.html">
<h2 class="logo"></h2>
</a>
<nav class="navigation">
<a href="home.php">Home</a>
<a href="enrollment.php">Enroll</a>
<a href="contact.php">Contact Us</a>
<button class="btnLogin-popup">Login</button>
</nav>
</header>
<div class="wrapper">
<span class="icon-close">
<ion-icon name="close-outline" onclick="redirectHomepage()"></ion-icon>
</span>
<div class="form-box Login">
<h2>Login</h2>
<form method="POST">
<div class="input-box">
<label for="email">Email</label>
<ion-icon name="mail-outline"></ion-icon>
<input type="email" id="email" name="email" placeholder="Email" required>
</div>
<div class="input-box">
<label for="password">Password</label>
<ion-icon name="lock-closed-outline" class="icon"></ion-icon>
<input type="password" id="password" name="password" placeholder="Password" required>
</div>
<button type="submit" class="btn" name="submit">Login</button>
<div class="register-link">
<p>Don't have an account</p>
<a href="registration.php">Create an Account</a>
</div>
</form>
</div>
</div>
</div>
<script type="module" src="https://unpkg.com/[email protected]/dist/ionicons/ionicons.esm.js"></script>
<script src="script.js"></script>
</body>
</html>