-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.js
60 lines (51 loc) · 1.17 KB
/
index.js
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
const express = require("express");
const app = express();
const mysql = require("mysql");
const cors = require("cors");
app.use(cors());
//connecting to my server.
const db = mysql.createConnection({
user: "root",
host: "localhost",
password: "password",
database: "climbingstoreserver",
});
app.use(express.json());
//get all users.
app.get("/users", (req, res) => {
db.query("SELECT * FROM users;", (err, result) => {
if (err) {
res.status(400).json(err);
} else {
res.status(200).json(result);
}
});
});
//creating new users.
app.post("/users", (req, res) => {
const { email, password } = req.body;
db.query(
"INSERT INTO users (email, password) VALUES (?,?)",
[email, password],
(err, result) => {
if (err) {
res.status(400).json(err);
} else {
res.status(200).json(result);
}
}
);
});
//get all the products.
app.get("/products", (req, res) => {
db.query("SELECT * FROM products;", (err, result) => {
if (err) {
res.status(400).json(err);
} else {
res.status(200).json(result);
}
});
});
app.listen(3000, () => {
console.log("Server is running on port 3000");
});