Repository navigation
Expand file tree
/
Copy pathserver.js
More file actions
94 lines (74 loc) · 2.01 KB
/
Copy pathserver.js
File metadata and controls
94 lines (74 loc) · 2.01 KB
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
import express from "express";
import mysql from "mysql2";
import cors from "cors";
import dotenv from "dotenv";
const app = express();
dotenv.config();
app.use(cors());
app.use(express.json());
const db = mysql.createConnection({
host: process.env.DB_HOST || "localhost",
user: process.env.DB_USER || "root",
password: process.env.DB_PASSWORD || "",
database: process.env.DB_NAME || "codecampus",
port: Number(process.env.DB_PORT || 3306),
});
let isDbConnected = false;
db.connect((err) => {
if (err) {
console.error("MySQL connection error:", err);
} else {
isDbConnected = true;
console.log("MySQL connected successfully");
}
});
const ensureDbConnected = (req, res, next) => {
if (!isDbConnected) {
return res.status(503).json({
message: "Database unavailable. Verify MySQL is running and DB_* credentials in .env are correct.",
});
}
next();
};
// SIGNUP
app.post("/api/signup", ensureDbConnected, (req, res) => {
const { name, email, password } = req.body;
const sql =
"INSERT INTO users (name,email,password) VALUES (?,?,?)";
db.query(sql, [name, email, password], (err, result) => {
if (err) {
return res.status(500).json({
message: "User already exists or database error",
});
}
res.json({
message: "User registered successfully",
});
});
});
// LOGIN
app.post("/api/login", ensureDbConnected, (req, res) => {
const { email, password } = req.body;
const sql =
"SELECT * FROM users WHERE email = ? AND password = ?";
db.query(sql, [email, password], (err, result) => {
if (err) {
return res.status(500).json({
message: "Database error",
});
}
if (result.length === 0) {
return res.status(401).json({
message: "Invalid email or password",
});
}
res.json({
message: "Login successful",
user: result[0],
});
});
});
const port = Number(process.env.SERVER_PORT || 5001);
app.listen(port, () => {
console.log(`Server running on port ${port}`);
});