$$config title: [Project] 회원 출석체크하기 keywords: - IT - ... $$ # checked 하기 1 sql에 컬럼을 추가 -> ALTER TABLE `member` ADD checked TINYINT UNSIGNED NOT NULL; ## MemberListItem.jsx ```js { // console.log("사람눌림"); onToggle(id); }} > {checked ? : } ``` # react_ app.js ```js const onToggle = async (id) => { try { const data = await axios({ url: `http://localhost:4000/members/check/${id}`, method: "PATCH", }); setMembers(data.data); } catch (e) { setError(e); } }; ``` # node_project ```js import express from "express"; import mysql from "mysql2/promise"; import cors from "cors"; const pool = mysql.createPool({ host: "localhost", user: "sbsst", password: "sbs123414", database: "information", waitForConnections: true, connectionLimit: 10, queueLimit: 0, }); const app = express(); app.use(cors()); const port = 4000; app.get("/member", async (req, res) => { const [rows] = await pool.query("SELECT * FROM member"); res.json(rows); }); //조회 app.get("/member/:id", async (req, res) => { const { id } = req.params; const [member] = await pool.query( ` select * from member where id = ? `, [id] ); if (!member) { res.status(404).json({ msg: "not found", }); return; } res.json(member); }); app.patch("/"); //db 체크 수정_SQL CHECKED app.patch("/members/check/:id", async (req, res) => { const { id } = req.params; const [[memberRow]] = await pool.query( ` SELECT * FROM member WHERE id = ? `, [id] ); console.log(memberRow); if (memberRow === undefined) { res.status(404).json({ msg: "not found", }); return; } await pool.query( ` UPDATE member SET checked = ? WHERE id = ? `, [!memberRow.checked, id] ); const [updatedMembers] = await pool.query( ` SELECT * FROM member ORDER BY id ASC ` ); res.json(updatedMembers); }); app.listen(port, () => { console.log(`Example app listening on port ${port}`); }); ```