StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8675617
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-12-30T02:38:24.017
FavoriteCount
0
LastActivityDate
2011-12-30T02:38:24.017
LastEditDate
LastEditorUserId
0
OwnerUserId
968521
ParentId
8675422
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I am using a class. It's much more easier. You can try this too. I took this class from somewhere and I improved it to match with my requirement. <pre><code><?php class Mail { private $arrTo = array(); private $arrCC = array(); private $arrBCC = array(); private $strContent = ""; private $strSubject = ""; private $arrHeader = array(); private $arrAttachments = array(); private $numPriority = 3; private $strCharSet = "iso-8859-1"; private $strContentType = "text/plain"; private $strEncoding = "8bit"; /* * Mail::addUser() * * Adds a user to send the email to * * @param String $strAddress : Holds an email address * * @access public * * @return Integer */ public function addUser($strAddress){ if($this->emailCheck($strAddress)){ $this->arrTo[] = $strAddress; return 1; }else{ return 0; } } /* * Mail::removeUser() * * Removes an address from the array * * @param String $strAddress : Holds an email address * * @access public * * @return void */ public function removeUser($strAddress){ //create array or arrays to check $arrVars = array('arrTo', 'arrCC', 'arrBCC'); foreach($arrVars as $resVars){ //sees if the item exists in the array $numKey = array_search($strAddress, $this->{$resVars}); if(isset($numKey)){ //remove the email address $this->{$resVars}[$numKey] = ""; } unset($numKey); } } /* * Mail::addCC() * * Adds a CC user to send to * * @param String $strAddress : Holds an email address * * @access public * * @return Integer */ public function addCC($strAddress){ if($this->emailCheck($strAddress)){ $this->arrCC[] = $strAddress; return 1; }else{ return 0; } } /* * Mail::addBCC() * * Adds a BCC user to send to * * @param String $strAddress : Holds an email address * * @access public * * @return Integer */ public function addBCC($strAddress){ if($this->emailCheck($strAddress)){ $this->arrBCC[] = $strAddress; return 1; }else{ return 0; } } /* * Mail::addReplyTo() * * Adds a reply-to email address * * @param String $strEmail : Holds the reply-to email address * * @access public * * @return void */ public function addReplyTo($strEmail){ if($this->emailCheck($strEmail)){ $this->addHeader("Reply-to: $strEmail"); } } /* * Mail::setContent() * * Adds the content of the email * * @param String $strText : Holds the email content * * @access public * * @return void */ public function setContent($strText){ $this->strContent = $strText; } /* * Mail::setSubject() * * Adds the email subject * * @param String $strText : Holds the email subject * * @access public * * @return void */ public function setSubject($strText){ $this->strSubject = $strText; } /* * Mail::setFrom() * * Adds the sender info to the headers * * @param String $strText : Holds the details of who the email is from * * @access public * * @return void */ public function setFrom($strText){ $this->addHeader("From: $strText"); } /* * Mail::setHTML() * * Sets the email to allow html * * @access public * * @return void */ public function setHTML(){ $this->strContentType = "text/html"; } /* * Mail::setPlain() * * Sets the email to plain text * * @access public * * @return void */ public function setPlain(){ $this->strContentType = "text/plain"; } /* * Mail::setPriority() * * Sets the email priority from 1 – Urgent to 5 – not so * * @param Integer $numPriority : The email priority * * @access public * * @return void */ public function setPriority($numPriority){ $this->numPriority = $numPriority; } /* * Mail::addReadConfirmationEmail() * * Ensures that a confirmation email is sent when read * * @param String $strEmail : Email address to send read confirmation to * * @access public * * @return void */ public function addReadConfirmationEmail($strEmail){ if($this->emailCheck($strEmail)){ $this->addHeader("Disposition-Notification-To: <$strEmail>"); } } /* * Mail::addHeader() * * Adds the header details * * @param String $strText : Holds the header details * * @access public * * @return void */ public function addHeader($strText){ $this->arrHeader[] = $strText; } /* * Mail::addAttachment() * * Adds an attachment to be sent with the email * * @param String $strFile : The file that you want to attach * @param String $strName : The name of the attachment you want displayed * @param String $strType : The MIME type of the file * * @access public * * @return void */ public function addAttachment($strFile, $strName, $strType){ //check to make sure the file exists if(file_exists($strFile)){ $this->arrAttachments[] = array('path' => $strFile, 'name' => $strName, 'type' => $strType); } } /* * Mail::send() * * Sends the email to all the required people * * @access public * * @return void */ public function send(){ //get all the emails in a string to use $strTo = implode(", ", $this->arrTo); //add any CC addresses if needed if($this->arrCC){ $this->addHeader("Cc: ".implode(", ", $this->arrCC)); } //add any BCC addresses if needed if($this->arrBCC){ $this->addHeader("Bcc: ".implode(", ", $this->arrBCC)); } //append any attachments to the end of the content if(count($this->arrAttachments)){ $this->appendAttachments(); } //add the additional headers $this->addAdditionalHeaders(); //implode the headers as they need to be in a single string $strHeader = implode("\r\n", $this->arrHeader); // Set this if you have your own domain //ini_set('sendmail_from', 'yourdomain.com'); //send the email mail($strTo, $this->strSubject, $this->strContent, $strHeader); } /* * Mail::appendAttachments() * * Appends any attachments to the end of the email content * * @access public * * @return void */ public function appendAttachments(){ //create a unique boundary value $strBoundary = "H2O-".time(); //add the boundary to the headers $this->addHeader("Content-Type: multipart/alternitive; boundary=$strBoundary"); //if there is content to the email already we need to add the boundary and content type if($this->strContent){ $strContent = "–$strBoundary\r\n"; $strContent .= "Content-Transfer-Encoding: {$this->strEncoding}\r\n"; $strContent .= "Content-type: {$this->strContentType}; charset={$this->strCharSet}\r\n\r\n"; $this->strContent = $strContent.$this->strContent."\r\n\r\n\r\n"; } //loop through all the attachments foreach($this->arrAttachments as $arrFile){ //read the content of the file into a string and base64 encode and split into the correct chunk size $strData = chunk_split(base64_encode(implode("", file($arrFile['path'])))); //add the attachments $strAttachment = "–$strBoundary\r\n"; $strAttachment .= "Content-Transfer-Encoding: base64\r\n"; $strAttachment .= "Content-Type: {$arrFile['type']}; name={$arrFile['name']}\r\n"; $strAttachment .= "Content-Disposition: attachment; filename={$arrFile['name']}\r\n\r\n"; $strAttachment .= "$strData\r\n"; //add the attachment to the email content $this->strContent .= $strAttachment; unset($strAttachment); } //add the closing boundary $this->strContent .= "–$strBoundary–"; } /* * Mail::addAdditionalHeaders() * * Adds additional headers for content type and priority etc * * @access public * * @return void */ public function addAdditionalHeaders(){ $this->addHeader("MIME-Version: 1.0"); //add the content type and charset if there are no attachments if(!count($this->arrAttachments)){ $this->addHeader("Content-type: {$this->strContentType}; charset={$this->strCharSet}"); } //add the priority $this->addHeader("X-Priority: $this->numPriority"); } /* * Mail::emailCheck() * * Checks to ensure that the email address is valid * * @param String $strAddress : Holds an email address * * @access public * * @return Integer */ public function emailCheck($strAddress){ if(ereg("^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$", $strAddress)){ return 1; }else{ return 0; } } } ?> </code></pre> Implementation: <pre><code>$email = new Mail(); $email->addUser($toAddress); $email->setFrom("Your Company Name<" . $yourCompanyEMail. ">"); $email->setHTML(); $email->setSubject("Subject goes here"); $email->setContent("Mail body goes here"); $email->send(); </code></pre> Cheers !
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PO"From" field on PHP email not working
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USPrasad Rajapaksha
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThis class and implementation would still be open to header injection attacks and other basic SPAM problems (like the code above). This will make sending the messages easier, but does not sanitize inputs (except email address, with an incomplete RegEx that will block valid addresses). For a non-expert user a class like this could lead the programmer to feel safe while opening themselves to being a SPAM provider.
 singulars
 PostPostId
 PO
 UserUserId
 USacrosman
2. CO@ acrosman. Thanks for your comment. I will try to improve this further.
 singulars
 PostPostId
 PO
 UserUserId
 USPrasad Rajapaksha

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.