数据库留言板编辑代码

const express = require('express');
const mysql = require('mysql');
const bodyParser = require('body-parser');

const app = express();
app.use(bodyParser.urlencoded({ extended: true }));

const db = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'message_board'
});

db.connect((err) => {
  if (err) throw err;
  console.log('Database connected!');
});

app.get('/edit/:id', (req, res) => {
  const id = req.params.id;
  db.query('SELECT * FROM messages WHERE id = ?', [id], (err, results) => {
    if (err) throw err;
    res.send(`
      <form action="/update/${id}" method="post">
        <input type="hidden" name="id" value="${results[0].id}">
        <textarea name="message">${results[0].message}</textarea><br>
        <button type="submit">Update</button>
      </form>
    `);
  });
});

app.post('/update/:id', (req, res) => {
  const id = req.params.id;
  const message = req.body.message;
  db.query('UPDATE messages SET message = ? WHERE id = ?', [message, id], (err, result) => {
    if (err) throw err;
    res.redirect('/');
  });
});

app.listen(3000, () => {
  console.log('Server started on port 3000');
});