PHP 将生成的数组插入 MySQL 数据库

Question

这个问题已经有答案了:

Insert array into MySQL database with PHP (23 个回答)

已关闭 7 年前。

假设我生成了 5 个数组，如下所示:

$MyArr = array();
    for($i = 0; $i < 15; $i++){
        $data[] = array(
        'title'        => 'Title',
        'description'        => 'Description',
        'created_on'    => 'Time'
        );
    }

如何将生成的数组的每次迭代插入到我的 MySQL 中数据库表？

UPD。我正在使用mysqli_connect();函数连接到我的数据库(我已经按照 W3Schools 网站上的教程(程序)进行操作。

Answer 1

您可以像这样循环访问数据数组:

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$yourData = array();
for($i = 0; $i < 5; $i++){
    $yourData[] = array(
    'title'        => md5(rand()),
    'description'        => rand(0, 1)?'active':'banned',
    'created_on'    => rand(0, 1)?'now':'2014/12/31 14:51:52'
    );
}

for($j = 0; $j < count($yourData); $j++) {
    $title = $yourData[$j]["title"];
    $description = $yourData[$j]["description"];
    $created_on = $yourData[$j]["created_on"];
    $sql = "INSERT INTO yourTable (title,description,created_on) VALUES ($title, $description, $created_on)";
    if (mysqli_query($conn, $sql)) {
        echo "New record created successfully";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
    mysqli_close($conn);
}