Insert in Database and Email attachement

[madness69]

hello? I hope to get some help, I have a script of job applications, basically what it does is when a user is going to apply for a job, the user information (name, email, message, cv) are sent to the database and the CV is saved in a folder on the server.The company that created the job opening receives an email with the details of the candidate that was filled in the form. The script works fine, but I have only one problem, I need to get in the email the CV attached  but i dont no how  to do. Could someone see the code and tell me what is missing in add code and how to fill the rest?

Here is the code above

if(isset($_FILES['files'])){


    $errors= array();
	foreach($_FILES['files']['tmp_name'] as $key => $tmp_name ){
		$file_name = $key.$_FILES['files']['name'][$key];
		$file_size =$_FILES['files']['size'][$key];
		$file_tmp =$_FILES['files']['tmp_name'][$key];
		$file_type=$_FILES['files']['type'][$key];	
		
		
		
		$random_digit=rand(0000,9999);
		
		$new_file_name=$random_digit.$file_name;
		
        if($file_size > 2097152){
			$errors[]='File size must be less than 2 MB';
        }		
		
		
		
		
		$query2="INSERT into candidates (`firstname`,`lastname`,`mobile`,`email`,`message`,`id_company`,`titulo_anuncio`,`job_type`,`data`,ativo) VALUES('$firstname','$lastname','$mobile','$email_candidate','$message','$id_company','$title_en','$job_type','$data','1'); ";
		mysql_query($query2);
		$user_id = mysql_insert_id();
		
        $query="INSERT into imagens (`id_candidate`,`file`,`size`,`type`) VALUES('$user_id','$new_file_name','$file_size','$file_type'); ";
		$to = $email;
		$subject = " Job Portal - New Candidate";
		
		$body = "";
		$body .= "Title: ";
		$body .= $title_en;
		$body .= "\n";
		$body .= "Tel: ";
		$body .= $mobile;
		$body .= "\n";
		$body .= "Email: ";
		$body .= $email_candidate;
		$body .= "\n";
		$body .= "Message: ";
		$body .= $message;
		$body .= "\n";
		$body .= "CV: ";
		$body .= "In attachement";
		$body .= "\n";
		
		
		
		$headers = "From:" . $to;
		 if (mail($to, $subject, $body,$headers))
		
	 
        $desired_dir="candidatos_cv";
        if(empty($errors)==true){
            if(is_dir($desired_dir)==false){
                mkdir("$desired_dir", 0700);		
            }
            if(is_dir("$desired_dir/".$new_file_name)==false){
                move_uploaded_file($file_tmp,"$desired_dir/".$new_file_name);
            }else{									// rename the file if another one exist
                $new_dir="$desired_dir/".$new_file_name.time();
                 rename($file_tmp,$new_dir) ;				
            }
		
		 mysql_query($query);			
        }else{
                print_r($errors);
        }
    }
	if(empty($error)){
		echo "<span style=\"color:green;font-weight:bold;\">Job applied whit Sucess</span>";

	}
}

[scootstah]

You basically have to set a bunch of mail headers. Did you Google this? There's tons of tutorials and information about it.

 

Regardless, I recommend you use a library such as PHPMailer or SwiftMailer. They can both easily send email attachments.