使用express mysql对现有的wp帐户进行身份验证登录

npm install express mysql

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

const pool = mysql.createPool({
  host: 'localhost',
  user: 'your_mysql_username',
  password: 'your_mysql_password',
  database: 'your_database_name'
});

const app = express();

app.use(express.json());
app.use(express.urlencoded({ extended: false }));

app.post('/login', (req, res) => {
  const { username, password } = req.body;

  // 查询数据库中是否存在匹配的用户名和密码
  const query = `SELECT * FROM wp_accounts WHERE username = ? AND password = ?`;
  pool.query(query, [username, password], (error, results) => {
    if (error) {
      console.error('Error executing query:', error);
      res.status(500).json({ error: 'Internal server error' });
    } else {
      if (results.length > 0) {
        res.json({ message: 'Login successful' });
      } else {
        res.status(401).json({ error: 'Invalid credentials' });
      }
    }
  });
});

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

node app.js