将动态生成的表单数据插入mysql

CREATE TABLE form_data (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  email VARCHAR(255)
);

const express = require('express');
const mysql = require('mysql');
const app = express();

// 创建MySQL连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

// 处理POST请求，将表单数据插入数据库
app.post('/submit-form', (req, res) => {
  const { name, email } = req.body;

  // 执行插入数据的SQL语句
  const sql = `INSERT INTO form_data (name, email) VALUES ('${name}', '${email}')`;
  connection.query(sql, (error, results) => {
    if (error) throw error;
    res.send('Form data inserted successfully!');
  });
});

// 启动服务器
app.listen(3000, () => {
  console.log('Server is running on port 3000');
});

<form id="myForm" action="/submit-form" method="post">
  <input type="text" name="name" placeholder="Name">
  <input type="email" name="email" placeholder="Email">
  <button type="submit">Submit</button>
</form>

<script>
  document.getElementById('myForm').addEventListener('submit', function(event) {
    event.preventDefault(); // 阻止表单默认提交行为

    const form = event.target;
    const formData = new FormData(form);

    // 发送表单数据到后端
    fetch(form.action, {
      method: form.method,
      body: formData
    })
    .then(response => response.text())
    .then(data => {
      console.log(data); // 输出后端返回的响应
    })
    .catch(error => {
      console.error(error);
    });
  });
</script>