php mysql插入多个列_如何在PHP中执行多个MySQL插入

我需要在MySQL表中插入许多行(150到300之间),我想知道以下方法在性能方面更好：

方法1：

foreach( $persons as $person ){

$stmt = $dbLink->prepare( "INSERT INTO table SET id = :ID,

name = :name,

email = :email,

mobile = :mobile");

$stmt->execute( array( ':ID'=>$person->getID(),

':name'=>$person->getName(),

':email'=>$person->getEmail(),

':mobile'=>$person->getMobile(),

) );

}

方法2：

$stmt = $dbLink->prepare( "INSERT INTO table SET id = :ID,

name = :name,

email = :email,

mobile = :mobile");

$stmt->bindParam( ':ID', $person->getID(), PDO::PARAM_STR );

$stmt->bindParam( ':name', $person->getName(), PDO::PARAM_STR );

$stmt->bindParam( ':email', $person->getEmail(), PDO::PARAM_STR );

$stmt->bindParam( ':mobile', $person->getMobile(), PDO::PARAM_STR );

foreach( $persons as $person ){

$stmt->execute();

}