如何利用Javascript在MySQL数据库中保存复选框数组

<form id="myForm">
  <input type="checkbox" name="fruits[]" value="apple"> Apple
  <input type="checkbox" name="fruits[]" value="banana"> Banana
  <input type="checkbox" name="fruits[]" value="orange"> Orange
  <input type="checkbox" name="fruits[]" value="grape"> Grape
  <input type="button" value="Save" onclick="saveData()">
</form>

<script>
function saveData() {
  var form = document.getElementById("myForm");
  var checkboxes = form.elements["fruits[]"];
  var selectedFruits = [];

  for (var i = 0; i < checkboxes.length; i++) {
    if (checkboxes[i].checked) {
      selectedFruits.push(checkboxes[i].value);
    }
  }

  // 将选中的复选框值传递给后端进行保存
  // 可以使用Ajax将数据发送到服务器端进行处理
}
</script>

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

function saveSelectedFruits(selectedFruits) {
  const values = selectedFruits.map(fruit => [fruit]);
  const query = 'INSERT INTO fruits (name) VALUES ?';

  connection.query(query, [values], (error, results) => {
    if (error) {
      console.error('Error saving selected fruits:', error);
    } else {
      console.log('Selected fruits saved successfully!');
    }
  });
}

// 调用保存函数并传递选中的复选框值
saveSelectedFruits(selectedFruits);