如提，上網查了方式有看到
使用transaction 方式做的，還有看到準備好多筆的，想請問這兩種方式有差別嗎?
想請問如果是PDO 然後寫成第一種方式，新增筆數不固定應該如何寫呢?
第一種

INSERT INTO table_name
VALUES (value1_1, value2_2, value3_3,···),
(value2_1, value2_2, value2_3,···),
(value3_1, value3_2, value3_3,···),
······;

第二種

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  // begin the transaction
  $conn->beginTransaction();
  // our SQL statements
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('John', 'Doe', 'john@example.com')");
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('Mary', 'Moe', 'mary@example.com')");
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('Julie', 'Dooley', 'julie@example.com')");

  // commit the transaction
  $conn->commit();
  echo "New records created successfully";
} catch(PDOException $e) {
  // roll back the transaction if something failed
  $conn->rollback();
  echo "Error: " . $e->getMessage();
}

$conn = null;
?>

以下是小弟的程式

try{
        $conn->beginTransaction();    
        // add_room
        
        for($i=0;$i<count($_POST['data_ar']);$i++){
            $sql_add_room = "INSERT INTO 
            `tw_room_list`(`room_name`,`monthly_rental_amount`,`security_deposit_amount`,`room_floor`) 
            VALUES 
            (:house_id,:room_name,:monthly_rental_amount,:security_deposit_amount,:room_floor)";
            $result_add_room = $conn->prepare($sql_add_room);
            $status = $result_add_room->execute(array(
                ":room_name"=>"{$_POST['data_ar'][$i]['room_name']}",
                ":monthly_rental_amount"=>"{$_POST['data_ar'][$i]['monthly_rental_amount']}",
                ":security_deposit_amount"=>"{$_POST['data_ar'][$i]['security_deposit_amount']}",
                ":room_floor"=>"{$_POST['data_ar'][$i]['room_floor']}",
            ));
        }

    if($conn->commit()){
        echo 'success';
    }
        
    }catch(PDOException $e){
        $conn->rollBack();
        echo 'error';
    }
    $conn=null;