过滤while循环创建的PHP表

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// 创建表格
$sql = "CREATE TABLE users (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30) NOT NULL,
    email VARCHAR(50) NOT NULL
)";
$conn->query($sql);

// 过滤并插入数据
$data = array(
    array("John Doe", "john@example.com"),
    array("Jane Smith", "jane@example.com"),
    array("Bob Johnson", "bob@example.com")
);

foreach ($data as $row) {
    $name = $conn->real_escape_string($row[0]);
    $email = $conn->real_escape_string($row[1]);

    // 过滤数据
    $name = filter_var($name, FILTER_SANITIZE_STRING);
    $email = filter_var($email, FILTER_SANITIZE_EMAIL);

    // 插入数据
    $sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
    $conn->query($sql);
}

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