如何使用PHP从csv文件中提取所有电子邮件


How can I extract all emails from csv file using PHP?

我需要给我的客户发邮件,为此我有一个csv文件,其中包含客户数据,包括csv文件中的电子邮件。

我如何使用PHP读取所有电子邮件地址,将它们放入数组,或将它们插入文本文件(只是我可以使用的格式)

CSV如下所示:(示例记录)

"Date","Ref #","Time","Customer","Country","Email","Product","Product ID","Contract","Contract ID","Payment Type","Frequency","Referrer","Qty","Sale type","Adds","Total","Price","Plimus Commission","Affiliate Commssion (%)","Affiliate Commssion ($)","Tracking Id","CUSTOM1","CUSTOM2","CUSTOM3","CUSTOM4","CUSTOM5","Subscription ID","Target Balance","PayPal Comm.(main contracts)","PayPal Transaction ID","Original PayPal Transaction ID","PayPal email address"
"06/06/2008","19796287","04:06:29"," Mehmet Özekinci","Turkey","mhmtozek@gmail.com","Website Templates Pack","190830","xxxxxxxxxxx","1941602","PAYPAL","Once","xxxxxxxxxxxx","1","CHARGE","0","25","25","0","n/a","n/a"," "," "," "," "," "," "," ","xxxxx Account"," "," "," ","k_anafor56@hotmail.com"

该文件包含3000多条记录(CSV文件)。如何查找/获取所有电子邮件..@。。在PHP中?

感谢

只需在CSV中循环并获取适当的字段。您使用fgetcsv()来执行以下操作:

$emails = array();
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $emails[] = $data[5];
}