-
Notifications
You must be signed in to change notification settings - Fork 0
/
login
129 lines (110 loc) · 3.73 KB
/
login
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
// Define the path to the database
$path = 'C:\Users\Public\v-apps\xampp\htdocs\Stage3\Yon-Database.db';
$realPath = realpath($path);
// Initialize error message variable
$error_message = "";
// Check if the form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
// Retrieve form data
$email = $_POST['email'];
$password = $_POST['password'];
// Check if the database file exists
if ($realPath === false) {
$error_message = "The database file does not exist.";
} else {
// Open SQLite database connection
$db = new SQLite3($realPath);
// Check if the connection is successful
if (!$db) {
$error_message = "Error: Unable to open database.";
} else {
// Query the user table to check if the provided credentials are valid
$query = "SELECT * FROM user WHERE email=:email AND password=:password";
$stmt = $db->prepare($query);
$stmt->bindValue(':email', $email, SQLITE3_TEXT);
$stmt->bindValue(':password', $password, SQLITE3_TEXT);
$result = $stmt->execute();
// Check if the query returns any rows
if (!$result->fetchArray(SQLITE3_ASSOC)) {
// Set error message
$error_message = "Invalid email or password.";
} else {
// Redirect to another page upon successful login
header("Location: view_mortgage-product.php"); // Change to your desired page
exit();
}
// Close the database connection
$db->close();
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Login Page</title>
<link rel="stylesheet" href="styles.css">
<style>
.broker-login-box {
margin-top: 20px;
}
.broker-login-box h2 {
margin-bottom: 10px;
}
.broker-login-box p {
margin-bottom: 20px;
}
.broker-login-button {
display: inline-block;
padding: 10px 20px;
background-color: #007bff;
color: #fff;
text-decoration: none;
border-radius: 5px;
transition: background-color 0.3s;
}
.broker-login-button:hover {
background-color: #0056b3;
}
.error-message {
color: red;
margin-top: 10px;
text-align: center;
}
</style>
</head>
<body>
<header>
<nav>
<ul>
<li><a href="homepagee.html">Home</a></li>
<li><a href="login.php">Login</a></li>
<li><a href="create-account.php">Create an Account</a></li>
<li><a href="contact-us.html">Contact Us</a></li>
</ul>
</nav>
</header>
<div class="left-background"></div>
<div class="right-background"></div>
<div class="container">
<h1>Login</h1>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>">
<input type="text" id="email" name="email" placeholder="Email">
<input type="password" id="password" name="password" placeholder="Password">
<input type="submit" value="Confirm">
</form>
<div class="error-message">
<?php echo $error_message; ?>
</div>
<!-- Broker Login Box -->
<div class="broker-login-box">
<h2>Broker Login</h2>
<p>If you are a broker, please login below:</p>
<a class="broker-login-button" href="broker-login.php">Broker Login</a>
</div>
</div>
</body>
</html>