2. PHPRunner General questions
  3. Emailing
This topic is locked

Emailing

 		12/15/2007 2:51:16 AM
PHPRunner General questions
G
 Greeham author

I have a set up with an Add only page in the form of a request form and want the contents to be mailed and then a form of review page set up after it is submitted.
So for the email portion i have a before add event:-

--------------------------

$email="email@email.com";

$subject="Part Request";
$headers = 'MIME-Version: 1.0' . "\r\n";

$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

$headers = "From: ".$values["engineer"]." <".$values["date"].">\n ";
$label = "Instrument";

$message.=$label.": ".$values["instrument"]."\r\n";

$label = "Date";

$message.=$label.": ".$values["date"]."\r\n";

$label = "Customer";

$message.=$label.": ".$values["customer"]."\r\n";

$label = "Part Number";

$message.=$label.": ".$values["part_no"]."\r\n";

$label = "Part Description";

$message.=$label.": ".$values["part_name"]."\r\n";

$label = "Sub Assembly Part 1";

$message.=$label.": ".$values["subassembly1"]."\r\n";

$label = "Sub Assembly Part 2";

$message.=$label.": ".$values["subassembly2"]."\r\n";

$label = "Sub Assembly Part 3";

$message.=$label.": ".$values["subassembly3"]."\r\n";

$label = "Sub Assembly Part 4";

$message.=$label.": ".$values["subassembly4"]."\r\n";

$label = "Sub Assembly Part 5";

$message.=$label.": ".$values["subassembly5"]."\r\n";

$label = "Sub Assembly Part 6";

$message.=$label.": ".$values["subassembly6"]."\r\n";

$label = "Sub Assembly Part 7";

$message.=$label.": ".$values["subassembly7"]."\r\n";

$label = "Sub Assembly Part 8";

$message.=$label.": ".$values["subassembly8"]."\r\n";

$label = "Sub Assembly Part 9";

$message.=$label.": ".$values["subassembly9"]."\r\n";

$label = "Sub Assembly Part 10";

$message.=$label.": ".$values["subassembly10"]."\r\n";

$label = "Quantity";

$message.=$label.": ".$values["quantity"]."\r\n";

$label = "Engineer";

$message.=$label.": ".$values["engineer"]."\r\n";

$label = "Project Code";

$message.=$label.": ".$values["projectcode"]."\r\n";

$label = "Address 1";

$message.=$label.": ".$values["address1"]."\r\n";

$label = "Address 2";

$message.=$label.": ".$values["address2"]."\r\n";

$label = "Address 3";

$message.=$label.": ".$values["address3"]."\r\n";

$label = "state";

$message.=$label.": ".$values["state"]."\r\n";

$label = "postcode";

$message.=$label.": ".$values["postcode"]."\r\n";

$label = "Country";

$message.=$label.": ".$values["country"]."\r\n";
mail($email, $subject, $message, $headers);

return false;
-----------------
After I fill in the form, i just get a list of the filled contents and no email. Have I done this correctly? Also, if I wanted to show a page with a summary of what was requested, how could I do that?
Thanks,
Graham
J
 		Jane 12/17/2007

Greeham,
your code looks correct.

To debug this code you can rpint all variables on the page using echo statement.
Regarding the second question about summary.

You can create custom view on the Datasource tables tab and edit SQL query for this view.
G
 		Greeham author 12/17/2007

That's a great help thanks.
I have yet another question, sorry <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=24238&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
On my Add Page I have many fields, all of which I want emailed once completed but.....a lot of them are drop down dependant and don't want them on the actual add page but what the possible resulting entries to be included in my email.
So if I fill fielda (visible on add page) and a certain selection is made, I want fields x,y and z(not visible on add page) whcih are filled as a result, included in the before add email.
Does that make sense?
Thanks again for your great support.
Graham
J
 		Jane 12/18/2007

Greeham,
I'm not sure that I understand you correctly.

If you want to select actual value from lookup table use this code:

global $conn;

$str = "select DisplayValue from LookupTable where LinkField=".$values["FieldName"];

$rs = db_query($str,$conn);

$data = db_fetch_array($rs);



Actual value is in the $data["DisplayField"] variable.
G
 		Greeham author 12/18/2007

That work's for me, thanks again.
One last question, I promise, I have seen many posts about html inside the email before add, but have tried to no avail to get it to work. All I want is some of my returned values in bold.
Thanks,
Graham