PHP Form - Emails data as attachments

PleXy · January 8, 2013, 1:21pm

Hey guys!

I’m currently using a form which sends a HTML email to the recipient - very basic.
The recipient now asked me if we can also send it as an Excel sheet attached in the E-mail.

I’ve tried implementing both PHPExcel and Spreadsheet_Excel_Writer but I just can’t get it to work, which is really frustrating.

Anyone who could give me a helping hand?

Here’s my code.

Thank you so much in advance!!

kontoansokan.php
[php]<?php
require(‘client.inc.php’);

require(CLIENTINC_DIR.‘header.inc.php’);
?>

Kontoansökan

<tr>

Datum/tid	<? date_default_timezone_set('Europe/Stockholm'); ?> kl.<?php echo date("H:i") . ""?>">
Handläggare *

Företagsuppgifter
Organisationsnr
Företagsnamn
Tillhör koncern/kommun
Telefonnummer
Fax

Kontaktperson
Namn
Mailadress

Faktureringsadress
Företagsnamn/enhet
Postadress
Postnummer
Ort

Leveransadress
Företagsnamn/enhet
Gatuadress
Postnummer
Ort
Eventuell kommentar till kundregistret
Inloggning till Netshop	Ja Nej

<?require(CLIENTINC_DIR.'footer.inc.php'); ?>[/php]

kontoansokan_skicka.php
[php]<?php
if(isset($_POST[‘email’])) {

// EDIT THE 2 LINES BELOW AS REQUIRED
$email_to = "[email protected]";
$mailkopia = "[email protected]";
$email_from = "[email protected]";
$email_subject = "Email Subject";
 
 
function died($error) {
    // your error code can go here
    echo "We are very sorry, but there were error(s) found with the form you submitted. ";
    echo "These errors appear below.<br /><br />";
    echo $error."<br /><br />";
    echo "Please go back and fix these errors.<br /><br />";
    die();
}
 
// validation expected data exists

// if(!isset($_POST[‘first_name’])) {
// died(‘We are sorry, but there appears to be a problem with the form you submitted.’);
// }

$first_name = $_POST['first_name']; // required
$datum = $_POST['datum'];
$orgnr = $_POST['orgnr'];
$foretagsnamn = $_POST['foretagsnamn'];
$koncern = $_POST['koncern'];
$telephone = $_POST['telephone'];
$fax = $_POST['fax'];
$kundnamn = $_POST['kundnamn'];
$email = $_POST['email'];
$fakt_foretag1 = $_POST['fakt_foretag1'];
$fakt_foretag2 = $_POST['fakt_foretag2'];
$fakt_foretag3 = $_POST['fakt_foretag3'];
$fakt_postadr = $_POST['fakt_postadr'];
$fakt_postnr = $_POST['fakt_postnr'];
$fakt_ort = $_POST['fakt_ort'];
$lev_foretag1 = $_POST['lev_foretag1'];
$lev_foretag2 = $_POST['lev_foretag2'];
$lev_foretag3 = $_POST['lev_foretag3'];
$lev_gatuadr = $_POST['lev_gatuadr'];
$lev_postnr = $_POST['lev_postnr'];
$lev_ort = $_POST['lev_ort'];
$comments = $_POST['comments'];
$inlogg = $_POST['inlogg'];

 
$error_message = "";

// $string_exp = “/^[A-Za-z .’-]+$/”;
// if(!preg_match($string_exp,$first_name)) {
// $error_message .= ‘The First Name you entered does not appear to be valid.
’;
// }

if(strlen($error_message) > 0) {
died($error_message);
}
$email_message = “”;

function clean_string($string) {
  $bad = array("content-type","bcc:","to:","cc:","href");
  return str_replace($bad,"",$string);
}

$email_message .= "<img src='http://webbhjalpen.com/kund/frontline/images/frontline.png'><br><br>";
$email_message .= "<font face='Calibri'>Hej!<br>Ni har fått en kontoansökan från kundtjänst.<br>Se nedan uppgifter.<br><br></td></tr>";
$email_message .= "<table>";
$email_message .= "<tr><td width='200'><font face='Calibri'>Handläggare:</td><td><font face='Calibri'>".clean_string($first_name)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Datum/tid:</td><td><font face='Calibri'>".clean_string($datum)."</td></tr>";

$email_message .= “

”;
$email_message .= “ Företagsuppgifter ”;
$email_message .= “ Organisationsnr: ”.clean_string($orgnr)." ";
$email_message .= “ Företagsnamn: ”.clean_string($foretagsnamn)." ";
$email_message .= “ Tillhör koncern/kommun: ”.clean_string($koncern)." ";
$email_message .= “ Telefonnummer: ”.clean_string($telephone)." ";
$email_message .= “ Fax: ”.clean_string($fax)." ";

$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";

$email_message .= "<tr><td><font face='Calibri'><b>Kontaktperson</td><td></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Namn:</td><td><font face='Calibri'>".clean_string($kundnamn)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Mailadress:</td><td><font face='Calibri'>".clean_string($email)."</td></tr>";

$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";

$email_message .= "<tr><td><font face='Calibri'><b>Faktureringsadress</td><td></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Företagsnamn/enhet:</td><td><font face='Calibri'>".clean_string($fakt_foretag1)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 2:</td><td><font face='Calibri'>".clean_string($fakt_foretag2)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 3:</td><td><font face='Calibri'>".clean_string($fakt_foretag3)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Postadress:</td><td><font face='Calibri'>".clean_string($fakt_postadr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Postnummer:</td><td><font face='Calibri'>".clean_string($fakt_postnr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Ort:</td><td><font face='Calibri'>".clean_string($fakt_ort)."</td></tr>";

$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";

$email_message .= "<tr><td><font face='Calibri'><b>Leveransadress</td><td></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Företagsnamn/enhet:</td><td><font face='Calibri'>".clean_string($lev_foretag1)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 2:</td><td><font face='Calibri'>".clean_string($lev_foretag2)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 3:</td><td><font face='Calibri'>".clean_string($lev_foretag3)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Gatuadress:</td><td><font face='Calibri'>".clean_string($lev_gatuadr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Postnummer:</td><td><font face='Calibri'>".clean_string($lev_postnr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Ort:</td><td><font face='Calibri'>".clean_string($lev_ort)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Inloggning til Netshop</td><td><font face='Calibri'>".clean_string($inlogg)."</td></tr>";
$email_message .= "<tr><td valign='top'><font face='Calibri'>Ev. kommentar:</td><td valign='top'><font face='Calibri'>".clean_string($comments)."</td></tr>";
$email_message .= "</table>";

// create email headers
$headers = 'From: '.$email_from."\r\n".
‘MIME-Version: 1.0’ . “\r\n” .
'Reply-To: '.$email_from."\r\n" .
'BCC: '.$mailkopia."\r\n" .
‘Content-type: text/html; charset=UTF-8’ . “\r\n”;

‘X-Mailer: PHP/’ . phpversion();
@mail($email_to, $email_subject, $email_message, $headers);
?>

<?php require('client.inc.php'); require(CLIENTINC_DIR.'header.inc.php'); ?>

Kontoansökan

Din förfrågan är nu skickad till kundregistret via mail.

<?require(CLIENTINC_DIR.'footer.inc.php'); ?> <?php } ?>[/php]

PleXy · January 8, 2013, 1:55pm

This is kind of what I want: http://www.webbhjalpen.com/test_file.xls
Formatting doesn’t really matter since we’re going to import these values into our system.

PleXy · January 10, 2013, 6:31am

Bump…

PleXy · January 16, 2013, 12:21pm

Anyone please?