url이 바뀌지 않고 json출력을 바꿔가는 방법 연습
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Document</title>
</head>
<body>
<h1>안녕하세요 ejs파일 테스트</h1>
<ul style="display: flex; list-style: none">
<li
onclick="getItemBy('가전제품')"
style="border: 1px solid black; margin: 10px">
가전제품
</li>
<li
onclick="getItemBy('컴퓨터')"
style="border: 1px solid black; margin: 10px">
컴퓨터
</li>
<li
onclick="getItemBy('생활용품')"
style="border: 1px solid black; margin: 10px">
생활용품
</li>
</ul>
<div id="list"></div>
<script>
getItemBy("가전제품");
function getItemBy(name) {
const url = "/" + "category" + "/" + name;
fetch(url)
.then((res) => res.json())
.then((result) => {
const output = `${result
.map(
(v) => `
<h1>${v.category_name}</h1>
<h1>${v.product_name}</h1>
<h1>${v.unit_price}</h1>`
)
.join("\n")}`;
document.querySelector("#list").innerHTML = output;
});
}
</script>
</body>
</html>import * as categoryRepository from "../repository/categoryRepository.js";
export async function getHome(req, res) {
res.render("index.ejs");
}
export async function getList(req, res) {
let { page } = req.params;
const row = await categoryRepository.getHome(page);
res.json(row);
}import { db } from "../db/database.js";
export async function getHome(name) {
return db
.execute(
"SELECT category_name, product_name , unit_price, sub_category_name FROM order_detail od INNER JOIN product p ON od.product_id = p.product_id INNER JOIN sub_category sc ON sc.sub_category_id = p.sub_category_id INNER JOIN category c ON c.category_id = sc.category_id WHERE category_name = ?",
[name]
)
.then((result) => result[0]);
}'프로그래밍 > NodeJS' 카테고리의 다른 글
| NodeJS React환경에서 로그인 기능(쿠키) 구현하기 (4) | 2023.11.17 |
|---|---|
| aws s3 이미지 업로드 (0) | 2023.11.15 |
| bcrypt를 사용한 암호 해시화(암호화)하기 (0) | 2023.10.26 |
| node.js환경에서 mysql 연동 세팅하기 (1) | 2023.10.23 |
| method-override (0) | 2023.10.05 |