php将JSON加载到以后插入DB的变量中

$jsonData = '{"name":"John", "age":30, "city":"New York"}';
$data = json_decode($jsonData, true);

$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

$name = $data['name'];
$age = $data['age'];
$city = $data['city'];

$sql = "INSERT INTO your_table_name (name, age, city) VALUES ('$name', $age, '$city')";
if ($conn->query($sql) === true) {
    echo "数据插入成功";
} else {
    echo "插入数据时出错: " . $conn->error;
}

$conn->close();