将数据发送到php以返回数据库中的数据

fetch('your-php-script.php', {
    method: 'POST',
    headers: {
        'Content-Type': 'application/json',
    },
    body: JSON.stringify({ key: 'value' })
})
.then(response => response.json())
.then(data => console.log(data))
.catch((error) => console.error('Error:', error));

<?php
header('Content-Type: application/json');

// 获取POST数据
$data = json_decode(file_get_contents('php://input'), true);

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die(json_encode(["error" => "Connection failed: " . $conn->connect_error]));
}

// 准备SQL语句
$sql = "SELECT * FROM your_table WHERE column = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $data['key']);
$stmt->execute();

$result = $stmt->get_result();
$output = $result->fetch_all(MYSQLI_ASSOC);

echo json_encode($output);

$stmt->close();
$conn->close();
?>