如何在实现插入数据库后获取查询的多行 - How to get multi rows of a query after implementing insert into database?

How to get multi rows of a query after implementing insert into database?

实现后可以从查询中获取多行吗？在PHP中LAST_INSERT_ID()功能只能从数据库中获取最后一行，并且无法获取多行。如果我有查询，例如

$sql = "insert into my_table(ID,Column1,Column2) values 
(1,"temp1","temp2"),
(2,"temp3","temp4"),
(3,"temp5","temp6")"
    mysql_query($sql);......

我想将此查询的所有 ID 放入数组$data = (1,2,3)中。如何实现？

您可以使用 for 循环并将最后一个插入 id 存储到数组中。循环完成后，您可以提取插入ID的希望示例，下面的帮助

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 
    for ($x = 0; $x <= 10; $x++) {
           $sql = "insert into my_table(ID,Column1,Column2) values  
                 ($x,"temp".$x,"temp".$x)";
           $conn->query($sql);
           $last_id[] = $conn->insert_id;
     } 
    print_r($last_id);
      $conn->close();