-
Notifications
You must be signed in to change notification settings - Fork 0
/
login_u.php
37 lines (33 loc) · 1.4 KB
/
login_u.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
<?php
session_start();
$error = "";
if (isset($_POST["submit"])) {
if (empty($_POST["username"]) || empty($_POST["password"])) {
$error = "Username or Password is invalid";
}
else {
// Define $username and $password
$username = $_POST["username"];
$password = $_POST["password"];
// Establishing Connection with Server by passing server_name, user_id and password as a parameter
require "connection.php";
$conn = Connect();
// SQL query to fetch information of registerd users and finds user match.
$query = "SELECT username, password FROM CUSTOMER WHERE username=? AND password=? LIMIT 1";
// To protect MySQL injection for Security purpose
$stmt = $conn->prepare($query);
$stmt->bind_param("ss", $username, $password);
$stmt->execute();
$stmt->bind_result($username, $password);
$stmt->store_result();
if ($stmt->fetch()) {
$_SESSION["login_user2"] = $username; // Initializing Session
header("location: foodlist.php"); // Redirecting To Other Page
}
else {
$error = "Username or Password is invalid";
}
mysqli_close($conn); // Closing Connection
}
}
?>