php - 使用 php 将多行插入到表中

Question

我尝试使用 php 将多行插入表中:

<?php

$host = "localhost";
$username = "mysql_username";
$password = "mysql_password";
$dbname = "employee";
$con = mysqli_connect($host, $username, $password, $dbname) or die('Error in Connecting: ' . mysqli_error($con));

$st = mysqli_prepare($con, 'INSERT INTO emp(name, gender, designation) VALUES (?, ?, ?)');
// bind variables to insert query params
mysqli_stmt_bind_param($st, 'sss', $name, $gender, $designation);

for ($x = 0; $x <= 3; $x++) {       
    $name = 'tom';
    $gender = 'male';
    $designation = 'developer';
    mysqli_execute($st);
}

//close connection
mysqli_close($con);

?>

但是我想要插入的行没有保存在数据库中。我的代码有什么错误吗？

实际上我想要来自json数组的for循环，我只是测试使用for循环来知道它是否有效。

Answer 1

我认为代码是正确的，但试试这个:

<?php
$host       = "localhost";
$username   = "mysql_username";
$password   = "mysql_password";
$dbname     = "employee";
$con = mysqli_connect($host, $username, $password, $dbname) or die('Error in Connecting: ' . mysqli_error($con));

$st = mysqli_prepare($con, 'INSERT INTO emp(name, gender, designation) VALUES (?, ?, ?)');

for ($x = 0; $x <= 3; $x++) {

    $name = 'tom';
    $gender = 'male';
    $designation = 'developer';

    // bind variables to insert query params
    mysqli_stmt_bind_param($st, 'sss', $name, $gender, $designation);
    mysqli_execute($st);
}

//close connection
mysqli_close($con);
?>

mysqli_stmt_bind_param($query, 'is',…) 表示第一个值是整数 (i)，下一个值是字符串 (s)。请随意调整以最适合您的实际数据类型。