PHP - Add Link Into Email Message

Hi all,

I am just starting out in the world of php and have got this far with a lot of googling.  But I'm really stuck with this part now.

I have a function that works perfectly for display on a page, eg <?php echo quickquote(); ?>

function quickquote() {
global $db;
global $cart;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$quickquote[] = 'Quote Required:<br />';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$quickquote[] = ''.$qty.'';
$quickquote[] = ' x ';
$quickquote[] = '' . $model . '';
$quickquote[] = ' (' . $type . '- ';
$quickquote[] = ''. $basin . '- ';
$quickquote[] = ''. $top . ')';
$quickquote[] = '<br />';
}
$quickquote[] = 'End of Quick Quote Request';
} else {
$quickquote[] = 'The quote cart is empty.';
}
return join('',$quickquote);

}

However, i am trying to include this in an email message:

if(!$error)
{
$messages="From: $email <br>";
$messages.="Name: $name <br>";
$messages.="Email: $email <br>";
$messages.="Phone: $phone <br>";
$messages.="Message: $message <br>";
$messages.="Quick Quote Request: $quickquote <br>";

$mail = mail($to,$subject,$messages,$headers);

The email also works perfectly with the exception that the data is not there from $quickquote.

I've tried all sorts of variations and suggested solutions from the web but nothing I've tried has been successful so far.

It's amazing that I've got this far so I don't want to give up on it, but I'm just completely stumped ...

All information and help very much appreciated.

Cheers
K

Hi I built a really simple customer review form https://kickasssoftwear.uk/dev/reviews.html (it's only been optimised for mobile view so far) and it works using the php mail script on this page https://kickasssoftwear.uk/dev/empty2.php - the emails are being sent to me and the format of the emails is OK, and the form redirects to the empty2 page with a mailsent message in the address bar.

I know I can leave that page as is and write a nice thank you message in the html - but what I really want to do is have the customers name there too, Thanks 'name' your review has been sent,

but I can't get it to work - it's been 4 whole days now and I really need to eat & sleep! Please if anyone has suggestions or advice for a noob, please help. Thanks

Hi

I have a problem with parsing a query into the email message. Where messege shuld be a complete resoult of a query.

Please take a look on code below:

Code: [Select]
$message = "\r\n" .
                    'Order details:' .
                    '<br><br><table><tr><td>Name</td><td>Amount</td><td>Unit</td><td>Price</td><td>Total</td></tr>' . "\r\n";

/// till here is fine

$result2 = mysql_query("SELECT * FROM orderslist WHERE supplier='$supplier'") or die(mysql_error());
$data = array();
$data['' . $row2['id']] = $_POST['' . $row2['id']];
$value = $_POST['' . $row2['id']];

while($row2=mysql_fetch_array($result2))
{
$value = $_POST['' . $row2['id']];
if ( $value == ""){

}
else {
$total = $value * $row2['price'];

/// this part below i have a problem with do not now how to join this part with the top part ($message)

echo "
<tr>
    <td class='H4'><strong>$row2[name]</strong></td>
<td class='H4' align='center'>$value</td>
<td class='H4'>$row2[unit]</td>
<td class='H4'>$row2[price]</td>
<td class='H4'>$total</td></tr>";
}
 }
echo "</table>";


I think that has something to do with "\r\n"  and dots, but i do not get that fully. If someone could help me on this one will be gratefull.

Thank you very much in advance.

I have an auto responder in a php order form with the phrase "Our web sites uses a secure order form for customers to purchase products, and services..."  When the message is sent, the word 'services'  comes out like this: "...products, and 1s."  Each instance of the word 'services' is changed to '1s'. Any ideas?

Hi all

I have a script that I have patched together and got to work in pieces.  I'm up to the last part.  I have the form working and emailing.  It also will upload an image by itself and put it in a folder.  Now i just need to tie those together and have the image put in the email as an attachment then deleted from server.

I have it at a stage where it sends me the users details.. and it tries to send the photo but it comes through as junk txt.  I think its the MIME encoding stuff that I have wrong.. not sure?

Here's what I have so far.

Code: [Select]

$attachment = $path_of_uploaded_file;
$fileatt = $attachment; // Path to the file                 
$fileatt_type = "application/octet-stream"; // File Type
    $start= strrpos($attachment, '/') == -1 ? strrpos($attachment, '//') : strrpos($attachment, '/')+1;
$fileatt_name = substr($attachment, $start, strlen($attachment)); // Filename that will be used for the file as the attachment

    $file = fopen($fileatt,'rb');
$data = fread($file,filesize($fileatt));
fclose($file);

$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
$headers = "\nMIME-Version: 1.0\n" .
            "Content-Type: multipart/mixed;\n" .
            " boundary=\"{$mime_boundary}\"";

$email_message .= "This is a multi-part message in MIME format.\n\n" .
                "--{$mime_boundary}\n" .
                "Content-Type:text/html; charset=\"iso-8859-1\"\n" .
               "Content-Transfer-Encoding: 7bit\n\n" .

$data = chunk_split(base64_encode($data));
$email_message .= "--{$mime_boundary}\n" .
                  "Content-Type: {$fileatt_type};\n" .
                  " name=\"{$fileatt_name}\"\n" .
                  "Content-Disposition: attachment;\n" .
                  " filename=\"{$fileatt_name}\"\n" .
                  "Content-Transfer-Encoding: base64\n\n" .
                 $data . "\n\n" .
                  "--{$mime_boundary}--\n";
     
// create email headers
$headers .= 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();

@mail($email_to, $email_subject, $email_message, $headers); 



Thanks

Wolfsta

Hi, I got this script which I would like to send a message to all email addresses in the database or send to approved members only. Once I got the first part of this script working I can get the rest to work when sending to approved members.

Here is the form which passes the message to the script.

Code: [Select]
<?php 

include_once("data/server.php");

$all = 'unchecked';
$approved = 'unchecked';


if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {
$all = 'checked';

}
else if ($selected_radio == 'approved') {
$approved = 'checked';
}
}

?>

<div id="pageNav">
    <div id="sectionLinks"> <a href="admin.php?cmd=database&username=admin">Database</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=editTemplate&username=admin">Templates </a> <a href="admin.php?cmd=email&username=admin">Email</a> <a href="admin.php?cmd=messaging&username=admin">Messaging</a> <a href="admin.php?cmd=protected&username=admin">Protected Directory</a> <a href="admin.php?cmd=filesanddir&username=admin">Files and Directories</a> <a href="admin.php?cmd=usertracking&username=admin">User Tracking</a> <a href="admin.php?cmd=advanced&username=admin">Advanced</a> <a href="admin.php?cmd=uploads&username=admin">Uploads</a> <a href="admin.php?cmd=subscriptions&username=admin">Subscriptions</a> <a href="admin.php?cmd=applications&username=admin">Applications</a> <a href="admin.php?cmd=searchForms&username=admin">Search Form Builder</a> <a href="admin.php?cmd=categories&username=admin">Categories</a> <a href="admin.php?cmd=phpBB&username=admin">phpBB</a> <a href="admin.php?cmd=mySQL&username=admin">MySQL</a></div>
  </div>
  <div id="content">
   
    <div class="page">


<form action=templates/admin/msgtest.php method=POST>
<table>
<tr>
<td>Your Message:</td>
<tr><td>&nbsp;</td><td>&nbsp;</td></tr>
<tr><td><TEXTAREA NAME="message" COLS=40 ROWS=6></TEXTAREA></td></tr>
</table>
<table>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $all; ?>
</td>
<td>Send Message to all members</td>
</tr>
<tr>
<td><input type = 'Radio' Name ='Mailto' value= 'yes'
<?PHP print $approved; ?>
</td>
<td>Send Message to Approved members only</td>
</tr>
<tr><td colspan=2><input type=submit name=submit value=Submit></td></tr>
</table>
</form>



</table>
    </div>
   
  </div> 
</div>



And here is the code I have got so far but it doesnt work

Code: [Select]
<?php

include_once("../../data/server.php");
include("../../data/mysql.php");

if (isset($_POST['Submit1'])) {

$selected_radio = $_POST['Mailto'];

if ($selected_radio == 'all') {

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());

 $q2 = "select * from games_newsletter ";
$result = mysql_query("SELECT email FROM profiles");   
 
while ($email = mysql_fetch_assoc($result)) {

$to = $email;
$subject = "Test Message";
$body = "This is a test message";
 $headers = "From: payments@tropicsbay.co.uk\r\n" .
     "X-Mailer: php";
 if (mail($to, $subject, $body, $headers)) {
   
// Redirect back to manage page
header("Location: admin.php?cmd=messaging");


} else {

echo "Approval Message Failed";

}
}
mysql_close($con);
}
}

?>
As always, any help is much appreciated

Paul

here's my code that i've used to send an email.

Code: [Select]
$link = "<a href=\"http://www.example.com/" . $num . "\">" . $num . "</a>";

$query = "SELECT content FROM emails";
$result = mysql_query($query) or die();
$email_content = mysql_result($result, 0);
$email = sprintf($email_content, $first, $name, $from, $link, $record, $rec, $inc, $max);
$email_body = stripslashes(htmlentities($email, ENT_QUOTES, 'UTF-8'));

// this is sent to another php script via post....

$subject = $_POST['subject'];
$message = nl2br(html_entity_decode($_POST['email_body']));
$to = "me@whatever.com";
$charset='UTF-8';
$encoded_subject="=?$charset?B?" . base64_encode($subject) . "?=\n";
$headers="From: " . $userEmail . "\n"
. "Content-Type: text/html; charset=$charset; format=flowed\n"
. "MIME-Version: 1.0\n"
. "Content-Transfer-Encoding: 8bit\n"
. "X-Mailer: PHP\n";
mail($to,$encoded_subject,$message,$headers);
   

in the db, emails.content is of the text type and contains several lines of text with %4$s which inserts the value of $link into the body.  when the email arrives, there is a link and it appears fine, with the value of $num hyperlinked.  however when you click on it it doesn't go anywhere.  when copying the link location from the email it gives me

x-msg://87/%22http://www.example.com/16

what is x-msg?  how can i get this to work properly?

I am trying to eliminate this issue but I have had no luck here is my current code:

Code: [Select]
$from = 'help@my.com';

$body = "<html>\n";
$body .= "<body style=\"font-family:Verdana, Verdana, Geneva, sans-serif;\">\n";
$body .= $message;
$body .= "</body>\n";
$body .= "</html>\n";

$boundary = uniqid('np');

$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";

$headers = "From: $from";
$headers .= "\nMIME-Version: 1.0\n" ."Content-Type: multipart/alternative;\n" ." boundary=\"{$mime_boundary}\"";

$message = "This is a multi-part message in MIME format.\n\n" .
"--{$mime_boundary}\n" .
"Content-Type: text/html; \n" .
"Content-Transfer-Encoding: 7bit\n\n" .
$body . "\n\n" . "--{$mime_boundary}--\n";

mail($to, $subject, $message, $headers, '-f'.$from);


I have tried adding the plain text part but nothing has worked, could someone else look at this and show me what I need to add so that it has the text/plain MIME part as well?

Is there a way to add an HTML link in a Text E-mail that was generated by PHP?

I am trying to create an e-mail that looks like this...

Quote

Dear Member,

Your password was re-set, and the following Temporary Password has been assigned:

Use this temporary password to Log In.




Debbie

Hi All,
I'm sending an email with a link to a web page with a form on.

Code: [Select]
<tr style="padding:10px;">
  <td align="center">
    <a style="text-decoration:none;" href="http://www.foo.co.uk/bar.php?id=123">
      <img src="/header.jpg" border="0" style="display: block;" width="380" height="64" alt="Logo" />
    </a>
  </td>
</tr>

I currently GET the id from the URL and add it to a hidden field in the form which then sends the ID to the database on submit so I know from which email the user came from to fill out the form.
This doesn't always work as I guess some people move from the form page to look at other pages on my site then come back to fill in the form.
I think I need to use SESSION to keep the id 'active' but cannot figure out how to GET the id from the URL and put it into a SESSION, alas I am struggling to even start and finish a basic SESSION.

Thanks in advance,
Ben.

I am sending emails using PHPMailer.  My configuration is below.   When adding a link to the message, should I use anchor tags?  Both seem to work.  What is the implication to recipients who are not using HTML email?   On a side note, if anything below seems wrong, please let me know.   Thanks

$msg='<p>Hello</p><p>Link: http://phpmailer.worxware.com/</p><p>Link: http://phpmailer.worxware.com</p><a href="http://phpmailer.worxware.com">http://phpmailer.worxware.com</a>';

$mail = new myPHPMailer(true);
$mail->AddReplyTo('myEmail@xxx.com', 'Michael Reed');
$mail->SetFrom('myEmail@xxx.com', 'Michael Reed');
$mail->AddAddress('johndoe@xxx.com', 'John Doe');
$mail->Subject = "Here is your email";
//AltBody property need not be sent since PHPMailer will create an alternate automatically
$mail->MsgHTML($message);
return ($mail->Send());

class myPHPMailer extends PHPMailer {
    public function __construct($allow_exceptions=false){
        $this->isSMTP();
        $this->SMTPDebug = 0;
        $this->Host = "smtp.gmail.com";
        $this->Port = 587;
        $this->SMTPSecure='tls';  // sets the prefix to the server.  Used for gmail only.
        $this->SMTPAuth = true;
        $this->Username = 'xxx';
        $this->Password = 'xxx';
    }
}

guys this function below posts the data into table and im also able to send a link in email with caregory name but the issue is getting the id to the particular post i got no isea how do i get that?

Code: [Select]
function insert($postData) {
$postData['description'] = clean($postData['description']);
if(!EmailExists($postData['email'])){
$sql = " INSERT INTO tbl_emails SET
email = '".$postData['email']."',
postersname = '".$postData['postersname']."',
phone = '".$postData['phone']."'
";
executeSql($sql);
}
if(empty($_FILES['image']["name"])){
$sql = " INSERT INTO tbl SET
title = '".$postData['title']."',
image = '',
postersname = '".$postData['postersname']."',
category = '".$postData['category']."',
type = '".$postData['type']."',
state = '".$postData['state']."',
location = '".$postData['location']."',
email = '".$postData['email']."',
phone = '".$postData['phone']."',
description = '".$postData['description']."',
time = '".time()."'
";
executeSql($sql);
}else{
global $uploadPath;
$remove_symbols = array('+', '=', '-', '{', '}', '$', '(', ')','&');
$removed_symbols = str_replace($remove_symbols, "_", $_FILES['image']['name']); 
$randomnum=rand(00000000,99999999); 
$imagepath = uploadFile($_FILES['image'], $uploadPath);
$image = new SimpleImage();
$image->load($imagepath);
$image->resize(250,280);
$resize_rename = $uploadPath.$randomnum._.$removed_symbols;
$image->save($resize_rename);
unlink($imagepath); //delete the original file
$sql = " INSERT INTO tbl SET
title = '".$postData['title']."',
image = '".$resize_rename."',
postersname = '".$postData['postersname']."',
category = '".$postData['category']."',
type = '".$postData['type']."',
state = '".$postData['state']."',
location = '".$postData['ocation']."',
email = '".$postData['email']."',
phone = '".$postData['phone']."',
description = '".$postData['description']."',
time = '".time()."'
";
executeSql($sql);
}
}

Hey guys,
I'm going to start working on a simple php/mysql project, and wondering if you guys could point me in the right direction. Here is what I want to do:

1. User is presented with a simple form asking a series of questions (including email address)
2. Based on the answers, a specific download link is emailed to the user
3. store all inputted information in the database.

I'm still not sure if I want the email process to be automated, or "held" until the information is reviewed, then download link sent.

Does anyone know if a script already exist for this? I don't need to create user accounts, I just want to obtain user information every time they want to download something.

Thanks for any help.

Hey guys im having a problem with emailing a link using local host mail. I'm using out look express with Mercury. I shorten the email below as much as possible.
Its really wierd the target for the link is correct but clicking on it gives me this res ieframe.dll

res://ieframe.dll/syntax.htm#http//localhost/stargate/users/account_settings.php?
npd=82b1e0df295ee681f1fa2f213ade823d


$to = $_POST['resendemail'];
     $from = "stargate@localhost.com";
     $subject = "Stargate System Lords Password Recovery";
    
     $message = "<html>
     <body background=\"#4B4B4B\">
     <h1>Stargate System Lords Password Recovery</h1>
     Dear ".$users1['name'].", <br>
     <center>

<a href="localhost/stargate/users/account_settings.php?npd=$new_password ">Log In</a>
     <p>
     <br /> 
     </font>

     </body>
     </html>";
   
$headers  = "From: Stargate Game Password Recovery <stargate@localhost.com>\r\n";
$headers .= "Content-type: text/html\r\n";

mail($to, $subject, $message, $headers); 

Not sure if this relates more to PHP or Javascript/jQuery, but is there a way to attach a file to an email client (i.e Outlook), when user click on a link/button?

I have a link that generates a PDF and I want it so that, when someone click on a link, it will open up their email client with the PDF already attached, and subject already fill in.

I know, you can use <a href="mailto:..."  but that only opens up the mail client. I also need to attach a file with a subject fill in.

Is this doable with PHP or Javascript?