如何使用PHP将数据数组插入MySQL

我会避免对每个条目进行查询。

if(is_array($EMailArr)){    $sql = "INSERT INTO email_list (R_ID, EMAIL, NAME) values ";    $valuesArr = array();    foreach($EMailArr as $row){        $R_ID = (int) $row['R_ID'];        $email = mysql_real_escape_string( $row['email'] );        $name = mysql_real_escape_string( $row['name'] );        $valuesArr[] = "('$R_ID', '$email', '$name')";    }    $sql .= implode(',', $valuesArr);    mysql_query($sql) or exit(mysql_error()); }