使用Node.js和MySQL时服务器响应出现TypeError问题求助

Hey there! Let's tackle this TypeError: this._callback.apply is not a function issue you're hitting when submitting form data to MySQL. This error almost always boils down to how you're handling the database query callback in your server-side code—let's break it down step by step.

Common Causes & Fixes #

1. Invalid or Missing Callback in Your MySQL Query

This is the #1 reason for this error, especially if you're using Node.js's mysql package. The query() method expects a valid callback function as its final argument (or you can use promises/async-await instead). If you skip it entirely, or pass something that's not a function, you'll get this exact error.

Example of Wrong Code:

// ❌ Missing callback entirely
connection.query('INSERT INTO messages (name, message) VALUES (?, ?)', [name, message]);

// ❌ Passing a non-function value as callback
connection.query(sqlQuery, params, "some string instead of function");

Fixed Code with Callback:

// ✅ Proper callback function
connection.query(
  'INSERT INTO messages (name, message) VALUES (?, ?)',
  [req.body.name, req.body.message], // Make sure these values are correctly pulled from the form
  function(err, results) {
    if (err) {
      console.error(err);
      return res.status(500).send('Failed to save data');
    }
    console.log('Data saved successfully!');
    res.redirect('/'); // Redirect back to your form page
  }
);

Alternative: Use Async/Await (Cleaner for Modern Code)
If you prefer promises over callbacks, use mysql2/promise (a promise-based version of the mysql library):

const mysql = require('mysql2/promise');

async function handleFormSubmit(req, res) {
  // Create a connection (or use a connection pool for better performance)
  const connection = await mysql.createConnection({
    host: 'your-host',
    user: 'your-db-user',
    password: 'your-db-password',
    database: 'your-db-name'
  });

  try {
    await connection.execute(
      'INSERT INTO messages (name, message) VALUES (?, ?)',
      [req.body.name, req.body.message]
    );
    res.redirect('/');
  } catch (err) {
    console.error('Database error:', err);
    res.status(500).send('Failed to submit your data');
  } finally {
    await connection.end();
  }
}

2. Missing Body-Parsing Middleware (If Using Express)

If you're using Express to handle the form submission, you need to add middleware to parse the form data. Without this, req.body will be undefined, which can lead to invalid query parameters and trigger unexpected errors (including callback-related ones).

Add This to Your Express Setup:

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

// Parse URL-encoded form data (required for POST requests from HTML forms)
app.use(express.urlencoded({ extended: true }));

3. Double-Check Your SQL Syntax

While the error points to callbacks, invalid SQL can sometimes cause unexpected query behavior that manifests as a callback error. Quick checks:

• Make sure your table name (messages?) and column names (name, message?) match exactly what's in your MySQL database.
• Test your SQL query directly in a MySQL client (like phpMyAdmin or the MySQL CLI) to confirm it works before using it in code.

Final Tip #

If you're still stuck, share your full server-side route code (the part that handles the POST request from your form) and your database table schema—this will help pinpoint the exact issue faster!

内容的提问来源于stack exchange，提问作者user8991131