PHP - Phpmailer Attachment Help

Hello,

I am a PHP beginner and I  made a PHP page which inserts data into a MYSql database.

....
$InsertQuery->Action = "insert";
  $InsertQuery->Table = "klanten";
  $InsertQuery->bindColumn("Klantnummer", "s", "".strtoupper(((isset($_POST["Klantnummer"]))?$_POST["Klantnummer"]:""))  ."", "WA_DEFAULT");
  $InsertQuery->bindColumn("Naam_organisatie", "s", "".strtoupper(((isset($_POST["Naam_organisatie"]))?$_POST["Naam_organisatie"]:""))  ."", "WA_DEFAULT");
  $InsertQuery->bindColumn("Adres_organisatie", "s", "".strtoupper(((isset($_POST["Adres_organisatie"]))?$_POST["Adres_organisatie"]:""))  ."", "WA_DEFAULT");
  $InsertQuery->bindColumn("Postcode_organisatie", "s", "".strtoupper(((isset($_POST["Postcode_organisatie"]))?$_POST["Postcode_organisatie"]:""))  ."", "WA_DEFAULT");
  $InsertQuery->bindColumn("Woonplaats_organisatie", "s", "".strtoupper(((isset($_POST["Woonplaats_organisatie"]))?$_POST["Woonplaats_organisatie"]:""))  ."", "WA_DEFAULT");
  $InsertQuery->bindColumn("BTW_plichtig", "s", "".strtoupper(((isset($_POST["BTW_plichtig"]))?$_POST["BTW_plichtig"]:""))  ."", "WA_DEFAULT");
  $InsertQuery->bindColumn("Email", "s", "".strtoupper(((isset($_POST["Email"]))?$_POST["Email"]:""))  ."", "WA_DEFAULT");
...

After the insert, I want to send all the data with a mail to a recepient. But I can't find a way to code the "setForm" correctly with the inserted field "Email".

<?php
error_reporting(E_ALL);

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\src\Exception;

require 'PHPMailer\PHPMailer\src\Exception.php';
require 'PHPMailer\PHPMailer\src\PHPMailer.php';
require 'PHPMailer\PHPMailer\src\SMTP.php';
	
$mail = new PHPMailer();
$mail->IsSMTP(); 
$mail->Host = "smtp.myhosting.be"; 
$mail->SMTPAuth = true; 
$mail->Username = 'username@domain.com';
$mail->Password = 'password'; 
$mail->setFrom = $_POST('Email');                  // doesn't work
$mail->AddAddress('recipient@domain.com');
$mail->Subject = "subject";
$mail->Body = "text";   // in the body I want an overview of all the inserted data
$mail->IsHTML(true); 
if(!$mail->Send()) 
{ 
echo "Error sending: " . $mail->ErrorInfo;; 
} 
$mail->ClearAddresses();
$mail->ClearAttachments();
?>	

How can I do that?
Thank you in advance for your comments.

I am trying to get phpmailer working but not having much luck with it. I am not receiving the email

Below is the code I have

<?php
//index.php

$error = '';
$quantity1 = '';
$totalprice1 = '';

$subtotal = '';
$postage = '';
$grandtotal = '';

$name = '';
$addressline1 = '';
$postcode = '';
$email = '';

function clean_text($string)
{
 $string = trim($string);
 $string = stripslashes($string);
 $string = htmlspecialchars($string);
 return $string;
}

if(isset($_POST["submit"]))
{
if(empty($_POST["quantity1"]))
 {
  $error .= '<p><label class="text-danger">Please enter the quantity required</label></p>';
 }
    
if(empty($_POST["totalprice1"]))
 {
  $error .= '<p><label class="text-danger">Please enter the total price required</label></p>';
 }
    
if(empty($_POST["subtotal"]))
 {
  $error .= '<p><label class="text-danger">Please enter the subtotal</label></p>';
 }
    
if(empty($_POST["postage"]))
 {
  $error .= '<p><label class="text-danger">Please enter the postage</label></p>';
 }
    
if(empty($_POST["grandtotal"]))
 {
  $error .= '<p><label class="text-danger">Please enter the grand total</label></p>';
 }
    
 if(empty($_POST["name"]))
 {
  $error .= '<p><label class="text-danger">Please Enter your name</label></p>';
 }
 else
 {
  $name = clean_text($_POST["name"]);
  if(!preg_match("/^[a-zA-Z ]*$/",$name))
  {
   $error .= '<p><label class="text-danger">Only letters and white space allowed</label></p>';
  }
 }
    
if(empty($_POST["addressline1"]))
 {
  $error .= '<p><label class="text-danger">Please enter your address line 1</label></p>';
 }
    
if(empty($_POST["postcode"]))
 {
  $error .= '<p><label class="text-danger">Please enter your postcode</label></p>';
 }
    
 if(empty($_POST["email"]))
 {
  $error .= '<p><label class="text-danger">Please Enter your Email</label></p>';
 }
 else
 {
  $email = clean_text($_POST["email"]);
  if(!filter_var($email, FILTER_VALIDATE_EMAIL))
  {
   $error .= '<p><label class="text-danger">Invalid email format</label></p>';
  }
 }
 if($error == '')
 {
  require 'phpmailer/class.phpmailer.php';
  $mail = new PHPMailer(true);
  $mail->SMTPDebug = 1; // to see exactly what's the issue
  $mail->IsSMTP();        //Sets Mailer to send message using SMTP
  $mail->Host = 'hostname';  //Sets the SMTP hosts
  $mail->Port = '587';        //Sets the default SMTP server port
  $mail->SMTPAuth = true;       //Sets SMTP authentication. Utilizes the Username and Password variables
  $mail->Username = 'emailaddress';     //Sets SMTP username
  $mail->Password = 'emailaddresspassword';     //Sets SMTP password
  $mail->SMTPSecure = '';       //Sets connection prefix. Options are "", "ssl" or "tls"
  $mail->From = $_POST["email"];     //Sets the From email address for the message
  $mail->FromName = $_POST["name"];    //Sets the From name of the message
  $mail->AddAddress('emailaddress', 'Name');//Adds a "To" address
  $mail->AddCC($_POST["email"], $_POST["name"]); //Adds a "Cc" address
  $mail->WordWrap = 50;       //Sets word wrapping on the body of the message to a given number of characters
  $mail->IsHTML(true);       //Sets message type to HTML    
  $mail->Subject = "Online Badge Order";    //Sets the Subject of the message
     
  $mail->Body = "The order information is below" . "<br><br>" . "Club One: " . $_POST["club1"] . "<br>" . "Country One: " . $_POST["country1"] . "<br>" . "Ref No: " . $_POST["refno1"] . "<br>" . "Quantity: " . "<br>" . $_POST["quantity1"] . "<br>" . "Total Price Line: " . "\243" . $_POST["totalprice1"] . "<br><br>" . "Club Two: " . $_POST["club2"] . "<br>" . "Country Two: " . $_POST["country2"] . "<br>" . "Ref No: " . $_POST["refno2"] . "<br>" . "Quantity: " . $_POST["quantity2"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice2"] . "<br><br>" . "Club Three: " . $_POST["club3"] . "<br>" . "Country Three: " . $_POST["country3"] . "<br>" . "Ref No: " . $_POST["refno3"] . "<br>" . "Quantity: " . $_POST["quantity3"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice3"] . "<br><br>" . "Club Four: " . $_POST["club4"] . "<br>" . "Country Four: " . $_POST["country4"] . "<br>" . "Ref No: " . $_POST["refno4"] . "<br>" . "Quantity: " . $_POST["quantity4"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice4"] . "<br><br>" . "Club Five: " . $_POST["club5"] . "<br>" . "Country Five: " . $_POST["country5"] . "<br>" . "Ref No: " . $_POST["refno5"] . "<br>" . "Quantity: " . $_POST["quantity5"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice5"] . "<br><br>" . "Club Six: " . $_POST["club6"] . "<br>" . "Country Six: " . $_POST["country6"] . "<br>" . "Ref No: " . $_POST["refno6"] . "<br>" . "Quantity: " . $_POST["quantity6"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice6"] . "<br><br>" . "Club Seven: " . $_POST["club7"] . "<br>" . "Country Seven: " . $_POST["country7"] . "<br>" . "Ref No: " . $_POST["refno7"] . "<br>" . "Quantity: " . $_POST["quantity7"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice7"] . "<br><br>" . "Club Eight: " . $_POST["club8"] . "<br>" . "Country Eight: " . $_POST["country8"] . "<br>" . "Ref No: " . $_POST["refno8"] . "<br>" . "Quantity: " . $_POST["quantity8"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice8"] . "<br><br>" . "Club Nine: " . $_POST["club9"] . "<br>" . "Country Nine: " . $_POST["country9"] . "<br>" . "Ref No: " . $_POST["refno9"] . "<br>" . "Quantity: " . $_POST["quantity9"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice9"] . "<br><br>" . "Club Ten: " . $_POST["club10"] . "<br>" . "Country Ten: " . $_POST["country10"] . "<br>" . "Ref No: " . $_POST["refno10"] . "<br>" . "Quantity: " . $_POST["quantity10"] . "<br>" . "Total Price Line: " . "\243".$_POST["totalprice10"];    //An HTML or plain text message body
     
  if($mail->Send())        //Send an Email. Return true on success or false on error
  {
   header('Location:thank-you.html');
  }
  else
  {
   $error = '<label class="text-danger">There is an Error</label>';
  }
     
$quantity1 = '';
$totalprice1 = '';

$subtotal = '';
$postage = '';
$grandtotal = '';

$name = '';
$addressline1 = '';
$postcode = '';
$email = '';
 }
}

?>

Here is the code I have to process a contact form:

<?php
  // DEFINE VARIABLE AND SET EMPTY VALUES
  $varfnameErr = $varlnameErr = $varemailErr = $varphoneErr = $varmessageErr = "";
  $varfname = $varlname = $varemail = $varphone = $varmessage = $varipaddress = $formerror = $success = "";
  
  $varfnameErr = $_REQUEST['varfnameErr'] ;
  $varlnameErr = $_REQUEST['varlnameErr'] ;
  $varemailErr = $_REQUEST['varemailErr'] ;
  $varphoneErr = $_REQUEST['varphoneErr'] ;
  $varmessageErr = $_REQUEST['varmessageErr'] ;
  
  $varfname = $_REQUEST['varfname'] ;
  $varlname = $_REQUEST['varlname'] ;
  $varemail = $_REQUEST['varemail'] ;
  $varphone = $_REQUEST['varphone'] ;
  $varmessage = $_REQUEST['varmessage'] ;
  $varipaddress = $_REQUEST['varipaddress'] ;

  $message = '<html><body>';
  $message .= '<p>Form submitted by: ' .$varfname. ' ' .$varlname. '</p>';
  $message .= '<p>Email: ' .$varemail. '</p>';
  $message .= '<p>Phone Number: ' .$varphone. '</p>';
  $message .= '<p>Message: ' .$varmessage. '</p>';
  $message .= '<p>IP Address: ' .$varipaddress. '</p>';
  $message .= '</body></html>';

  use PHPMailer\PHPMailer\PHPMailer;
  use PHPMailer\PHPMailer\Exception;
  
  require $_SERVER['DOCUMENT_ROOT'] . '/mail/Exception.php';
  require $_SERVER['DOCUMENT_ROOT'] . '/mail/PHPMailer.php';
  require $_SERVER['DOCUMENT_ROOT'] . '/mail/SMTP.php';
  
  $mail = new PHPMailer;
  $mail->isSMTP(); 
  $mail->SMTPDebug = 2; // 0 = off (for production use) - 1 = client messages - 2 = client and server messages
  $mail->Host = "HostIsBlueHost"; // use $mail->Host = gethostbyname('smtp.gmail.com'); // if your network does not support SMTP over IPv6
  $mail->Port = 21; // TLS only
  $mail->SMTPSecure = 'tls'; // ssl is deprecated
  $mail->SMTPAuth = true;
  $mail->Username = 'info@aacroofing.org'; // email
  $mail->Password = 'PasswordWasHere'; // password
  $mail->setFrom($varemail); // From email and name
  $mail->addAddress('test@gmail.com'); // to email and name

  $mail->Subject = 'Contact Us Form Submission';
  $mail->msgHTML($message); //$mail->msgHTML(file_get_contents('contents.html'), __DIR__); //Read an HTML message body from an external file, convert referenced images to embedded,
  $mail->AltBody = 'HTML messaging not supported'; // If html emails is not supported by the receiver, show this body
  //$mail->addAttachment('images/phpmailer_mini.png'); //Attach an image file
  $mail->SMTPOptions = array(
    'ssl' => array(
    'verify_peer' => false,
    'verify_peer_name' => false,
    'allow_self_signed' => true
    )
  );
  
  if(!$mail->send()){
    echo "Mailer Error: " . $mail->ErrorInfo;
  }else{
    $success = "<p class='success'>Message sent! Thank you!</br>IP Address: " .$varipaddress. " recorded</p>";
    $varfname = $varlname = $varemail = $varphone = $varmessage = "";
  }
?>

When the form is completed and submitted this is the error that I get.  I have no idea what this means.  If someone understands the error, could you please give me a clue?

2020-03-08 19:48:46 SERVER -> CLIENT: 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------220-You are user number 1 of 150 allowed.220-Local time is now 13:48. Server port: 21.220-IPv6 connections are also welcome on this server.220 You will be disconnected after 15 minutes of inactivity.
2020-03-08 19:48:46 CLIENT -> SERVER: EHLO aacroofing.org
2020-03-08 19:48:46 SERVER -> CLIENT: 530 You aren't logged in
2020-03-08 19:48:46 SMTP ERROR: EHLO command failed: 530 You aren't logged in
2020-03-08 19:48:46 CLIENT -> SERVER: HELO aacroofing.org
2020-03-08 19:48:46 SERVER -> CLIENT: 530 You aren't logged in
2020-03-08 19:48:46 SMTP ERROR: HELO command failed: 530 You aren't logged in
2020-03-08 19:48:46 CLIENT -> SERVER: STARTTLS
2020-03-08 19:48:46 SERVER -> CLIENT: 530 You aren't logged in
2020-03-08 19:48:46 SMTP ERROR: STARTTLS command failed: 530 You aren't logged in
SMTP Error: Could not connect to SMTP host.
2020-03-08 19:48:46 CLIENT -> SERVER: QUIT
2020-03-08 19:48:46 SERVER -> CLIENT: 221-Goodbye. You uploaded 0 and downloaded 0 kbytes.221 Logout.
SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
Mailer Error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting

$mail = new PHPMailer(true);
$mail->IsSMTP();
//setup from, replyto etc here...

//email query here to get emails in array $bccz..

//chunk results
$newArray = array_chunk($bccz, 50, false);

// Now process array_chunk()
$i = 0;
foreach ($newArray as $inner_array) {
    $i++;
        while (list($key, $value) = each($inner_array)) {
                     addBCC($value['email']);

}$subject = '=?UTF-8?B?'.base64_encode($cobig).'?=';
$mail->Subject = $subject;
$mail->IsHTML(true);

$mail->Body = $ermail;
$mail->Send();
}
$mail->clearBcc();
}

How do I only allow jpg and png file extensions to be uploaded as a attachment. My current code is below

 

$msg = '';
if (array_key_exists('userfile', $_FILES)) {

// create object of PHPMailer class with boolean parameter which sets/unsets exception.
$mail = new PHPMailer(true);
try {
    
    //$mail->isSMTP(); // using SMTP protocol
    $mail->Host = 'host'; // SMTP host as gmail 
    $mail->SMTPAuth = true;  // enable smtp authentication
    $mail->Username = 'emailaddress';  // sender gmail host              
    $mail->Password = 'emailpassword'; // sender gmail host password                          
    $mail->SMTPSecure = 'ssl';  // for encrypted connection                           
    $mail->Port = 587;   // port for SMTP     

    $mail->setFrom('emailaddress', "Name"); // sender's email and name
    $mail->addAddress('emailaddress', "Name");  // receiver's email and name
    
    $attachmentNames = [];
    
    //Attach multiple files one by one
    for ($ct = 0; $ct < count($_FILES['userfile']['tmp_name']); $ct++) {
        $uploadfile = tempnam(sys_get_temp_dir(), hash('sha256', $_FILES['userfile']['name'][$ct]));
        $filename = $_FILES['userfile']['name'][$ct];
        if (move_uploaded_file($_FILES['userfile']['tmp_name'][$ct], $uploadfile)) {
            if(isset($uploadfile))
            $mail->addAttachment($uploadfile, $filename);
            $attachmentNames[] = $_FILES['userfile']['name'][$ct];
        } else {
            $msg .= 'Failed to move file to ' . $uploadfile;
        }
    }

I am still fairly new to using phpmailer and it works but I have been asked to google recaptcha v2 checkbox into their contact form but unsure how to do that within the phpmailer code, below is what I currently have

 

<?php

// PHPMailer classes into the global namespace
use PHPMailer\PHPMailer\PHPMailer; 
use PHPMailer\PHPMailer\Exception;
// Base files 
require 'PHPMailer/src/Exception.php';
require 'PHPMailer/src/PHPMailer.php';
require 'PHPMailer/src/SMTP.php';

// create object of PHPMailer class with boolean parameter which sets/unsets exception.
$mail = new PHPMailer(true);
try {
    //$mail->isSMTP(); // using SMTP protocol
    $mail->Host = 'hostname'; // SMTP host as gmail 
    $mail->SMTPAuth = true;  // enable smtp authentication
    $mail->Username = 'emailaddress';  // sender gmail host              
    $mail->Password = 'emailpassword'; // sender gmail host password                          
    $mail->SMTPSecure = 'ssl';  // for encrypted connection                           
    $mail->Port = 587;   // port for SMTP     

    $mail->setFrom('emailaddress', "Business Name"); // sender's email and name
    $mail->addAddress('emailaddress', "Business Name");  // receiver's email and name

    $mail->Subject = 'New Website Enquiry';
    $mail->Body    = "A new website enquiry has been made. The enquiry information is below" . "\r\n\r\n" . "Name: " . $_POST["name"] . "\r\n" . "Email: " . $_POST["email"] . "\r\n" . "Subject: " . $_POST["subjectline"] . "\r\n" . "Message: " . $_POST["message"];
    
    $mail->send();
    header('Location:enquiry-confirmation.php');
    } catch (Exception $e) { // handle error.
    echo 'Message could not be sent. Mailer Error: ', $mail->ErrorInfo;
    }
?>

Can anyone help please as to where the code needs to go to check if the checkbox has been checked or not

So I am trying to use PHP mailer on my site however it doesn't post to the email

Here is the code:

Top:

   <?php 

    use PHPMailer\PHPMailer\PHPMailer;
    use PHPMailer\PHPMailer\Exception;

    require 'vendor/phpmailer/phpmailer/src/Exception.php';
    require 'vendor/phpmailer/phpmailer/src/PHPMailer.php';
    require 'vendor/phpmailer/phpmailer/src/SMTP.php';
   ?>

Where it sends:

            require 'vendor/autoload.php';

            //Instantiation and passing `true` enables exceptions
            $mail = new PHPMailer(true);
            
            try {
                //Server settings
                $mail->SMTPDebug = SMTP::DEBUG_SERVER;                      //Enable verbose debug output
                $mail->isSMTP();                                            //Send using SMTP
                $mail->Host       = 'smtp.office365.com';                     //Set the SMTP server to send through
                $mail->SMTPAuth   = true;                                   //Enable SMTP authentication
                $mail->Username   = 'maileremail';                     //SMTP username
                $mail->Password   = 'mailerpassword';                               //SMTP password
                $mail->SMTPSecure = PHPMailer::ENCRYPTION_STARTTLS;         //Enable TLS encryption; `PHPMailer::ENCRYPTION_SMTPS` encouraged
                $mail->Port       = 587;                                    //TCP port to connect to, use 465 for `PHPMailer::ENCRYPTION_SMTPS` above
            
                //Recipients
                $mail->setFrom('maileremail', 'Mailer');
                $mail->addAddress(myemail', 'Joe User');     //Add a recipient
            
                //Content
                $mail->isHTML(true);                                  //Set email format to HTML
                $mail->Subject = 'Here is the subject';
                $mail->Body    = 'This is the HTML message body <b>in bold!</b>';
                $mail->AltBody = 'This is the body in plain text for non-HTML mail clients';
            
                $mail->send();
                echo 'Message has been sent';
            } catch (Exception $e) {
                echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
            }
                  ?>

I have tried everything but it still won't post.