PHP MySQL将变量赋值给数组数据

<?php
// 连接MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 定义变量
$name = "John";
$age = 25;
$email = "john@example.com";

// 创建数组并将变量赋值给数组数据
$data = array(
    'name' => $name,
    'age' => $age,
    'email' => $email
);

// 将数组数据插入到MySQL数据库中的表中
$sql = "INSERT INTO users (name, age, email) VALUES ('".$data['name']."', '".$data['age']."', '".$data['email']."')";

if ($conn->query($sql) === TRUE) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>