attaching an excel sheet to an email

fery0098

hi,

I'm using MIME to send a html email and i wanted to attach an excel sheet that will be generated from My SQL database to that email.
can you help me on how can i generate and attach that excel sheet to emails that my script sends?

thank you

toma42

http://framework.zend.com/manual/en/zend.mail.attachments.html

fery0098

thank you for your reply,

i was wondering how can i make the excel sheet using the createAttachment() function?

thank you 🙂

toma42

See http://ilia.ws/files/zendcon_2010_hidden_features.pdf page 27

dagon

excel is a proprietary format, its better to use csv if you can.

toma42

dagon;10972344 wrote:
excel is a proprietary format, its better to use csv if you can.

Better for who? The planet if we all use open formats? Stick to the spec & spend the cycles to create the xls. Flynn can spare them.

dagon

toma42;10972380 wrote:
Better for who? The planet if we all use open formats? Stick to the spec & spend the cycles to create the xls. Flynn can spare them.

The developer (less code), the planet less electricity, the receiver who may not even own excel (dangerous\arrogant) to assume some one owns a particular piece of software*, but will still be able to use the data even with a simple text editor.

all those power point files people send me are sent back.

fery0098

thank you for responds 🙂
in the fallowing code i make a csv file but i have no idea if it works or how to attach it because in the cases above the file was already there!

<?php
include_once('functions.php');
$todaydate = date("Y-m-d");
$usersquery = mysql_query("SELECT FROM users") or die(mysql_error);
$usersnumber = mysql_num_rows($usersquery);
if ($usersnumber == 0)
{
echo "there are no users registered in this website";
}
else
{
$cardsoverall = mysql_query("SELECT FROM cards") or die(mysql_error);
$cardsoverallnum = mysql_num_rows($cardsoverall);
$startnum = ($cardsoverallnum + 1);
echo "You have " . $usersnumber . " user(s) ";
echo "You have " . $cardsoverallnum . " card(s) ";
echo "Excel starting number is: " . $startnum . " ";
echo "============================ ";
while($userarray = mysql_fetch_array($usersquery))
{
$name = $userarray['first'];
$email = '<html><body>' . $name . ", " .
"Your cards have been processed, and added to your account. " .
"Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance. " .
"<table rules='all' border='1' style='border-color: #666;' cellpadding='10'>" .
"<tr style='background: #eee;'><th><center>Item Number<center></th><th><center>Description</center></th></tr>";
			$username = $userarray['username'];
			echo $username . ": ";
			$cards = mysql_query("SELECT * FROM cards WHERE title = '' AND seller = '$username'") or die("card finding error");
			$cardsnumber = mysql_num_rows($cards);
			if ($cardsnumber == 0)
			{
				echo "No new cards for this user ";
			}
			else
			{
				$_file = 'Cardslist.csv'; 
				$_fp = @fopen( $_file, 'w' ); 
				$_csv_data= "Item Number" . "," . "Description" . "\n"; 
				@fwrite( $_fp, $_csv_data );

				while ($newcards = mysql_fetch_array($cards))
				{
					$cardid = $newcards['cardid'];
					if ($newcards['sn'] != NULL)
						$serialnum = " /" . $newcards['sn'];
					else
						$serialnum = '';

					if ($newcards['cardnumber'] != NULL)
						$title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " #" . $newcards['cardnumber'] . " - " . $newcards['playername'] . $serialnum;
					else
						$title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " - " . $newcards['playername'] . $serialnum;

					$horizental = strtolower($newcards['horizontal']);
					$backhorizental = strtolower($newcards['backhorizental']);
					$seller = strtolower($newcards['seller']);
					$updatecards = mysql_query("UPDATE cards SET title = '$title', horizontal = '$horizental', backhorizental = '$backhorizental', aday = '$todaydate', ava = 'yes', sold = 'no', send = 'no', shipping = 'no', seller = '$seller' WHERE cardid = '$cardid'") or die("changing information error");
					if (!$updatecards)
					{
						echo "ERROR CARD " . $title . " with item number of " . $cardid . " had a problem!";
					}
					else
					{
						$email = $email . "<tr><td><center>" . $cardid . "</center></td><td><center>" . $title . "</center></td></tr>";
						$_csv_data= $cardid . ',' . $title . "\n"; 
						@fwrite( $_fp, $_csv_data ); 
					}
				}
				@fclose( $_fp );

				$email = $email . "</table> Your card processing receipt is attached in this email. If you have any comments, questions or concerns please feel free to contact us" . 
						 		 " SCM " . "<a href = 'http://www.sportscardmovers.com'>SportsCardMovers.com</a>";
				$useremail = $userarray['email'];
				$headers = "From: sportscardmovers <no-reply@sportscardmovers.com>" . "\r\n";
				$headers .= "Reply-To: [email]no-reply@sportscardmovers.com[/email]" ."\r\n";
				$headers .= 'Return-path: [email]no-reply@sportscardmovers.com[/email]' . "\r\n";
				$headers .= "MIME-Version: 1.0\r\n";
				$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
				if (mail ($useremail, 'Cards were added to your Account', $email, $headers, "-fno-reply@sportscardmovers.com"))
					echo "E-mail was sent ";
				else
					echo "error - e-mail didn't go through ";
			}
		}
	}
?>

thank you

DaveRandom

Firstly, please indent your code properly, it makes life easier for everyone, and secondly, why don't your let someone else worry about formatting your emails...

fery0098

DaveRandom;10972942 wrote:
Firstly, please indent your code properly, it makes life easier for everyone, and secondly, why don't your let someone else worry about formatting your emails...

my code was indented correctly, i think when i copied it to the fast answer box it was changed and the email is formated correctly!
im just wondering how to add the file that was produced to the email!
here is another copy of my page:

<?php
include_once('functions.php');
        $todaydate = date("Y-m-d");
        $usersquery = mysql_query("SELECT * FROM users") or die(mysql_error);
        $usersnumber = mysql_num_rows($usersquery);
        if ($usersnumber == 0)
        {
            echo "there are no users registered in this website";
        }
        else
        {
            $cardsoverall = mysql_query("SELECT * FROM cards") or die(mysql_error);
            $cardsoverallnum = mysql_num_rows($cardsoverall);
            $startnum = ($cardsoverallnum + 1);
            echo "You have " . $usersnumber . " user(s)<br/>";
            echo "You have " . $cardsoverallnum . " card(s)<br/>";
            echo "Excel starting number is: " . $startnum . "<br/>";
            echo "============================<br/>";
            while($userarray = mysql_fetch_array($usersquery))
            {
                $name = $userarray['first'];
                $email = '<html><body><strong>' . $name . ",</strong><br/><br/>" .
                         "<strong>Your cards have been processed, and added to your account.</strong><br/>" .
                         "<strong>Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance.</strong><br/><br/>" .
                         "<table rules='all' border='1' style='border-color: #666;' cellpadding='10'>" . 
                         "<tr style='background: #eee;'><th><center><strong>Item Number</strong><center></th><th><center><strong>Description</strong></center></th></tr>";

            $username = $userarray['username'];
            echo $username . ": ";
            $cards = mysql_query("SELECT * FROM cards WHERE title = '' AND seller = '$username'") or die("card finding error");
            $cardsnumber = mysql_num_rows($cards);
            if ($cardsnumber == 0)
            {
                echo "No new cards for this user<br/>";
            }
            else
            {
                $_file = 'Cardslist.csv'; 
                $_fp = @fopen( $_file, 'w' ); 
                $_csv_data= "Item Number" . "," . "Description" . "\n"; 
                @fwrite( $_fp, $_csv_data );        
                while ($newcards = mysql_fetch_array($cards))
                {
                    $cardid = $newcards['cardid'];
                    if ($newcards['sn'] != NULL)
                        $serialnum = " /" . $newcards['sn'];
                    else
                        $serialnum = '';

                    if ($newcards['cardnumber'] != NULL)
                        $title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " #" . $newcards['cardnumber'] . " - " . $newcards['playername'] . $serialnum;
                    else
                        $title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " - " . $newcards['playername'] . $serialnum;

                    $horizental = strtolower($newcards['horizontal']);
                    $backhorizental = strtolower($newcards['backhorizental']);
                    $seller = strtolower($newcards['seller']);
                    $updatecards = mysql_query("UPDATE cards SET title = '$title', horizontal = '$horizental', backhorizental = '$backhorizental', aday = '$todaydate', ava = 'yes', sold = 'no', send = 'no', shipping = 'no', seller = '$seller' WHERE cardid = '$cardid'") or die("changing information error");
                    if (!$updatecards)
                    {
                        echo "ERROR CARD " . $title . " with item number of " . $cardid . " had a problem!";
                    }
                    else
                    {
                        $email = $email . "<tr><td><center>" . $cardid . "</center></td><td><center>" . $title . "</center></td></tr>";
                        $_csv_data= $cardid . ',' . $title . "\n"; 
                        @fwrite( $_fp, $_csv_data ); 
                    }
                }
                $email = $email . "</table><br/><br/><strong>Your card processing receipt is attached in this email.<br/>If you have any comments, questions or concerns please feel free to contact us</strong>" . 
                                   "<br/><br/><strong>SCM</strong><br/>" . "<a href = 'http://www.scm.com'>scm.com</a>";
                @fclose( $_fp );
                $useremail = $userarray['email'];
                $headers = "From: scm <no-reply@scm.com>" . "\r\n";
                $headers .= "Reply-To: no-reply@scm.com" ."\r\n";
                $headers .= 'Return-path: no-reply@scms.com' . "\r\n";
                $headers .= "MIME-Version: 1.0\r\n";
                $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
                if (mail ($useremail, 'Cards were added to your Account', $email, $headers, "-fno-reply@scm.com"))
                    echo "E-mail was sent<br/>";
                else
                    echo "error - e-mail didn't go through<br/>";
            }
        }
    }
?>

thanks again 🙂

DaveRandom

You need to use a MIME type in the multipart/* family, and build the multipart body yourself. Maybe this will help you? It's not too hard, but if you need a hand let me know 🙂

fery0098

DaveRandom;10972960 wrote:
You need to use a MIME type in the multipart/* family, and build the multipart body yourself. Maybe this will help you? It's not too hard, but if you need a hand let me know 🙂

thanks for ur respond,
unfortunately i have no idea how to use a "MIME type in the multipart/* family" and how to build such a thing. so i would appreciate your help 🙂
btw, i was wondering why is it kind of hard to just add the file to the email.

thanks 🙂

DaveRandom

Have a look at this post I've just added for someone else who is having an almost identical problem. The code is untested, so let me know how you get on...

fery0098

Dave thank you for taking the time and helping me

so this is my code now:

<?php
include_once('functions.php');

function mail_attachments ($to, $subject, $body, $attachments, $headerstr, $mailparams = FALSE)
{ 
  $mixedboundary = 'boundary-mixed-'.($random_hash = md5(time())); 
  $bodystr = "--$mixedboundary\r\n"; 
  if (isset($body['html']) && isset($body['text'])) { 
    $bodystr .= "Content-Type: multipart/alternative; boundary=\"".($altboundary = "boundary-alt-$random_hash")."\"\r\n\r\n--$altboundary\r\nContent-Type: text/plain; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n".$body['text']."\r\n\r\n--$altboundary\r\nContent-Type: text/plain; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n".$body['html']."\r\n\r\n--$altboundary--\r\n\r\n--$mixedboundary"; 
  } else if (($html = isset($body['html'])) || isset($body['text'])) { 
    $bodystr .= "Content-Type: text/".(($html) ? 'html' : 'plain')."; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n".(($html) ? $body['html'] : $body['text'])."\r\n\r\n--$mixedboundary"; 
  } else return FALSE; 
  foreach ($attachments as $attachment => $type) if (is_file($attachment)) $bodystr .= "\r\nContent-Type: $type; name=\"".basename($attachment)."\"\r\nContent-Transfer-Encoding: base64\r\nContent-Disposition: attachment\r\n\r\n".chunk_split(base64_encode(file_get_contents($attachment)))."\r\n--$mixedboundary"; 
  $bodystr .= "--";  print($bodystr."\r\n\r\nHeaders:\r\n".$headerstr); 
  return ($mailparams) ? @mail($to,$subject,$bodystr,$headerstr,$mailparams) : @mail($to,$subject,$bodystr,$headerstr); 
} 
		$todaydate = date("Y-m-d");
		$usersquery = mysql_query("SELECT * FROM users") or die(mysql_error);
		$usersnumber = mysql_num_rows($usersquery);
		if ($usersnumber == 0)
		{
			echo "there are no users registered in this website";
		}
		else
		{
			$cardsoverall = mysql_query("SELECT * FROM cards") or die(mysql_error);
			$cardsoverallnum = mysql_num_rows($cardsoverall);
			$startnum = ($cardsoverallnum + 1);
			echo "You have " . $usersnumber . " user(s)<br/>";
			echo "You have " . $cardsoverallnum . " card(s)<br/>";
			echo "Excel starting number is: " . $startnum . "<br/>";
			echo "============================<br/>";
			while($userarray = mysql_fetch_array($usersquery))
			{
				$name = $userarray['first'];
				$email = '<html><body><strong>' . $name . ",</strong><br/><br/>" .
						 "<strong>Your cards have been processed, and added to your account.</strong><br/>" .
						 "<strong>Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance.</strong><br/><br/>" .
						 "<table rules='all' border='1' style='border-color: #666;' cellpadding='10'>" . 
						 "<tr style='background: #eee;'><th><center><strong>Item Number</strong><center></th><th><center><strong>Description</strong></center></th></tr>";

			$username = $userarray['username'];
			echo $username . ": ";
			$cards = mysql_query("SELECT * FROM cards WHERE title = '' AND seller = '$username'") or die("card finding error");
			$cardsnumber = mysql_num_rows($cards);
			if ($cardsnumber == 0)
			{
				echo "No new cards for this user<br/>";
			}
			else
			{
				$_file = 'Cardslist.csv'; 
				$_fp = @fopen( $_file, 'w' ); 
				$_csv_data= "Item Number" . "," . "Description" . "\n"; 
				@fwrite( $_fp, $_csv_data );		
				while ($newcards = mysql_fetch_array($cards))
				{
					$cardid = $newcards['cardid'];
					if ($newcards['sn'] != NULL)
						$serialnum = " /" . $newcards['sn'];
					else
						$serialnum = '';

					if ($newcards['cardnumber'] != NULL)
						$title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " #" . $newcards['cardnumber'] . " - " . $newcards['playername'] . $serialnum;
					else
						$title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " - " . $newcards['playername'] . $serialnum;

					$horizental = strtolower($newcards['horizontal']);
					$backhorizental = strtolower($newcards['backhorizental']);
					$seller = strtolower($newcards['seller']);
					$updatecards = mysql_query("UPDATE cards SET title = '$title', horizontal = '$horizental', backhorizental = '$backhorizental', aday = '$todaydate', ava = 'yes', sold = 'no', send = 'no', shipping = 'no', seller = '$seller' WHERE cardid = '$cardid'") or die("changing information error");
					if (!$updatecards)
					{
						echo "ERROR CARD " . $title . " with item number of " . $cardid . " had a problem!";
					}
					else
					{
						$email = $email . "<tr><td><center>" . $cardid . "</center></td><td><center>" . $title . "</center></td></tr>";
						$_csv_data= $cardid . ',' . $title . "\n"; 
						@fwrite( $_fp, $_csv_data ); 
					}
				}
				$email = $email . "</table><br/><br/><strong>Your card processing receipt is attached in this email.<br/>If you have any comments, questions or concerns please feel free to contact us</strong>" . 
						 		  "<br/><br/><strong>SCM</strong><br/>" . "<a href = 'http://www.scm.com'>scm.com</a>";
				@fclose( $_fp );
				$file = array ( '$_fp'=>'.SVC' );
				$emailhtml = array ('html' => $email);
				$useremail = $userarray['email'];
				$headers = "From: sportscardmovers <no-reply@scm.com>" . "\r\n";
				$headers .= "Reply-To: no-reply@scm.com" ."\r\n";
				$headers .= 'Return-path: no-reply@scm.com' . "\r\n";
				$headers .= "MIME-Version: 1.0\r\n";
				$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
				if ( mail_attachments($useremail, "Cards were added to your Account", $emailhtml, $file, $headers, "-fno-reply@scm.com"))
					echo "E-mail was sent<br/>";
				else
					echo "error - e-mail didn't go through<br/>";
			}

			$getempty = mysql_query("SELECT * FROM cards") or die (mysql_error);
			while ( $emptycard = mysql_fetch_array($getempty))
			{
				if ($emptycard['cardid'] == 0 && $emptycard['title'] == "" && $emptycard['playername'] == "")
				{
					$deletecards = mysql_query("DELETE FROM cards WHERE cardid = 0") or die(mysql_error);
				}
			}
		}
	}

?>

this is my out put!

You have 1 user(s)
You have 69 card(s)
Excel starting number is: 70
============================
admin: --boundary-mixed-bc86e9a6529644995d8497331fb77106 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit farshad,

Your cards have been processed, and added to your account.
Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance.

Item Number
Description
69
2007 Playoff Absolute Memorabilia Rookie Premiere Materials Autograph AFC/NFC #269 - Kenny Irons /25


Your card processing receipt is attached in this email.
If you have any comments, questions or concerns please feel free to contact us

SCM
scm.com --boundary-mixed-bc86e9a6529644995d8497331fb77106-- Headers: From: scm Reply-To: no-reply@scm.com Return-path: no-reply@scm.com MIME-Version: 1.0 Content-Type: text/html; charset=ISO-8859-1 E-mail was sent

and email i get is:

--boundary-mixed-bc86e9a6529644995d8497331fb77106 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit
farshad,

Your cards have been processed, and added to your account.
Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance.

Item Number
Description
69
2007 Playoff Absolute Memorabilia Rookie Premiere Materials Autograph AFC/NFC #269 - Kenny Irons /25


Your card processing receipt is attached in this email.
If you have any comments, questions or concerns please feel free to contact us

SCM
scm.com --boundary-mixed-bc86e9a6529644995d8497331fb77106-

and nothing is attached to the email! 🙁

dagon

do your self a favour, don't use mail() for anything but extremely basic email; use one of the libraries like phpmailer, it is so much easier.

look how much simpler it is:

require_once('../class.phpmailer.php');

$mail             = new PHPMailer(); // defaults to using php "mail()"

$body             = file_get_contents('contents.html');
$body             = eregi_replace("[\]",'',$body);

$mail->AddReplyTo("name@yourdomain.com","First Last");

$mail->SetFrom('name@yourdomain.com', 'First Last');

$mail->AddReplyTo("name@yourdomain.com","First Last");

$address = "whoto@otherdomain.com";
$mail->AddAddress($address, "John Doe");

$mail->Subject    = "PHPMailer Test Subject via mail(), basic";

$mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test

$mail->MsgHTML($body);

$mail->AddAttachment("images/phpmailer.gif");      // attachment
$mail->AddAttachment("images/phpmailer_mini.gif"); // attachment

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

http://phpmailer.worxware.com/index.php?pg=examplebmail

fery0098

thank you for your respond,

ok so this is my new code:

<?php
include_once('functions.php');
		$todaydate = date("Y-m-d");
		$usersquery = mysql_query("SELECT * FROM users") or die(mysql_error);
		$usersnumber = mysql_num_rows($usersquery);
		if ($usersnumber == 0)
		{
			echo "there are no users registered in this website";
		}
		else
		{
			$cardsoverall = mysql_query("SELECT * FROM cards") or die(mysql_error);
			$cardsoverallnum = mysql_num_rows($cardsoverall);
			$startnum = ($cardsoverallnum + 1);
			echo "You have " . $usersnumber . " user(s)<br/>";
			echo "You have " . $cardsoverallnum . " card(s)<br/>";
			echo "Excel starting number is: " . $startnum . "<br/>";
			echo "============================<br/>";
			while($userarray = mysql_fetch_array($usersquery))
			{
				$name = $userarray['first'];
				$email = '<html><body><strong>' . $name . ",</strong><br/><br/>" .
						 "<strong>Your cards have been processed, and added to your account.</strong><br/>" .
						 "<strong>Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance.</strong><br/><br/>" .
						 "<table rules='all' border='1' style='border-color: #666;' cellpadding='10'>" . 
						 "<tr style='background: #eee;'><th><center><strong>Item Number</strong><center></th><th><center><strong>Description</strong></center></th></tr>";

			$username = $userarray['username'];
			echo $username . ": ";
			$cards = mysql_query("SELECT * FROM cards WHERE title = '' AND seller = '$username'") or die("card finding error");
			$cardsnumber = mysql_num_rows($cards);
			if ($cardsnumber == 0)
			{
				echo "No new cards for this user<br/>";
			}
			else
			{
				$_file = 'Cardslist.csv'; 
				$_fp = @fopen( $_file, 'w' ); 
				$_csv_data= "Item Number" . "," . "Description" . "\n"; 
				@fwrite( $_fp, $_csv_data );		
				while ($newcards = mysql_fetch_array($cards))
				{
					$cardid = $newcards['cardid'];
					if ($newcards['sn'] != NULL)
						$serialnum = " /" . $newcards['sn'];
					else
						$serialnum = '';

					if ($newcards['cardnumber'] != NULL)
						$title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " #" . $newcards['cardnumber'] . " - " . $newcards['playername'] . $serialnum;
					else
						$title = $newcards['year'] . " " . $newcards['brand'] . " ". $newcards['setname'] . " - " . $newcards['playername'] . $serialnum;

					$horizental = strtolower($newcards['horizontal']);
					$backhorizental = strtolower($newcards['backhorizental']);
					$seller = strtolower($newcards['seller']);
					$updatecards = mysql_query("UPDATE cards SET title = '$title', horizontal = '$horizental', backhorizental = '$backhorizental', aday = '$todaydate', ava = 'yes', sold = 'no', send = 'no', shipping = 'no', seller = '$seller' WHERE cardid = '$cardid'") or die("changing information error");
					if (!$updatecards)
					{
						echo "ERROR CARD " . $title . " with item number of " . $cardid . " had a problem!";
					}
					else
					{
						$email = $email . "<tr><td><center>" . $cardid . "</center></td><td><center>" . $title . "</center></td></tr>";
						$_csv_data= $cardid . ',' . $title . "\n"; 
						@fwrite( $_fp, $_csv_data ); 
					}
				}
				$email = $email . "</table><br/><br/><strong>Your card processing receipt is attached in this email.<br/>If you have any comments, questions or concerns please feel free to contact us</strong>" . 
						 		  "<br/><br/><strong>SCM</strong><br/>" . "<a href = 'http://www.scm.com'>scm.com</a>";
				@fclose( $_fp );
				$useremail = $userarray['email'];
				require_once('phpmailer.inc.php');					
				$mail = new PHPMailer(); // defaults to using php "mail()" 
				$mail->AddReplyTo("no-reply@scm.com","scm"); 
				$mail->SetFrom('no-reply@scm.com', 'scm'); 
				$mail->AddReplyTo("no-reply@scm.com","scm"); 
				$mail->AddAddress($useremail, $name); 
				$mail->Subject    = "Cards were added to your Account"; 
				$mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test 
				$mail->MsgHTML($email); 
				$mail->AddAttachment( $_fp );      // attachment 
				if(!$mail->Send())
				{ 
				  echo "error - e-mail didn't go through<br/>"; 
				} 
				else 
				{ 
				  echo "E-mail was sent<br/>";
				} 
			}

            $getempty = mysql_query("SELECT * FROM cards") or die (mysql_error); 
            while ( $emptycard = mysql_fetch_array($getempty)) 
            { 
                if ($emptycard['cardid'] == 0 && $emptycard['title'] == "" && $emptycard['playername'] == "") 
                { 
                    $deletecards = mysql_query("DELETE FROM cards WHERE cardid = 0") or die(mysql_error); 
                } 
            } 
		}
	}
?>

fery0098

but i get this error!

Fatal error: Call to undefined method phpmailer::SetFrom() in /home2/sportsh9/public_html/beach/beach_addcard.php on line 77

DaveRandom

Try this:

<?php 

  function mail_attachments ($to, $subject, $body, $attachments, $headers = FALSE, $mailparams = FALSE) {
    // Get random hash and define first boundary string
    $mixedboundary = 'boundary-mixed-'.($random_hash = md5(time()));
    // Validate $headers, unset the content-type if it is set and overwrite it with multipart/mixed
    if (!$headers) $headers = array(); else foreach ($headers as $header => $data) if (strtolower($header) == 'content-type') unset($headers[$header]);
    $headers['Content-Type'] = "multipart/mixed; boundary=\"$mixedboundary\"";
    // Build extra headers into a string
    $headersarr = array();
    foreach ($headers as $header => $data) $headersarr[] = "$header: $data";
    $headerstr = implode("\r\n",$headersarr);
    // Start building body
    $bodystr = "--$mixedboundary\r\n";
    if (is_array($body)) {
      if (isset($body['html']) && isset($body['text'])) {
        // Both text and html have been passed, build extra multipart/alternative section
        $bodystr .= "Content-Type: multipart/alternative; boundary=\"".($altboundary = "boundary-alt-$random_hash")."\"\r\n\r\n--$altboundary\r\nContent-Type: text/plain; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n".$body['text']."\r\n\r\n--$altboundary\r\nContent-Type: text/plain; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n".$body['html']."\r\n\r\n--$altboundary--\r\n\r\n--$mixedboundary";
      } else if (($html = isset($body['html'])) || isset($body['text'])) {
        // Only one of text or html have been passed, build as appropriate
        $bodystr .= "Content-Type: text/".(($html) ? 'html' : 'plain')."; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n".(($html) ? $body['html'] : $body['text'])."\r\n\r\n--$mixedboundary";
      } else return FALSE;
    } else if (is_string($body)) {
      // $body is a string, assume HTML 
      $bodystr .= "Content-Type: text/html; charset=\"iso-8859-1\"\r\nContent-Transfer-Encoding: 7bit\r\n\r\n$body\r\n\r\n--$mixedboundary";
    } else return FALSE;
    // Loop through attachments, base64 encode them and add them to $bodystr
    foreach ($attachments as $attachment => $type) if (is_file($attachment)) $bodystr .= "\r\nContent-Type: $type; name=\"".basename($attachment)."\"\r\nContent-Transfer-Encoding: base64\r\nContent-Disposition: attachment\r\n\r\n".chunk_split(base64_encode(file_get_contents($attachment)))."\r\n--$mixedboundary";
    $bodystr .= "--";  print($bodystr."\r\n\r\nHeaders:\r\n".$headerstr);
    // Execut mail() and return the result
    return ($mailparams) ? @mail($to,$subject,$bodystr,$headerstr,$mailparams) : @mail($to,$subject,$bodystr,$headerstr);
  }

  include_once('functions.php'); 

  $todaydate = date("Y-m-d"); 

  // Get all users from DB
  $usersquery = mysql_query("SELECT * FROM `users`") or die(mysql_error); 
  // Exit if there are no users
  if (!$usersnumber = mysql_num_rows($usersquery)) exit("There are no users registered on this website!");

  // Get number of cards from DB
  $cardsoverallnum = mysql_fetch_array(mysql_query("SELECT count(*) AS 'total' FROM `cards`")); 
  $cardsoverallnum = $cardsoverallnum['total'];
  $startnum = ($cardsoverallnum + 1); 

  // Print some info about this session
  echo "You have $usersnumber user(s)<br/>"; 
  echo "You have $cardsoverallnum card(s)<br/>"; 
  echo "Excel starting number is: $startnum<br/>"; 
  echo "============================<br/>"; 

  // Loop through all users
  while($userarray = mysql_fetch_array($usersquery)) { 

// Build email body base
$name = $userarray['first']; 
$email = "<html><body><strong>$name,</strong><br/><br/>" . 
  "<strong>Your cards have been processed, and added to your account.</strong><br/>" . 
  "<strong>Please sign into your 'Account Navigation' page. Please set the asking price(s) for your cards and view your account balance.</strong><br/><br/>" . 
  "<table rules='all' border='1' style='border-color: #666;' cellpadding='10'>" . 
  "<tr style='background: #eee;'><th><center><strong>Item Number</strong><center></th><th><center><strong>Description</strong></center></th></tr>"; 
$username = $userarray['username']; 

echo "$username: "; 

// Get new cards for this user
$cards = mysql_query("SELECT * FROM `cards` WHERE `title` = '' AND `seller` = '$username'") or die("MySQL query error: ".mysql_error()); 
$cardsnumber = mysql_num_rows($cards); 
if (!$cardsnumber) { 
  echo "No new cards for this user<br/>";
  continue;
}

// Define info about this CSV file
$_file = 'tmp-'.time(); 
$_csv_data= "Item Number,Description\n"; 

// Loop through new cards for this user
while ($newcards = mysql_fetch_array($cards)) { 

  // Vaildate data from DB
  $cardid = $newcards['cardid']; 
  $serialnum = ($newcards['sn'] != NULL) ? " /".$newcards['sn'] : '';
  $title = ($newcards['cardnumber'] != NULL) ? $newcards['year']." ".$newcards['brand']." ".$newcards['setname']." #".$newcards['cardnumber']." - ".$newcards['playername'].$serialnum : $newcards['year']." ".$newcards['brand']." ".$newcards['setname']." - ".$newcards['playername'].$serialnum; 
  $horizental = strtolower($newcards['horizontal']); 
  $backhorizental = strtolower($newcards['backhorizental']); 
  $seller = strtolower($newcards['seller']); 
  // Update DB
  if (!mysql_query("UPDATE `cards` SET `title` = '$title', `horizontal` = '$horizental', `backhorizental` = '$backhorizental', `aday` = '$todaydate', `ava` = 'yes', `sold` = 'no', `send` = 'no', `shipping` = 'no', `seller` = '$seller' WHERE `cardid` = '$cardid'")) { 
    echo "ERROR CARD $title with item number of $cardid had a problem! (".mysql_error().")";
    continue;
  }

  // Add this card to email
  $email .= "<tr><td><center>$cardid</center></td><td><center>$title</center></td></tr>"; 

  // Add this card to CSV
  $_csv_data .= "$cardid,$title\n"; 

} 

// Build end of email body
$email .= "</table><br/><br/><strong>Your card processing receipt is attached in this email.<br/>If you have any comments, questions or concerns please feel free to contact us</strong><br/><br/><strong>SCM</strong><br/>" . "<a href = 'http://www.scm.com'>scm.com</a>"; 

// Write this CSV
$_fp = @fopen( $_file, 'w' ); 
@fwrite( $_fp, $_csv_data ); 
@fclose( $_fp ); 

// Build email data
$to = $userarray['email'];
$subject = "Cards were added to your Account";
$body = array ('html' => $email); 
$attachments = array ( $_file => 'text/plain' );
$headers = array( "From" => "sportscardmovers <no-reply@scm.com>", "Reply-To" => "no-reply@scm.com", "Return-Path" => "no-reply@scm.com", "MIME-Version" => "1.0" ); 
$sendmail_params = "-fno-reply@scm.com";

 // Send the email
 echo (mail_attachments($to, $subject, $email, $attachments, $headers, $sendmail_params)) ? "E-mail was sent<br/>" : "Error - E-mail didn't go through!<br/>"; 

 // Delete this temp CSV
 unlink($_file);

  }

  // Delete empty cards
  $deletecards = mysql_query("DELETE FROM `cards` WHERE `cardid` = 0 AND `title` == '' AND `playername` = ''") or die("Error deleting empty cards: ".mysql_error()); 

?>

May still have errors but should be closer to what you want

DaveRandom

dagon wrote:
do your self a favour, don't use mail() for anything but extremely basic email; use one of the libraries like phpmailer, it is so much easier.

I totally agree. I prefer to use PEAR::Mail, as it is available on any decent hosting company's server without having to remember to upload additional classes, but the concept is the same 😉

fery0098

OMG, thank you, thank you, thank you, thank you, i really appreciate your help 🙂 🙂