phpmailer sending mail

Question

Hello! I am using phpmailer class to send email and i am attaching a file to the mail. The email is sent successfully but the attachment which is an sql file is empty which should not be the case. I have tried with an image file, but it seems that every file that i attach is empty. Can anyone help me solve this problem please?

$mail = new PHPMailer();
    $body = "Reminder";
    $mail->IsSMTP();  
    $mail->Host       = "mail.yourdomain.com";  
    $mail->SMTPDebug = 1;  

    $mail->SMTPAuth = true;  
    $mail->SMTPSecure = "ssl";  
    $mail->Host = "smtp.gmail.com";  
    $mail->Port = 465;  
    $mail->Username = "[email protected]";  
    $mail->Password = "abc";              
   $mail->SetFrom('[email protected]',
  'blbla');
   $mail->AddReplyTo("[email protected]","First Last");
   $mail->Subject = "Your order has been successfully placed"
   $mail->MsgHTML($body);
   $mail->AddAddress("[email protected]","xyz");
   $mail->AddAttachment("D:\b2\shop3.sql","shop3.sql");

UPDATE: I have tried to display the size of the file before attaching it, and it actually displays the file size. Can anyone help me please?

Answer 1

did you try:

D:\\b2\\shop3.sql

since is windows ?

LE: \\ - sorry

Answer 2

You could try testing the existence of the file before trying to attach it. Also, it's unknown how a \ is going to act inside of a string in PHP, so it's best practice to escape it via C standards:

$attach_filename = "D:\\b2\\shop3.sql";
if (is_file($attach_filename)) {
    $mail->AddAttachment($attach_filename,"shop3.sql");
} else {
    print "error: attachment $attach_filename doesn't exist";
}

Answer 3

I suggest you to try swiftmailer.org instead

Answer 4

A couple of suggestions for further testing:

1 - Try and attach a simple *.txt file located in the same directory as the script being executed. This will test the Attachment side of things, and may prove whether the script is either not liking attaching any files, or just the *.sql one.

2 - If #1 works OK, move the *.txt file into the same folder which the *.sql one currently resides in, then test again. This should then prove whether the script is able to access a file via the filepath you are using.

3 - Try echoing the contents of the *.sql file, either into the web-browser output generated by the script, or into the body of the email message. This should also prove whether the script is able to read the file in question.

I may be waaaay off base with these suggestions, but they would be where I would start if I were to try and troubleshoot this one.