削除
<form action="/delete/<%= item.id %>" method="post">
<input type="submit" value="削除">
</form>
app.post('/delete/:id', (req, res) => {
connection.query(
'DELETE FROM items WHERE id = ?',
[req.params.id],
(error, results) => {
res.redirect('/index');
}
);
});
編集
<a href="/edit/<%= item.id %>">編集</a>
<form action="/update/<%= item.id %>" method="post">
<input type="text" name="itemName" value="<%= item.name %>">
<input type="submit" value="更新する">
</form>
app.get('/edit/:id', (req, res) => {
connection.query(
'SELECT * FROM items WHERE id = ?',
[req.params.id],
(error, results) => {
res.render('edit.ejs', {item: results[0]});
}
);
});
更新
<form action="/update/<%= item.id %>" method="post">
<input type="text" name="itemName" value="<%= item.name %>">
<input type="submit" value="更新する">
</form>
app.post('/update/:id', (req, res) => {
connection.query(
'update items set name=? WHERE id = ?',
[req.body.itemName,req.params.id],
(error, results) => {
res.redirect('/index');
}
);
});