MMCT TEAM
Server IP : 103.53.40.154  /  Your IP : 18.226.222.132
Web Server : Apache
System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : ppcad7no ( 715)
PHP Version : 8.2.25
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home2/ppcad7no/www/../ariseelectrical.in/../semipreciousslab.com/admin/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/ppcad7no/www/../ariseelectrical.in/../semipreciousslab.com/admin/send-mail.php
<?php 
ob_start();
require_once("../includes/dbsmain.inc.php"); 
?>
<?php
//echo $real_path="http://".$_SERVER['HTTP_HOST']."/".SITE_SUB_PATH."/";

$real_path="http://".$_SERVER['HTTP_HOST'];

if(isset($_POST['mailer_submit'])){
	$subject = $_POST['subject'];
require 'PHPMailer/PHPMailerAutoload.php';

$sql="select * from tbl_mailing_list where 1 and status='Unsent' ORDER BY id LIMIT 10 ";
$res2=db_query($sql);

$countMail=mysqli_num_rows($res2);


if($countMail){
while($data=mysqli_fetch_array($res2)){

$msg_query="<!DOCTYPE html>
<html lang='en' xmlns='http://www.w3.org/1999/xhtml' xmlns:v='urn:schemas-microsoft-com:vml' xmlns:o='urn:schemas-microsoft-com:office:office'>
    <head>
    <meta charset='utf-8'>
    <meta name='viewport' content='width=device-width'>
    <meta http-equiv='X-UA-Compatible' content='IE=edge'>
    <meta name='x-apple-disable-message-reformatting'>
    <title></title>
    <!--[if mso]>
        <style>
            * {
                font-family: sans-serif !important;
            }
        </style>
    <![endif]-->
    <!--[if !mso]><!-->
    <!--<![endif]-->
    <style>
html, body {
	margin: 0 auto !important;
	padding: 0 !important;
	height: 100% !important;
	width: 100% !important;
}
* {
	-ms-text-size-adjust: 100%;
	-webkit-text-size-adjust: 100%;
}
div[style*='margin: 16px 0'] {
	margin: 0 !important;
}
table, td {
	mso-table-lspace: 0pt !important;
	mso-table-rspace: 0pt !important;
}
table {
	border-spacing: 0 !important;
	border-collapse: collapse !important;
	table-layout: fixed !important;
	margin: 0 auto !important;
}
table table table {
	table-layout: auto;
}
img {
	-ms-interpolation-mode: bicubic;
}
*[x-apple-data-detectors], .x-gmail-data-detectors, .x-gmail-data-detectors *, .aBn {
	border-bottom: 0 !important;
	color: inherit !important;
	text-decoration: none !important;
	line-height: inherit !important;
}
.a6S {
	display: none !important;
	opacity: 0.01 !important;
}
img.g-img + div {
	display: none !important;
}
.button-link {
	text-decoration: none !important;
}
@media only screen and (min-device-width: 375px) and (max-device-width: 413px) {
.email-container {
	min-width: 375px !important;
}
}
@media screen and (max-width: 480px) {
u ~ div .email-container {
	min-width: 100vw;
}
}
</style>
    <style>
.button-td,  .button-a {
	transition: all 100ms ease-in;
}
.button-td:hover,  .button-a:hover {
	background: #555555 !important;
	border-color: #555555 !important;
}
@media screen and (max-width: 600px) {
.email-container p {
	font-size: 17px !important;
}
}
</style>
    <!--[if gte mso 9]>
    <xml>
        <o:OfficeDocumentSettings>
            <o:AllowPNG/>
            <o:PixelsPerInch>96</o:PixelsPerInch>
        </o:OfficeDocumentSettings>
    </xml>
    <![endif]-->
    </head>
    <body width='100%' style='margin: 0; mso-line-height-rule: exactly;'>
    <center style='width: 100%; text-align: justify;'>
      <!--<div style='display: none; font-size: 1px; line-height: 1px; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden; mso-hide: all; font-family: sans-serif;'> (Optional) This text will appear in the inbox preview, but not the email body. It can be used to supplement the email subject line or even summarize the email's contents. Extended text preheaders (~490 characters) seems like a better UX for anyone using a screenreader or voice-command apps like Siri to dictate the contents of an email. If this text is not included, email clients will automatically populate it using the text (including image alt text) at the start of the email's body. </div>-->
      <div style='max-width: 600px;border:5px solid #E5E5E5; margin: auto; background-color:#F2F2F2;' class='email-container'> 
        <!--[if mso]>
            <table role='presentation' cellspacing='0' cellpadding='0' border='0' width='600' align='center'>
            <tr>
            <td>
            <![endif]-->
        <table role='presentation' cellspacing='0' cellpadding='0' border='0' align='center' width='100%' style='max-width: 600px;'>
          <tr>
            <td style='padding: 20px 0; text-align: center'><img src='".$real_path."/admin/images/logo.png' width='200' height='50' alt='alt_text' border='0' style='height: auto; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'></td>
          </tr>
        </table>
        <table role='presentation' cellspacing='0' cellpadding='0' border='0' align='center' width='100%' style='max-width: 600px;'>
          <tr>
            <td bgcolor='#ffffff' align='center'><img src='".$real_path."/admin/images/mail-main.png' width='600' height='' border='0' align='center' style='width: 100%; max-width: 600px; height: auto; background: #dddddd; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555; margin: auto;' class='g-img' alt='Divya Gem Stonex' title='Divya Gem Stonex'></td>
          </tr>
          <tr>
            <td bgcolor='#ffffff'><table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%'>
                <tr>
                <td style='padding: 40px; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'><h1 style='margin: 0 0 7px 0; font-family: sans-serif; font-size: 19px; text-transform:uppercase; line-height: 125%; color: #333333; font-weight: normal;'>About Us</h1>
                    <p style='margin: 0;'>We would like to introduce ourselves as a manufacturer and exporter of GemStone and Semi Precious Stone Slabs & their articles, based in India.
we produced many things from GemStone and Semi Precious Stones. Like slabs, all types of dining table, center table, table tops, kitchen counters, bathroom counters,  wall panels, wash basin, bathtubs etc.
and we have range stone from world wide. like- lapis lazuli, malachite, sodalite, agate, quartz, tiger eye, petrified wood, jasper, fluorite, amethyst, opal, chalcedony, ruby etc...</p>

<p>Part of the nature’s repertory, these stones are exceptional raw creations, admired and appreciated since pristine times, been classified by their gems under the renowned name of semi precious stones.</p>
					
					
<p>These stone has been created in nature’s mysterious laboratories, over many thousands of years, these stones are just one of the sources forms where the absolute beauty originated. their structure is a perfect architecture of small crystals coming in an infinite array of colors and depths.</p>

<p>These semi precious stones expressing the essence of stylishness, class and beauty, are the ultimate touch of perfection for any interior, from classic to modern, from romantic to contemporary... a large choice of textures and colors expand and enhance their ability to fit any interior or design. we can create unique, exclusive pieces with any dimensions and also a variety of applications including kitchen & bathroom surfaces, work surfaces, counter tops, floors, walls, furniture, special features and more.</p>

<p>We pride ourselves in the fact that all our products are handmade and possibility of our client to supervise the building process. this way we are sure that Divya Gem Stonex quality and design will exceed your expectations and you will have already established a personal relationship with the product.</p>
										
					
					
                    
                    </td>
              </tr>
                <tr>
                <td style='padding: 0 40px; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'>
                    <table role='presentation' cellspacing='0' cellpadding='0' border='0' align='center' style='margin: auto;'>
                    <tr>
                        <td style='border-radius: 3px; background: #222222; text-align: center;' class='button-td'><a href='http://www.semipreciousslab.com/about-us.html' style='background: #222222; border: 15px solid #222222; font-family: sans-serif; font-size: 13px; line-height: 110%; text-align: center; text-decoration: none; display: block; border-radius: 3px; font-weight: bold;' class='button-a'> <span style='color:#ffffff;' class='button-link'>&nbsp;&nbsp;&nbsp;&nbsp;Read More&nbsp;&nbsp;&nbsp;&nbsp;</span></a></td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                      </tr>
                  </table></td>
              </tr>
              </table></td>
          </tr>
           <tr bgcolor='#333333'>
                <td style='padding: 20px 0 20px 0; font-family: sans-serif; font-size: 15px; line-height: 1000%; color: #555555;'><h2 style='margin: 0; font-family: sans-serif; font-size: 18px; line-height: 125%; color: #ffffff; font-weight: bold; text-align:center;'>OUR FEATURED PRODUCTS</h2></td>
              </tr>
          <tr>
            <td bgcolor='#dddddd' align='center' height='100%' valign='top' width='100%' style='padding:40px 0px 40px 0;'><table role='presentation' border='0' cellpadding='0' cellspacing='0' align='center' width='100%' style='max-width:560px;'>
                <tr>
                <td align='center' valign='top' width='50%'><table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%' style='font-size: 14px;text-align: left;'>
                    <tr>
                    <td style='text-align: center; padding: 0 10px;'><a href='".$real_path."/products.html'><img src='".$real_path."/admin/images/blue-agate.jpg' width='200' height='125' alt='Blue Agate' title='Blue Agate' border='0' align='center' style='width: 100%; max-width: 200px; background: #dddddd; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'></a></td>
                  </tr>
                    <tr>
                    <td style='text-align: center;font-family: sans-serif; font-weight:600; font-size: 14px; line-height: 140%; color: #555555; padding: 10px 10px 0;' class='stack-column-center'><p style='margin: 0;'><a href='".$real_path."/products.html' style='text-decoration:none; color:#000000;'>Blue Agate</a></p></td>
                  </tr>
                  </table></td>
                <td align='center' valign='top' width='50%'><table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%' style='font-size: 14px;text-align: left;'>
                    <tr>
                    <td style='text-align: center; padding: 0 10px;'><a href='".$real_path."/products.html'><img src='".$real_path."/admin/images/tiger-eye-gold-slab.jpg' width='200' height='125' alt='Tiger Eye Gold' title='Tiger Eye Gold' border='0' align='center' style='width: 100%; max-width: 200px; background: #dddddd; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'></a></td>
                  </tr>
                    <tr>
                    <td style='text-align: center;font-family: sans-serif; font-weight:600; font-size: 14px; line-height: 140%; color: #555555; padding: 10px 10px 0;' class='stack-column-center'><p style='margin: 0;'><a href='".$real_path."/products.html' style='text-decoration:none; color:#000000;'>Tiger Eye Gold</a></p></td>
                  </tr>
                  </table></td>
              </tr>
              <tr>
                <td align='center' valign='top' width='50%' style='padding-top:20px;'><table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%' style='font-size: 14px;text-align: left;'>
                    <tr>
                    <td style='text-align: center; padding: 0 10px;'><a href='".$real_path."/products.html'><img src='".$real_path."/admin/images/petrified-wood-slab.jpg' width='200' height='125' alt='Petrified Wood' title='Petrified Wood' border='0' align='center' style='width: 100%; max-width: 200px; background: #dddddd; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'></a></td>
                  </tr>
                    <tr>
                    <td style='text-align: center;font-family: sans-serif; font-weight:600; font-size: 14px; line-height: 140%; color: #555555; padding: 10px 10px 0;' class='stack-column-center'><p style='margin: 0;'><a href='".$real_path."/products.html' style='text-decoration:none; color:#000000;'>Petrified Wood</a></p></td>
                  </tr>
                  </table></td>
                <td align='center' valign='top' width='50%' style='padding-top:20px;'><table role='presentation' cellspacing='0' cellpadding='0' border='0' width='100%' style='font-size: 14px;text-align: left;'>
                    <tr>
                    <td style='text-align: center; padding: 0 10px;'><a href='".$real_path."/products.html'><img src='".$real_path."/admin/images/malachite-slab.jpg' width='200' height='125' alt='Malachite' title='Malachite' border='0' align='center' style='width: 100%; max-width: 200px; background: #dddddd; font-family: sans-serif; font-size: 15px; line-height: 140%; color: #555555;'></a></td>
                  </tr>
                    <tr>
                    <td style='text-align: center;font-family: sans-serif; font-weight:600; font-size: 14px; line-height: 140%; color: #555555; padding: 10px 10px 0;' class='stack-column-center'><p style='margin: 0;'><a href='".$real_path."/products.html' style='text-decoration:none; color:#000000;'>Malachite</a></p></td>
                  </tr>
                  </table></td>
              </tr>
              </table></td>
          </tr>                 
        </table>
        <table role='presentation' cellspacing='0' cellpadding='0' border='0' align='center' width='100%' style='max-width: 680px; font-family: sans-serif; color: #888888; font-size: 12px; line-height: 140%;background-color:#000000;'>
          <tr>
            <td style='padding: 20px 10px; width: 100%; font-family: sans-serif; font-size: 12px; line-height: 140%; text-align: center; color: #888888; font-family:arial;' class='x-gmail-data-detectors'>
              <strong style='font-size:17px; font-family:arial;'>Divya Gem Stonex</strong><br>
              G-71, Phase I & II, Riico Ind. Area, Opp. Old Marble Association,<br />

              Kishangarh -305801, Distt- Ajmer, Rajasthan, India <br>
              +91 9314 9098 71<br>
			  +91 9785 0013 67
              <br>
              <!--<unsubscribe style='color: #888888; text-decoration: underline;'>unsubscribe</unsubscribe>--></td>
          </tr>
        </table>
        <!--[if mso]>
            </td>
            </tr>
            </table>
            <![endif]--> 
      </div>      
    </center>
</body>
</html>";

$mail = new PHPMailer();
//for($i=0; $i<=2; $i++){
//$from="kothariproduct@gmail.com";

$from="info@semipreciousslab.com";

$mail->setFrom($from);
//$mail->addReplyTo('kothariproduct@gmail.com', 'Divya Gem Stonex');

$mail->addReplyTo('info@semipreciousslab.com', 'Divya Gem Stonex');


//$toEmail = "arif.tradekeyindia@gmail.com";
$toEmail = $data['email'];

$mail->addAddress($toEmail);   // Add a recipient
//$mail->addCC("divyagemstonex@gmail.com");
$mail->AddBCC('divyagemstonex@gmail.com','Divya Gem Stonex');
$mail->AddBCC('arif.tradekeyindia@gmail.com','Arif');

$mail->isHTML(true);  // Set email format to HTML

///////////////  Remove Comment In The case of Attachemnet ////////////////

//$file_to_attach = $_FILES['txt_ans_file']['tmp_name'];
//$mail->AddAttachment( $file_to_attach , $_FILES['txt_ans_file']['name'] );


///////////////////////////////////////////////////////////////////////////////


$bodyContent = "$msg_query";

$mail->Subject = $subject;
$mail->Body    = $bodyContent;


//$sql="UPDATE tbl_mailing_list SET status='Sent',last_sent_date='".date("Y-m-d")."' WHERE email='$data[email]'";
//db_query($sql);
//$_SESSION["msg"]="<span style='color:green;font-weight:600'>Message sent successfully.</span>";

if(!$mail->send()) {
    $_SESSION["msg"]="<span style='color:red;font-weight:600'>Message could not be sent.</span>";
//    echo 'Mailer Error: ' . $mail->ErrorInfo;
} else {
$_SESSION["msg"]="<span style='color:green;font-weight:600'>Message sent successfully.</span>";
$sql="UPDATE tbl_mailing_list SET status='Sent',last_sent_date='".date("Y-m-d")."' WHERE email='$data[email]'";
db_query($sql);
}

}

}else{
	
$_SESSION["msg"]="<span style='color:red;font-weight:600'>Message can not be sent, no mailing list available.</span>";	
}

}
?>
<?php include ('top.inc.php'); ?>
            <link href="styles.css" rel="stylesheet" type="text/css">
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead" ><div id="txtPageHead">Manage Email Marketing </div></td>
              </tr>
            </table>
            <div align="center" style="margin-top:10px"><b>
              <?php 
			  if(!empty($_SESSION["msg"])){
			echo $_SESSION["msg"];
			unset($_SESSION["msg"]);	  
			  }			  
			  ?>
              </b></div>
              
            <table width="100%" border="0" cellspacing="0" cellpadding="0" style="margin-top:20px">
        <tr>
          <td><form method="post" name="register" id="register" action='' onsubmit="return KeyValidation();" enctype="multipart/form-data">
              <table  border="0" align="center" cellpadding="0" cellspacing="5"   width="100%" class="tableSearch">
                <?php /*?><tr>
                  <td colspan="2" align="center"><strong><font style="color:<?=$colrm?>;" size="2">
                    <?=$msg?>
                    <?=display_sess_msg();?>
                    </font></strong></td>
                </tr><?php */?>
                <tr>
                  <td align="right" class="tdLabel" style="padding:5px;width:30%"><strong>Enter Subject : </strong></td>
                  <td style="padding:5px;;width:30%"><input name="subject" id="subject" type="text" value="<?=$subject?>" required="required" style="width:450px; height:30px;" /></td>
                
                <!--<tr>
                  <td align="right" class="tdLabel" style="padding:5px;"><strong>Enter Keyword : </strong></td>
                  <td style="padding:5px;"><input name="keyword" id="keyword" type="text" value="<?=$keyword?>" style="width:280px; height:30px;" /></td>
                </tr>
                <tr>
                  <td align="right" style="padding:5px;"><strong>Business Category :</strong></td>
                  <td style="padding:5px;"><select name="classi" style="width:285px; height:34px;">
                      <option value="">All</option>
                      <option value="Exporter">Exporter</option>
                      <option value="Wholesale Supplier">Wholesale Suppliers</option>
                      <option value="Importer">Importers</option>
                      <option value="Manufacturer">Manufacturer</option>
                      <option value="Service Provider">Services Provider</option>
                    </select>
                  </td>
                </tr>
                <tr>
                  <td height="22" align="right" style="padding:5px;"><strong>Member Type :</strong> </td>
                  <td style="padding:5px;"><select name="mem_type" style="width:285px; height:34px;">
                      <option value="">All</option>
                      <option value="1">Free</option>
                      <option value="2,3,4,5">Paid</option>
                      <option value="2">Silver</option>
                      <option value="3">Glod</option>
                      <option value="4">Platinum</option>
                      <option value="5">Premium</option>
                    </select></td>
                </tr>  -->              
                
                  
                  <td style="padding:5px;" align="left"><input name="mailer_submit" type="submit" value="Send Email" style="width:110px; height:35px; font-size:14px; font-weight:bold;"></td>
                </tr>
              </table>
            </form></td>
        </tr>
      </table>
      
      
      
<?php     
      
$start = intval($start);
$pagesize = intval($pagesize)==0?$pagesize=10:$pagesize;

$order_by == '' ? $order_by = 'id' : true;
$order_by2 == '' ? $order_by2 = 'desc' : true;
 
$sql = "select * from  tbl_mailing_list   where 1 and status='Sent'";
//$sql = apply_filter($sql, $site_pages_name, 'like','site_pages_name');
$sql .= " order by $order_by $order_by2 ";
$sql .= " limit $start, $pagesize ";

$pager = new midas_pager_sql($sql, $pagesize, $start);
if($pager->total_records) {
	$result = db_query($sql);
}
?>
<link href="styles.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/javascript" src="../includes/general.js"></script>



<h2 style="text-align: center;
    color: #000;
    padding: 6px 0;
    margin: 34px 0 -14px 0;
    font-size: 23px;
    text-decoration: underline;">E-Mail Sent List</h2>           
			
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="content">
				  
                  <? if($pager->total_records==0) {?>
                  <div class="msg">Sorry, no records found.</div>
                  <? } else { ?>
                  <span style="float:right" >
                    <? $pager->show_displaying()?>
                  </span>
                  <div>Records Per Page:
                    <?=pagesize_dropdown('pagesize', $pagesize);?>
                  </div>
                  <form method="post" name="form1" id="form1" onsubmit="confirm_submit(this)">
                    <table width="100%"  border="0" cellpadding="0" cellspacing="1" class="tableList" style=" border:1px outset #fff;">
                      <tr>
                        <th width="35%" nowrap="nowrap" style="padding:7px;font-size:12px;">Email
                          <?=sort_arrows('email')?></th>
						  <th width="14%" nowrap="nowrap" style="padding:7px;font-size:12px;">Send Date</th>
						  
                        <th width="14%" nowrap="nowrap" style="padding:7px;font-size:12px;">Status
                          <?=sort_arrows('status')?></th>
						  <!--<th width="10%" nowrap="nowrap">Order By</th>-->
                       
                        
                      </tr>
                      <?
while ($line_raw = mysqli_fetch_array($result)) {
	$line = ms_display_value($line_raw);
	@extract($line);
	$css = ($css=='trOdd')?'trEven':'trOdd';
?>
                      <tr class="<?=$css?>">
                        <td nowrap="nowrap" align="center" style="padding:7px;"><?=$email?></td>

						<td nowrap="nowrap" align="center" style="padding:7px;"><?=$last_sent_date?></td>
						
                        <td nowrap="nowrap" align="center" style="padding:7px;"><?=$status?></td>
						
                        
                      </tr>
                      <? } ?>
                    </table>
                    
                  </form>
                  <? $pager->show_pager();?>
                  <? } ?>
                </td>
              </tr>
            </table>      
      
<script type="text/javascript">
/*function KeyValidation(){	
   function trim(str){				
	 return str.replace(/^\s*|\s*$/g,'');
	}	
if(trim(document.getElementById('keyword').value)==0){		
alert("Enter Keyword !");
document.getElementById('keyword').focus();
return false;
}	
}*/
</script>
            <?php include ('bottom.inc.php'); ?>

MMCT - 2023