PHP - Database Driven Auto E-mail Schedule/sender

I am using magento for sending mail with condition,

My code:

<?php
class Gta_MerchantNotification_Model_Observer {
    public function merchantremainder($Observer) {
       $order = $Observer->getEvent()->getOrder();
       $order_details = $order->getAllVisibleItems();

       $itemData = array();
       foreach ($order_details as $list) {
          $incrementid = $order->getIncrementId();
          $sku = $list->getsku();
          $name = $list->getName();
          $price = $list->getPrice();
          $Qty = $list->getQtyOrdered();
          $extra = $order->getIncrementId();
          $message = 

          "
          <tr>
          <!-- <td>$incrementid</td> -->
          <td>$sku</td>
          <td>$name</td>
          <td>$price</td>
          <td>$Qty</td>
          </tr>";

          $itemData[$list->getId()] = $message;

      }
  
      $finalMessage =  "
      <p>Order Id : $incrementid</p>
      <table border='1'>

      <tr>
      <!-- <th>Id</th> -->
      <th>Sku</th>
      <th>Product name</th>
      <th>Price</th>
      <th>Qty Ordered</th>
      </tr>";
      if (!empty($itemData)) {
          foreach ($itemData as $data) {
             $finalMessage .= $data;
         }

         $finalMessage .= "</table>";
         $this->sendMail($finalMessage);
     }

 }

 public function sendMail($message) {
   $body ="$message";
   $emailTemplate = Mage::getModel('core/email');
   $emailTemplate->setFromName('abc');
   $emailTemplate->setBody($body);
   $emailTemplate->setSubject("Custom Email from observer");
   $emailTemplate->setType('html');
   $emailTemplate->setToEmail('abc@gmail.com');
   $emailTemplate->send();

}
}

?>

 

Output :

 

If order placed mail send to abc@gmail.com.
How to set email sender based on SKU $sku from order.

I want :

1) If SKU starts with 2, email should go to the mail id abc@gmail.com,
screenshot :

 

2) If SKU starts with 3, email should go to the mail id xyz@gmail.com,
screenshot :

 

3) If SKU starts with 4, email should go to the mail id qwe@gmail.com,
screenshot :

 

FYI - If an order contains 10 items email should go separately based on SKU. But an order id the same must include all the emails.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I'm using the php mail function and sending to Gmail accounts it shows "Unknown Sender"

This is my header:
Code: [Select]
$headers = "From: XXXXX\r\nReply-To: XXXX@XXXXX.com";
$headers .= "\r\nContent-Type: text/html; charset='iso-8859-1' Content-Transfer-Encoding: 7bit";

I read somewhere that removing the "\r" would work but no luck...

any  help would be awesome

I would like to send a copy of the mail contents to sender. The mail is sent to me but not the sender. Below is my code but not sure where the error in code is  . Any help would be great

Thanks

 

<?php
 
if(isset($_POST['g-recaptcha-response']) && !empty($_POST['g-recaptcha-response']))
if(empty($_POST[‘g-recaptcha-response’])){
$errMsg = 'Please check the robot checkbox.';
} else if(isset($_POST[‘g-recaptcha-response’]) && !empty($_POST[‘g-recaptcha-response’]))
  {
        $secret = 'secret code';
        $verifyResponse = file_get_contents('https://www.google.com/recaptcha/api/siteverify?secret='.$secret.'&response='.$_POST['g-recaptcha-response']);
        $responseData = json_decode($verifyResponse);
        if($responseData->success)
        {
            $succMsg = 'Your contact request have submitted successfully.';
        }
        else
        {
            $errMsg = 'Robot verification failed, please try again.';
        }
   }
if(isset($_POST['email'])) {
 
    // EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "email@gmail.com";
    $email_subject = "Online Contact Form";
   $email_subject2 = "Please find a copy of the contact form you submitted";

    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']) ||
        !isset($_POST['last_name']) ||
        !isset($_POST['email']) ||
        !isset($_POST['telephone']) ||
        !isset($_POST['comments'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');       
    }
 
     
 
    $first_name = $_POST['first_name']; // required
    $last_name = $_POST['last_name']; // required
    $email_from = $_POST['email']; // required
    $telephone = $_POST['telephone']; // not required
    $comments = $_POST['comments']; // required
 
    $error_message = "";
    $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
 
  if(!preg_match($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
 
    $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.<br />';
  }
 
  if(!preg_match($string_exp,$last_name)) {
    $error_message .= 'The Last Name you entered does not appear to be valid.<br />';
  }
 
  if(strlen($comments) < 2) {
    $error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
 
  if(strlen($error_message) > 0) {
    died($error_message);
  }
 
    $email_message = "Form details below.\n\n";
 
     
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
 
     
 
    $email_message .= "First Name: ".clean_string($first_name)."\n";
    $email_message .= "Last Name: ".clean_string($last_name)."\n";
    $email_message .= "Email: ".clean_string($email_from)."\n";
    $email_message .= "Telephone: ".clean_string($telephone)."\n";
    $email_message .= "Comments: ".clean_string($comments)."\n";
 
// create email headers
$headers = 'From: '.$email_from."\r\n".
$headers2 = "From:" . $email_to;
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_from, $email_subject2, $email_message, $headers2);
@mail($email_to, $email_subject, $email_message, $headers);
header("Location: contact-thank-you.html"); 
?>
 
 
Thank you for contacting us. We will be in touch with you very soon.
 
<?php
 
}
?>

Edited August 15, 2020 by bizstorm

I am trying to write out a calendar style html table with data in each cell, and with a column on the left that shows the times.

Basically it should look like this when written out to the webpage:

Time     Mon    Tues     Wed     Thur     Fri     Sat
8:00    data    data2
9:30               data3              data4   
10:00                         data5            data6
11:00  data7              data8

The times on the left will vary each month, and the 'data' (these are actually fitness classes held each month) will appear on various days of the week.

There is no need to toggle from one month to the next and such, it's just a listing of the current month to display the classes held on which days and at which times.
Very easy to do statically in html, but a bit more challenging dynamically.

Using MySQL, the table that holds the data looks like this:

Code: [Select]
schedule_id     class_time     class_title     day_order       
1               08:00           data                1       
2               08:00           data2               3       
3               09:30           data3               2       
4               09:30           data4               4       
5               10:00           data5               3       
6               10:00           data6               5       
7               11:00           data7               1       
8               11:00           data8               3

The day_order field corresponds to the weekday - Mon is 1, Tues is 2, etc.

My query looks like this:

Code: [Select]
SELECT schedule_id, class_time, class_title, day_orderFROM `class_schedule` order by class_time, day_order
Here is the html/ php code to write it out:

Code: [Select]
<table border="0" cellpadding="2" cellspacing="0" width="625">  
<tr>  
<td class="calheader">Time</td>
<td class="calheader">Mon</td>  
<td class="calheader">Tue</td>  
<td class="calheader">Wed</td>  
<td class="calheader">Thu</td>  
<td class="calheader">Fri</td>  
<td class="calheader">Sat</td>  
<td class="calheader">Sun</td>  
</tr>     

<? $i=0;  
$first_time = "";
 
while($i<$num_rows){
 
$sid = mysql_result($sql,$i,"schedule_id");  
$ctime = mysql_result($sql,$i,"class_time");  
$cdate = mysql_result($sql,$i,"CURDATE()");  
$strtime = date("h:i:s",$cdate.$ctime);  
$ctitle = stripslashes(mysql_result($sql,$i,"class_title"));
$order = mysql_result($sql,$i,"day_order");
   
if ($ctime != $first_time){

  if (isset($first_time)){
  echo "";
 }

 if ($first_time == ""){
 
echo "<tr>\n";    
echo "<td class=\"timecell\">". $ctime ."</td>\n";
 }
     
$first_time = mysql_result($sql,$i,"class_time");    
}
     
$j = 1;
 while ($j<8 && $first_time != ""){        
 if ($order == $j){  
 $thetitle = $ctitle;    
} else {    
$thetitle = "&nbsp;";  
}
 
echo "<td class=\"calcell\">". $thetitle ."</td>\n";

 $j++;
 
}

unset($first_time);
if (!isset($first_time))
{  
echo "</tr>\n";
}     
$i++;  
 }  

unset($ctitle);  
unset($thetitle);  
unset($weekday);  
unset($sid);
unset($clink);
unset($order);
mysql_close();
The above code sort of works, but the trouble I am having is that it is creating a new table row for each class, even if they occur at the same time slot. It should be putting them on the same row, to the right of the time slot across the days of the week.

If anyone could assist, that would be wonderful - I am really stuck with this...
Thanks

Hello,

I am making a small CMS and I having some trouble with making a dynamic menu. I am wondering for a few days how I should make this menu system. I have the follow MySQL table:
 
Code: [Select]
CREATE TABLE `pages` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `time` varchar(10) DEFAULT NULL,
  `lastby` varchar(2) DEFAULT NULL,
  `order_id` varchar(2) DEFAULT NULL,
  `text` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;
Now I would like to have a menu system as following that I make menu's in a menu table with a name and a menu ID and that I could place those pages as parent or as subparent.

How could I manage to turn my theory into reality?