使用PHP foreach()循环将数据输入MySQL表时的空字符串

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

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

// 要插入的数据数组
$data = array(
    array("John", "Doe", "john@example.com"),
    array("Jane", "", "jane@example.com"),
    array("Mike", "Smith", "")
);

// 遍历数据数组
foreach ($data as $row) {
    // 检查每个数据项是否为空字符串
    $firstName = ($row[0] == "") ? NULL : $row[0];
    $lastName = ($row[1] == "") ? NULL : $row[1];
    $email = ($row[2] == "") ? NULL : $row[2];

    // 使用预处理语句插入数据
    $stmt = $conn->prepare("INSERT INTO your_table (first_name, last_name, email) VALUES (?, ?, ?)");
    $stmt->bind_param("sss", $firstName, $lastName, $email);
    $stmt->execute();
}

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