What is the best PHP class to extract recipients from CSV file?: I need to parse a .csv emails address list and send a message

When I send message it is delivered several times, Not just once. This is my script:

<?php require_once('class.PHPMailer.php'); include("class.smtp.php");

$mail = new PHPMailer();

$mail->isSMTP(); $mail->Host = "mail.gmail.com"; $mail->SMTPDebug = 1; $mail->SMTPAuth = true; $mail->SMTPSecure = "ssl"; $mail->Host = "smtp.gmail.com"; $mail->Port = 465; $mail->Username = "mymail@gmail.com"; // GMAIL username $mail->Password = "mypsswrd"; // GMAIL password

$mail->SetFrom('mymail@gmail.com', 'Just Me');

$mail->AddReplyTo("mymail@gmail.com");

$mail->Subject = "Subject";

$mail->Body = " Mail Message"; // optional, comment out and test

$row = 1; if (($handle = fopen("test.csv", "r")) !== FALSE) {

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $num = count($data);
    $row++;
  for ($c=0; $c < $num; $c++) {
        //echo $data[$c] . "<br />\n";			

$address = $data[$c]; $mail->AddAddress($address);

$mail->AddAttachment("new.txt"); if(!$mail->Send()) { echo "Mailer Error: " . $mail->ErrorInfo; } else { echo "Message sent!"; } } } } ?>

by Manuel Lemos 26695 - 10 years ago (2014-11-12) Comment

This class is also a good solution if you want to import your address from a CSV file to MySQL database, so you can query the database later to extract the recipients of your mailing.

The author has written a nice article about how to import data from CSV files.

by Oliver Leuyim Angel package author 55 - 10 years ago (2014-11-05) Comment

with this you will be able to get all the mails and verify them to send mails.

see files and there are examples