Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Bom dia pessoal.
Eu refiz o e-mail do meu site.
Dentre as novidades, agora pode-se enviar uma mensagem para mais de um e=mail.
Tenho esse select que busca quais e-mails serão dos destinatários:
/**** E-mails dos destinatários ****/
$sql_email_dest = mysqli_query($config, "SELECT email FROM tb_email_home_email WHERE id_item = '1'") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_email_dest) <= '0'){
echo "";
}else{
while($r_sql_email_dest = mysqli_fetch_array($sql_email_dest)){
$email_email_home_sel[] = $r_sql_email_dest[0];
}
}E no PHPMailer, este foreach para enviar:
foreach($email_email_home_sel as $email_contato){
$mail->AddAddress($email_contato); // E-mail do destinatário
}
É simples, mas tentei de várias formas...
Se eu colocar da forma antiga, com um e-mail (sem estar no foreach) funciona.
Mas da forma acima, sem chance.
Alguém já viu algum caso parecido?
Tem alguma idéia?
Obrigado!Boa tarde.
Retornou:
array(1) { [0]=> string(30) "email@dominio.com.br" }
* Não retornou este e-mail fictício.
Parece que não está vazia.
Mas obrigado pela atenção.Poste o código completo, o que funciona e o que não funciona.
Vixi.
Ficou meio grande.
Mas vamos lá.
Tudo está funcionando.
É só o email de retorno que, por estar no foreach não funciona.
if(isset($_POST['enviar_email']) && $_POST['enviar_email'] == 'env'){
date_default_timezone_set("America/Sao_Paulo");
$nome = strip_tags(trim($_POST['nome']));
$email = strip_tags(trim($_POST['email']));
$telefone = strip_tags(trim($_POST['telefone']));
$cidade_cli = strip_tags(trim($_POST['cidade']));
$estado_cli = strip_tags(trim($_POST['estado']));
$pesquisa = strip_tags(trim($_POST['pesquisa']));
$mensagem = strip_tags(trim($_POST['mensagem']));
$assunto = "Mensagem enviada pelo site";
$data = date("d/m/Y");
$data_email = date("Y-m-d");
$hora = date("H:i");
$captcha_data = $_POST['g-recaptcha-response'];
$exibir_apos_enviar = "
<script type=\"text/javascript\">
swal({
title: \"Enviado\",
text: \"Agradecemos seu contato!\",
confirmButtonColor: \"#FF6000\",
type: \"success\"
});
</script>
";
$exibir_apos_nao_enviar = "
<script type=\"text/javascript\">
swal({
title: \"Oopss...\",
text: \"Ocorreu um erro ao enviar a mensagem\",
confirmButtonColor: \"#e74c3c\",
type: \"error\"
});
</script>
";
if(!$captcha_data){
echo "
<script type=\"text/javascript\">
swal({
title: \"Oopss...\",
text: \"O reCAPTCHA não foi habilitado\",
confirmButtonColor: \"#e74c3c\",
type: \"error\"
});
</script>
";
}else{
$resposta = file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=6Lez2zAUAAAAADVJuF0M6asyKTMTIHEumkR0Ecvd&response=".$captcha_data."&remoteip=".$_SERVER['REMOTE_ADDR']);
if($resposta.success){
$sel_cid = mysqli_query($config, "SELECT nome FROM tb_cidades WHERE id = '$cidade_cli'") or die(mysqli_error($config));
if(@mysqli_num_rows($sel_cid) <= '0'){
echo "<p>$info</p>";
}else{
while($res_sel_cid = mysqli_fetch_array($sel_cid)){
$cidade_cli_conv = $res_sel_cid[0];
}
}
$sel_uf = mysqli_query($config, "SELECT uf FROM tb_estados WHERE id = '$estado_cli'") or die(mysqli_error($config));
if(@mysqli_num_rows($sel_uf) <= '0'){
echo "<p>$info</p>";
}else{
while($res_sel_uf = mysqli_fetch_array($sel_uf)){
$estado_cli_conv = $res_sel_uf[0];
}
}
/****** Configurações do e-mail de retorno ******/
$sql_d_emp = mysqli_query($config, "SELECT empresa, cep, cidade, estado, endereco, numero, bairro, complemento, rede_social_1, rede_social_2, rede_social_3, rede_social_4, rede_social_5, rede_social_6, imagem, cor_topo, cor_rodape, texto, titulo FROM tb_email_home") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_d_emp) <= '0'){
echo "
<div class=\"col-lg-6\">
<div class=\"alert alert-danger\">
<strong>Erro!</strong> $erro
</div>
</div>
";
}else{
while($r_sql_d_emp = mysqli_fetch_array($sql_d_emp)){
$empresa_sel = $r_sql_d_emp[0];
$cep_sel = $r_sql_d_emp[1];
$cidade_sel = $r_sql_d_emp[2];
$estado_sel = $r_sql_d_emp[3];
$endereco_sel = $r_sql_d_emp[4];
$numero_sel = $r_sql_d_emp[5];
$bairro_sel = $r_sql_d_emp[6];
$complemento_sel = $r_sql_d_emp[7];
$rede_social_1_sel = $r_sql_d_emp[8];
$rede_social_2_sel = $r_sql_d_emp[9];
$rede_social_3_sel = $r_sql_d_emp[10];
$rede_social_4_sel = $r_sql_d_emp[11];
$rede_social_5_sel = $r_sql_d_emp[12];
$rede_social_6_sel = $r_sql_d_emp[13];
$logo_sel = $r_sql_d_emp[14];
$cor_topo_sel = $r_sql_d_emp[15];
$cor_rodape_sel = $r_sql_d_emp[16];
$texto_sel = $r_sql_d_emp[17];
$titulo_sel = $r_sql_d_emp[18];
}
}
/****** Configurações do e-mail de retorno ******/
$sql_config = mysqli_query($config, "SELECT email_form, email_form_senha, conexao_segura, serv_saida_smtp, porta_smtp, site FROM tb_configuracoes") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_config) <= '0'){
echo "<p>$info</p>";
}else{
while($r_sql_config = mysqli_fetch_array($sql_config)){
$email_formulario = $r_sql_config[0];
$email_formulario_senha = $r_sql_config[1];
$metodo_criptografia = $r_sql_config[2];
$servidor_saida_smtp = $r_sql_config[3];
$porta_smtp = $r_sql_config[4];
$site_sel = $r_sql_config[5];
}
}
$contagem = strripos($site_sel, "//");
$site_link = substr($site_sel, $contagem + 2);
/****** Configurações gerais ******/
/****** E-mails dos destinatários ******/
$sql_email_dest = mysqli_query($config, "SELECT email FROM tb_email_home_email WHERE id_item = '1'") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_email_dest) <= '0'){
echo "";
}else{
while($r_sql_email_dest = mysqli_fetch_array($sql_email_dest)){
$email_email_home_sel[] = $r_sql_email_dest[0];
}
}
/****** E-mails dos destinatários ******/
include("php/phpmailer/PHPMailerAutoload.php");
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = $servidor_saida_smtp; // Endereço do servidor SMTP
$mail->SMTPAuth = true; // Requer autenticação?
$mail->Username = $email_formulario; // Usuário SMTP
$mail->Password = $email_formulario_senha; // Senha do usuário SMTP
$mail->SMTPSecure = $metodo_criptografia; // Tipo de comunicação segura
$mail->Port = $porta_smtp; // Porta do SMTP
$mail->From = $email_formulario; // E-mail do remetente
$mail->FromName = "Contato - " . $empresa_sel; // Nome do remetente
// ERRO AQUI
foreach($email_email_home_sel as $email_contato){
$mail->AddAddress($email_contato); // E-mail do destinatário
}
$mail->SetLanguage("br", "libs/"); // Linguagem
$mail->CharSet = 'UTF-8';
$mail->IsHTML(true);
$mail->Subject = $assunto;
$mail->Body = '
<!doctype html>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">
<head>
<!-- NAME: FOLLOW UP -->
<!--[if gte mso 15]>
<xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
<o:PixelsPerInch>96</o:PixelsPerInch>
</o:OfficeDocumentSettings>
</xml>
<![endif]-->
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>'.$empresa_sel.'</title>
<style type="text/css">
p{
margin:10px 0;
padding:0;
}
table{
border-collapse:collapse;
}
h1,h2,h3,h4,h5,h6{
display:block;
margin:0;
padding:0;
}
img,a img{
border:0;
height:auto;
outline:none;
text-decoration:none;
}
body,#bodyTable,#bodyCell{
height:100%;
margin:0;
padding:0;
width:100%;
}
#outlook a{
padding:0;
}
img{
-ms-interpolation-mode:bicubic;
}
table{
mso-table-lspace:0pt;
mso-table-rspace:0pt;
}
.ReadMsgBody{
width:100%;
}
.ExternalClass{
width:100%;
}
p,a,li,td,blockquote{
mso-line-height-rule:exactly;
}
a[href^=tel],a[href^=sms]{
color:inherit;
cursor:default;
text-decoration:none;
}
p,a,li,td,body,table,blockquote{
-ms-text-size-adjust:100%;
-webkit-text-size-adjust:100%;
}
.ExternalClass,.ExternalClass p,.ExternalClass td,.ExternalClass div,.ExternalClass span,.ExternalClass font{
line-height:100%;
}
a[x-apple-data-detectors]{
color:inherit !important;
text-decoration:none !important;
font-size:inherit !important;
font-family:inherit !important;
font-weight:inherit !important;
line-height:inherit !important;
}
.templateContainer{
max-width:600px !important;
}
a.mcnButton{
display:block;
}
.mcnImage{
vertical-align:bottom;
}
.mcnTextContent{
word-break:break-word;
}
.mcnTextContent img{
height:auto !important;
}
.mcnDividerBlock{
table-layout:fixed !important;
}
/*
@tab Page
@section Heading 1
@style heading 1
*/
h1{
/*@editable*/color:#222222;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:40px;
/*@editable*/font-style:normal;
/*@editable*/font-weight:bold;
/*@editable*/line-height:150%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:center;
}
/*
@tab Page
@section Heading 2
@style heading 2
*/
h2{
/*@editable*/color:#222222;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:34px;
/*@editable*/font-style:normal;
/*@editable*/font-weight:bold;
/*@editable*/line-height:88%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:left;
}
/*
@tab Page
@section Heading 3
@style heading 3
*/
h3{
/*@editable*/color:#000000;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:22px;
/*@editable*/font-style:normal;
/*@editable*/font-weight:bold;
/*@editable*/line-height:150%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:center;
}
/*
@tab Page
@section Heading 4
@style heading 4
*/
h4{
/*@editable*/color:#999999;
/*@editable*/font-family:Georgia;
/*@editable*/font-size:20px;
/*@editable*/font-style:italic;
/*@editable*/font-weight:normal;
/*@editable*/line-height:125%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:left;
}
/*
@tab Header
@section Header Container Style
*/
#templateHeader{
/*@editable*/ /* header */
/*@editable*/background: #'.$cor_topo_sel.'; /* For browsers that do not support gradients */
/*@editable*//*background: linear-gradient(to bottom right, #1a2980, #26d0cd); /* Standard syntax (must be last) */
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:9px;
/*@editable*/padding-bottom:9px;
}
/*
@tab Header
@section Header Interior Style
*/
.headerContainer{
/*@editable*/background-color:transparent;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0;
/*@editable*/padding-bottom:0;
}
/*
@tab Header
@section Header Text
*/
.headerContainer .mcnTextContent,.headerContainer .mcnTextContent p{
/*@editable*/color:#000000;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:16px;
/*@editable*/line-height:150%;
/*@editable*/text-align:left;
}
/*
@tab Header
@section Header Link
*/
.headerContainer .mcnTextContent a,.headerContainer .mcnTextContent p a{
/*@editable*/color:#00ADD8;
/*@editable*/font-weight:normal;
/*@editable*/text-decoration:underline;
}
/*
@tab Body
@section Body Container Style
*/
#templateBody{
/*@editable*/background-color:#FFFFFF;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:21px;
/*@editable*/padding-bottom:21px;
}
/*
@tab Body
@section Body Interior Style
*/
.bodyContainer{
/*@editable*/background-color:transparent;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0;
/*@editable*/padding-bottom:0;
}
/*
@tab Body
@section Body Text
*/
.bodyContainer .mcnTextContent,.bodyContainer .mcnTextContent p{
/*@editable*/color:#000000;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:16px;
/*@editable*/line-height:150%;
/*@editable*/text-align:left;
}
/*
@tab Body
@section Body Link
*/
.bodyContainer .mcnTextContent a,.bodyContainer .mcnTextContent p a{
/*@editable*/color:#00ADD8;
/*@editable*/font-weight:normal;
/*@editable*/text-decoration:underline;
}
/*
@tab Footer
@section Footer Style
*/
#templateFooter{
/*@editable*/ /* Rodapé */
background: #'.$cor_rodape_sel.'; /* For browsers that do not support gradients */
/* background: linear-gradient(to bottom right, #1a2980, #26d0cd); /* Standard syntax (must be last) */
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0px;
/*@editable*/padding-bottom:0px;
}
/*
@tab Footer
@section Footer Interior Style
*/
.footerContainer{
/*@editable*/background-color:transparent;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0;
/*@editable*/padding-bottom:0;
}
/*
@tab Footer
@section Footer Text
*/
.footerContainer .mcnTextContent,.footerContainer .mcnTextContent p{
/*@editable*/color:#FFFFFF;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:12px;
/*@editable*/line-height:150%;
/*@editable*/text-align:center;
}
/*
@tab Footer
@section Footer Link
*/
.footerContainer .mcnTextContent a,.footerContainer .mcnTextContent p a{
/*@editable*/color:#FFFFFF;
/*@editable*/font-weight:normal;
/*@editable*/text-decoration:underline;
}
@media only screen and (min-width:768px){
.templateContainer{
width:600px !important;
}
} @media only screen and (max-width: 480px){
body,table,td,p,a,li,blockquote{
-webkit-text-size-adjust:none !important;
}
} @media only screen and (max-width: 480px){
body{
width:100% !important;
min-width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnImage{
width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnCartContainer,.mcnCaptionTopContent,.mcnRecContentContainer,.mcnCaptionBottomContent,.mcnTextContentContainer,.mcnBoxedTextContentContainer,.mcnImageGroupContentContainer,.mcnCaptionLeftTextContentContainer,.mcnCaptionRightTextContentContainer,.mcnCaptionLeftImageContentContainer,.mcnCaptionRightImageContentContainer,.mcnImageCardLeftTextContentContainer,.mcnImageCardRightTextContentContainer{
max-width:100% !important;
width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnBoxedTextContentContainer{
min-width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnImageGroupContent{
padding:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnCaptionLeftContentOuter .mcnTextContent,.mcnCaptionRightContentOuter .mcnTextContent{
padding-top:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageCardTopImageContent,.mcnCaptionBlockInner .mcnCaptionTopContent:last-child .mcnTextContent{
padding-top:18px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageCardBottomImageContent{
padding-bottom:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageGroupBlockInner{
padding-top:0 !important;
padding-bottom:0 !important;
}
} @media only screen and (max-width: 480px){
.mcnImageGroupBlockOuter{
padding-top:9px !important;
padding-bottom:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnTextContent,.mcnBoxedTextContentColumn{
padding-right:18px !important;
padding-left:18px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageCardLeftImageContent,.mcnImageCardRightImageContent{
padding-right:18px !important;
padding-bottom:0 !important;
padding-left:18px !important;
}
} @media only screen and (max-width: 480px){
.mcpreview-image-uploader{
display:none !important;
width:100% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 1
@tip Make the first-level headings larger in size for better readability on small screens.
*/
h1{
/*@editable*/font-size:30px !important;
/*@editable*/line-height:125% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 2
@tip Make the second-level headings larger in size for better readability on small screens.
*/
h2{
/*@editable*/font-size:26px !important;
/*@editable*/line-height:125% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 3
@tip Make the third-level headings larger in size for better readability on small screens.
*/
h3{
/*@editable*/font-size:20px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 4
@tip Make the fourth-level headings larger in size for better readability on small screens.
*/
h4{
/*@editable*/font-size:18px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Boxed Text
@tip Make the boxed text larger in size for better readability on small screens. We recommend a font size of at least 16px.
*/
.mcnBoxedTextContentContainer .mcnTextContent,.mcnBoxedTextContentContainer .mcnTextContent p{
/*@editable*/font-size:14px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Header Text
@tip Make the header text larger in size for better readability on small screens.
*/
.headerContainer .mcnTextContent,.headerContainer .mcnTextContent p{
/*@editable*/font-size:16px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Body Text
@tip Make the body text larger in size for better readability on small screens. We recommend a font size of at least 16px.
*/
.bodyContainer .mcnTextContent,.bodyContainer .mcnTextContent p{
/*@editable*/font-size:16px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Footer Text
@tip Make the footer content text larger in size for better readability on small screens.
*/
.footerContainer .mcnTextContent,.footerContainer .mcnTextContent p{
/*@editable*/font-size:14px !important;
/*@editable*/line-height:150% !important;
}
}
</style>
</head>
<body>
<center>
<table align="center" border="0" cellpadding="0" cellspacing="0" height="100%" width="100%" id="bodyTable">
<tr>
<td align="center" valign="top" id="bodyCell">
<!-- BEGIN TEMPLATE // -->
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="center" valign="top" id="templateHeader" data-template-container>
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="600" style="width:600px;">
<tr>
<td align="center" valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%" class="templateContainer">
<tr>
<td valign="top" class="headerContainer"><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
<tbody class="mcnTextBlockOuter">
<tr>
<td valign="top" class="mcnTextBlockInner" style="padding-top:9px;">
<!--[if mso]>
<table align="left" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100%;">
<tr>
<![endif]-->
<!--[if mso]>
<td valign="top" width="300" style="width:300px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:300px;" width="100%" class="mcnTextContentContainer">
<tbody><tr>
<td valign="top" class="mcnTextContent" style="padding: 0px 18px 9px; line-height: 100%;">
<h4 class="null"><img data-file-id="20865" height="39" src="'.$site_sel.'/images/email/'.$logo_sel.'" style="border: 0px; height: 39px; margin: 3% 0 0 0;" width="196"></h4>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
<td valign="top" width="300" style="width:300px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:300px;" width="100%" class="mcnTextContentContainer">
<tbody><tr>
<td valign="top" class="mcnTextContent" style="padding: 16px 18px 9px; line-height: 100%;">
<h2 class="mc-toc-title" style="text-align: left;"><span style="font-size:25px"><span style="color:#ffffff; text-transform: uppercase;"><strong>'.$titulo_sel.'</strong></span></span></h2>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table></td>
</tr>
</table>
<!--[if gte mso 9]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
<tr>
<td align="center" valign="top" id="templateBody" data-template-container>
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="600" style="width:600px;">
<tr>
<td align="center" valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%" class="templateContainer">
<tr>
<td valign="top" class="bodyContainer"><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width: 100%; padding: 18px 18px 0px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
<tbody class="mcnTextBlockOuter">
<tr>
<td valign="top" class="mcnTextBlockInner" style="padding-top:9px;">
<!--[if mso]>
<table align="left" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100%;">
<tr>
<![endif]-->
<!--[if mso]>
<td valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:100%; min-width:100%;" width="100%" class="mcnTextContentContainer">
<tbody>
<tr>
<td valign="top" class="mcnTextContent" style="padding-top:0; padding-right:18px; padding-bottom:9px; padding-left:18px;">
<p>
<span style="font-size:18px">
<i>Enviado por</i>:<br /><br />
Nome: '.$nome.'<br />
E-mail: '.$email.'<br />
Telefone: '.$telefone.'<br />
Cidade: '.$cidade_cli_conv.' - '.$estado_cli_conv.'<br />
Como nos encontrou? '.$pesquisa.'<br /><br />
<u>Mensagem</u>: '.$mensagem.'<br /><br />
Enviado em: '.$data.', às '.$hora.'
</span>
<br /><br />
</p>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width: 100%; padding: 9px 18px 0px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width: 100%; padding: 18px 18px 0px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnBoxedTextBlock" style="min-width:100%;">
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="100%">
<![endif]-->
<tbody class="mcnBoxedTextBlockOuter">
<tr>
<td valign="top" class="mcnBoxedTextBlockInner">
<!--[if gte mso 9]>
<td align="center" valign="top" ">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;" class="mcnBoxedTextContentContainer">
<tbody>
<tr>
<td style="padding-top:9px; padding-left:18px; padding-bottom:9px; padding-right:18px;">
<table border="0" cellpadding="18" cellspacing="0" class="mcnTextContentContainer" width="100%" style="min-width: 100% !important;background-color: #F7F7F7;">
<tbody>
<tr>
<td valign="top" class="mcnTextContent" style="color: #000000;font-family: Helvetica;font-size: 16px;line-height: 200%;text-align: center;">
<h3 style="text-align: left;">'.$empresa_sel.'</h3>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<!--[if gte mso 9]>
</td>
<![endif]-->
<!--[if gte mso 9]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table></td>
</tr>
</table>
<!--[if gte mso 9]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
<tr>
<td align="center" valign="top" id="templateFooter" data-template-container>
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="600" style="width:600px;">
<tr>
<td align="center" valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%" class="templateContainer">
<tr>
<td valign="top" class="footerContainer"><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnFollowBlock" style="min-width:100%;">
<tbody class="mcnFollowBlockOuter">
<tr>
<td align="center" valign="top" style="padding:9px" class="mcnFollowBlockInner">
<!--[if gte mso 9]>
<td align="center" valign="top" ">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;" class="mcnBoxedTextContentContainer">
<tbody>
<tr>
<td style="padding-top:9px; padding-left:18px; padding-bottom:9px; padding-right:18px;">
<table border="0" cellpadding="18" cellspacing="0" class="mcnTextContentContainer" width="100%" style="min-width: 100% !important;">
<tbody>
<tr>
<td valign="top" class="mcnTextContent" style="color: #FFFFFF;font-family: Helvetica;font-size: 14px;line-height: 200%;text-align: center;">
<a href="'.$titulo_sel.'" style="text-decoration: none;"><h3 style="color: #FFFFFF; ">'.$site_link.'</h3></a>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<!--[if gte mso 9]>
</td>
<![endif]-->
<table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnFollowContentContainer" style="min-width:100%;">
<tbody><tr>
<td align="center" style="padding-left:9px;padding-right:9px;">
<table border="0" cellpadding="0" cellspacing="0" class="mcnFollowContent">
<tbody><tr>
<td align="center" valign="top" style="padding-top:9px; padding-right:9px; padding-left:9px;">
<table align="center" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td align="center" valign="top">
<!--[if mso]>
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<![endif]-->
';
if(!empty($rede_social_1_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_1_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/facebook.png" alt="Facebook" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_2_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_2_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/instagram.png" alt="Instagram" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_3_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_3_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/linkedin.png" alt="Linkedin" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_4_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_4_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/twitter.png" alt="Twitter" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_5_sel)){
'
$mail->Body .=
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_5_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/google-plus.png" alt="Google Plus" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_6_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_6_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/youtube.png" alt="Youtube" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
$mail->Body .=
'
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width:100%; padding:18px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width: 100%;border-top: 2px solid #FFFFFF;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
<tbody class="mcnTextBlockOuter">
<tr>
<td valign="top" class="mcnTextBlockInner" style="padding-top:9px;">
<!--[if mso]>
<table align="left" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100%;">
<tr>
<![endif]-->
<!--[if mso]>
<td valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:100%; min-width:100%;" width="100%" class="mcnTextContentContainer">
<tbody><tr>
<td valign="top" class="mcnTextContent" style="padding-top:0; padding-right:18px; padding-bottom:9px; padding-left:18px;">
<em>
';
if(!empty($complemento_sel)){
$mail->Body .=
'
'.$endereco_sel . " | " . $numero_sel . " | " . $complemento_sel . " | " . $bairro_sel . " | " . $cidade_sel . " | " . $estado_sel.'
';
}else{
$mail->Body .=
'
'.$endereco_sel . " | " . $numero_sel . " | " . $bairro_sel . " | " . $cidade_sel . " | " . $estado_sel.'
';
}
$mail->Body .=
'
<br />
';
$sql_tel_emp = mysqli_query($config, "SELECT telefone FROM tb_email_home_telefone WHERE id_item = '1'") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_tel_emp) <= '0'){
echo "";
}else{
$y_info = 1;
$allRows_info = mysqli_num_rows($sql_tel_emp);
while($r_sql_tel_emp = mysqli_fetch_array($sql_tel_emp)){
if ($allRows_info == $y_info) {
$x_info = 1;
} else {
$x_info = 2;
}
$y_info++;
if ($y_info == 2) {
$mail->Body .=
'
'.$telefone_email_home_sel = $r_sql_tel_emp[0] . " | ".'
';
}else{
$mail->Body .=
'
'.$telefone_email_home_sel = $r_sql_tel_emp[0].'
';
}
}
}
$mail->Body .=
'
</em>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table></td>
</tr>
</table>
<!--[if gte mso 9]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
</table>
<!-- // END TEMPLATE -->
</td>
</tr>
</table>
</center>
</body>
</html>
';
if(!$mail->Send()){
echo $exibir_apos_nao_enviar;
}else{
$mail->ClearAddresses();
$mail->SetLanguage("br", "libs/"); // Linguagem
$mail->From = $email_formulario; // E-mail do remetente
$mail->FromName = "Contato - " . $empresa_sel; // Nome do remetente
$mail->Subject = "Recebemos sua mensagem";
$mail->IsHTML(true);
$mail->Body = ' <html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office">
<head>
<!-- NAME: FOLLOW UP -->
<!--[if gte mso 15]>
<xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
<o:PixelsPerInch>96</o:PixelsPerInch>
</o:OfficeDocumentSettings>
</xml>
<![endif]-->
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>'.$empresa_sel.'</title>
<style type="text/css">
p{
margin:10px 0;
padding:0;
}
table{
border-collapse:collapse;
}
h1,h2,h3,h4,h5,h6{
display:block;
margin:0;
padding:0;
}
img,a img{
border:0;
height:auto;
outline:none;
text-decoration:none;
}
body,#bodyTable,#bodyCell{
height:100%;
margin:0;
padding:0;
width:100%;
}
#outlook a{
padding:0;
}
img{
-ms-interpolation-mode:bicubic;
}
table{
mso-table-lspace:0pt;
mso-table-rspace:0pt;
}
.ReadMsgBody{
width:100%;
}
.ExternalClass{
width:100%;
}
p,a,li,td,blockquote{
mso-line-height-rule:exactly;
}
a[href^=tel],a[href^=sms]{
color:inherit;
cursor:default;
text-decoration:none;
}
p,a,li,td,body,table,blockquote{
-ms-text-size-adjust:100%;
-webkit-text-size-adjust:100%;
}
.ExternalClass,.ExternalClass p,.ExternalClass td,.ExternalClass div,.ExternalClass span,.ExternalClass font{
line-height:100%;
}
a[x-apple-data-detectors]{
color:inherit !important;
text-decoration:none !important;
font-size:inherit !important;
font-family:inherit !important;
font-weight:inherit !important;
line-height:inherit !important;
}
.templateContainer{
max-width:600px !important;
}
a.mcnButton{
display:block;
}
.mcnImage{
vertical-align:bottom;
}
.mcnTextContent{
word-break:break-word;
}
.mcnTextContent img{
height:auto !important;
}
.mcnDividerBlock{
table-layout:fixed !important;
}
/*
@tab Page
@section Heading 1
@style heading 1
*/
h1{
/*@editable*/color:#222222;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:40px;
/*@editable*/font-style:normal;
/*@editable*/font-weight:bold;
/*@editable*/line-height:150%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:center;
}
/*
@tab Page
@section Heading 2
@style heading 2
*/
h2{
/*@editable*/color:#222222;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:34px;
/*@editable*/font-style:normal;
/*@editable*/font-weight:bold;
/*@editable*/line-height:88%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:left;
}
/*
@tab Page
@section Heading 3
@style heading 3
*/
h3{
/*@editable*/color:#000000;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:22px;
/*@editable*/font-style:normal;
/*@editable*/font-weight:bold;
/*@editable*/line-height:150%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:center;
}
/*
@tab Page
@section Heading 4
@style heading 4
*/
h4{
/*@editable*/color:#999999;
/*@editable*/font-family:Georgia;
/*@editable*/font-size:20px;
/*@editable*/font-style:italic;
/*@editable*/font-weight:normal;
/*@editable*/line-height:125%;
/*@editable*/letter-spacing:normal;
/*@editable*/text-align:left;
}
/*
@tab Header
@section Header Container Style
*/
#templateHeader{
/*@editable*/ /* header */
/*@editable*/background: #'.$cor_topo_sel.'; /* For browsers that do not support gradients */
/*@editable*//*background: linear-gradient(to bottom right, #1a2980, #26d0cd); /* Standard syntax (must be last) */
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:9px;
/*@editable*/padding-bottom:9px;
}
/*
@tab Header
@section Header Interior Style
*/
.headerContainer{
/*@editable*/background-color:transparent;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0;
/*@editable*/padding-bottom:0;
}
/*
@tab Header
@section Header Text
*/
.headerContainer .mcnTextContent,.headerContainer .mcnTextContent p{
/*@editable*/color:#000000;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:16px;
/*@editable*/line-height:150%;
/*@editable*/text-align:left;
}
/*
@tab Header
@section Header Link
*/
.headerContainer .mcnTextContent a,.headerContainer .mcnTextContent p a{
/*@editable*/color:#00ADD8;
/*@editable*/font-weight:normal;
/*@editable*/text-decoration:underline;
}
/*
@tab Body
@section Body Container Style
*/
#templateBody{
/*@editable*/background-color:#FFFFFF;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:21px;
/*@editable*/padding-bottom:21px;
}
/*
@tab Body
@section Body Interior Style
*/
.bodyContainer{
/*@editable*/background-color:transparent;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0;
/*@editable*/padding-bottom:0;
}
/*
@tab Body
@section Body Text
*/
.bodyContainer .mcnTextContent,.bodyContainer .mcnTextContent p{
/*@editable*/color:#000000;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:16px;
/*@editable*/line-height:150%;
/*@editable*/text-align:left;
}
/*
@tab Body
@section Body Link
*/
.bodyContainer .mcnTextContent a,.bodyContainer .mcnTextContent p a{
/*@editable*/color:#00ADD8;
/*@editable*/font-weight:normal;
/*@editable*/text-decoration:underline;
}
/*
@tab Footer
@section Footer Style
*/
#templateFooter{
/*@editable*/ /* Rodapé */
background: #'.$cor_rodape_sel.'; /* For browsers that do not support gradients */
/* background: linear-gradient(to bottom right, #1a2980, #26d0cd); /* Standard syntax (must be last) */
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0px;
/*@editable*/padding-bottom:0px;
}
/*
@tab Footer
@section Footer Interior Style
*/
.footerContainer{
/*@editable*/background-color:transparent;
/*@editable*/background-image:none;
/*@editable*/background-repeat:no-repeat;
/*@editable*/background-position:center;
/*@editable*/background-size:cover;
/*@editable*/border-top:0;
/*@editable*/border-bottom:0;
/*@editable*/padding-top:0;
/*@editable*/padding-bottom:0;
}
/*
@tab Footer
@section Footer Text
*/
.footerContainer .mcnTextContent,.footerContainer .mcnTextContent p{
/*@editable*/color:#FFFFFF;
/*@editable*/font-family:Helvetica;
/*@editable*/font-size:12px;
/*@editable*/line-height:150%;
/*@editable*/text-align:center;
}
/*
@tab Footer
@section Footer Link
*/
.footerContainer .mcnTextContent a,.footerContainer .mcnTextContent p a{
/*@editable*/color:#FFFFFF;
/*@editable*/font-weight:normal;
/*@editable*/text-decoration:underline;
}
@media only screen and (min-width:768px){
.templateContainer{
width:600px !important;
}
} @media only screen and (max-width: 480px){
body,table,td,p,a,li,blockquote{
-webkit-text-size-adjust:none !important;
}
} @media only screen and (max-width: 480px){
body{
width:100% !important;
min-width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnImage{
width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnCartContainer,.mcnCaptionTopContent,.mcnRecContentContainer,.mcnCaptionBottomContent,.mcnTextContentContainer,.mcnBoxedTextContentContainer,.mcnImageGroupContentContainer,.mcnCaptionLeftTextContentContainer,.mcnCaptionRightTextContentContainer,.mcnCaptionLeftImageContentContainer,.mcnCaptionRightImageContentContainer,.mcnImageCardLeftTextContentContainer,.mcnImageCardRightTextContentContainer{
max-width:100% !important;
width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnBoxedTextContentContainer{
min-width:100% !important;
}
} @media only screen and (max-width: 480px){
.mcnImageGroupContent{
padding:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnCaptionLeftContentOuter .mcnTextContent,.mcnCaptionRightContentOuter .mcnTextContent{
padding-top:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageCardTopImageContent,.mcnCaptionBlockInner .mcnCaptionTopContent:last-child .mcnTextContent{
padding-top:18px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageCardBottomImageContent{
padding-bottom:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageGroupBlockInner{
padding-top:0 !important;
padding-bottom:0 !important;
}
} @media only screen and (max-width: 480px){
.mcnImageGroupBlockOuter{
padding-top:9px !important;
padding-bottom:9px !important;
}
} @media only screen and (max-width: 480px){
.mcnTextContent,.mcnBoxedTextContentColumn{
padding-right:18px !important;
padding-left:18px !important;
}
} @media only screen and (max-width: 480px){
.mcnImageCardLeftImageContent,.mcnImageCardRightImageContent{
padding-right:18px !important;
padding-bottom:0 !important;
padding-left:18px !important;
}
} @media only screen and (max-width: 480px){
.mcpreview-image-uploader{
display:none !important;
width:100% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 1
@tip Make the first-level headings larger in size for better readability on small screens.
*/
h1{
/*@editable*/font-size:30px !important;
/*@editable*/line-height:125% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 2
@tip Make the second-level headings larger in size for better readability on small screens.
*/
h2{
/*@editable*/font-size:26px !important;
/*@editable*/line-height:125% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 3
@tip Make the third-level headings larger in size for better readability on small screens.
*/
h3{
/*@editable*/font-size:20px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Heading 4
@tip Make the fourth-level headings larger in size for better readability on small screens.
*/
h4{
/*@editable*/font-size:18px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Boxed Text
@tip Make the boxed text larger in size for better readability on small screens. We recommend a font size of at least 16px.
*/
.mcnBoxedTextContentContainer .mcnTextContent,.mcnBoxedTextContentContainer .mcnTextContent p{
/*@editable*/font-size:14px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Header Text
@tip Make the header text larger in size for better readability on small screens.
*/
.headerContainer .mcnTextContent,.headerContainer .mcnTextContent p{
/*@editable*/font-size:16px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Body Text
@tip Make the body text larger in size for better readability on small screens. We recommend a font size of at least 16px.
*/
.bodyContainer .mcnTextContent,.bodyContainer .mcnTextContent p{
/*@editable*/font-size:16px !important;
/*@editable*/line-height:150% !important;
}
} @media only screen and (max-width: 480px){
/*
@tab Mobile Styles
@section Footer Text
@tip Make the footer content text larger in size for better readability on small screens.
*/
.footerContainer .mcnTextContent,.footerContainer .mcnTextContent p{
/*@editable*/font-size:14px !important;
/*@editable*/line-height:150% !important;
}
}
</style>
</head>
<body>
<center>
<table align="center" border="0" cellpadding="0" cellspacing="0" height="100%" width="100%" id="bodyTable">
<tr>
<td align="center" valign="top" id="bodyCell">
<!-- BEGIN TEMPLATE // -->
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="center" valign="top" id="templateHeader" data-template-container>
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="600" style="width:600px;">
<tr>
<td align="center" valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%" class="templateContainer">
<tr>
<td valign="top" class="headerContainer"><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
<tbody class="mcnTextBlockOuter">
<tr>
<td valign="top" class="mcnTextBlockInner" style="padding-top:9px;">
<!--[if mso]>
<table align="left" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100%;">
<tr>
<![endif]-->
<!--[if mso]>
<td valign="top" width="300" style="width:300px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:300px;" width="100%" class="mcnTextContentContainer">
<tbody><tr>
<td valign="top" class="mcnTextContent" style="padding: 0px 18px 9px; line-height: 100%;">
<h4 class="null"><img data-file-id="20865" height="39" src="'.$site_sel.'/images/email/'.$logo_sel.'" style="border: 0px; height: 39px; margin: 3% 0 0 0;" width="196"></h4>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
<td valign="top" width="300" style="width:300px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:300px;" width="100%" class="mcnTextContentContainer">
<tbody><tr>
<td valign="top" class="mcnTextContent" style="padding: 16px 18px 9px; line-height: 100%;">
<h2 class="mc-toc-title" style="text-align: left;"><span style="font-size:25px"><span style="color:#ffffff; text-transform: uppercase;"><strong>'.$titulo_sel.'</strong></span></span></h2>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table></td>
</tr>
</table>
<!--[if gte mso 9]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
<tr>
<td align="center" valign="top" id="templateBody" data-template-container>
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="600" style="width:600px;">
<tr>
<td align="center" valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%" class="templateContainer">
<tr>
<td valign="top" class="bodyContainer"><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width: 100%; padding: 18px 18px 0px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
<tbody class="mcnTextBlockOuter">
<tr>
<td valign="top" class="mcnTextBlockInner" style="padding-top:9px;">
<!--[if mso]>
<table align="left" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100%;">
<tr>
<![endif]-->
<!--[if mso]>
<td valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:100%; min-width:100%;" width="100%" class="mcnTextContentContainer">
<tbody>
<tr>
<td valign="top" class="mcnTextContent" style="padding-top:0; padding-right:18px; padding-bottom:9px; padding-left:18px;">
<p>
<span style="font-size:18px">
Olá <strong>'.$nome.'</strong>,
<br>
<br>
'.$texto_sel.'
</span>
<br>
</p>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width: 100%; padding: 9px 18px 0px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width: 100%; padding: 18px 18px 0px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnBoxedTextBlock" style="min-width:100%;">
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="100%">
<![endif]-->
<tbody class="mcnBoxedTextBlockOuter">
<tr>
<td valign="top" class="mcnBoxedTextBlockInner">
<!--[if gte mso 9]>
<td align="center" valign="top" ">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;" class="mcnBoxedTextContentContainer">
<tbody>
<tr>
<td style="padding-top:9px; padding-left:18px; padding-bottom:9px; padding-right:18px;">
<table border="0" cellpadding="18" cellspacing="0" class="mcnTextContentContainer" width="100%" style="min-width: 100% !important;background-color: #F7F7F7;">
<tbody>
<tr>
<td valign="top" class="mcnTextContent" style="color: #000000;font-family: Helvetica;font-size: 16px;line-height: 200%;text-align: center;">
<h3 style="text-align: left;">'.$empresa_sel.'</h3>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<!--[if gte mso 9]>
</td>
<![endif]-->
<!--[if gte mso 9]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table></td>
</tr>
</table>
<!--[if gte mso 9]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
<tr>
<td align="center" valign="top" id="templateFooter" data-template-container>
<!--[if gte mso 9]>
<table align="center" border="0" cellspacing="0" cellpadding="0" width="600" style="width:600px;">
<tr>
<td align="center" valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%" class="templateContainer">
<tr>
<td valign="top" class="footerContainer"><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnFollowBlock" style="min-width:100%;">
<tbody class="mcnFollowBlockOuter">
<tr>
<td align="center" valign="top" style="padding:9px" class="mcnFollowBlockInner">
<!--[if gte mso 9]>
<td align="center" valign="top" ">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width:100%;" class="mcnBoxedTextContentContainer">
<tbody>
<tr>
<td style="padding-top:9px; padding-left:18px; padding-bottom:9px; padding-right:18px;">
<table border="0" cellpadding="18" cellspacing="0" class="mcnTextContentContainer" width="100%" style="min-width: 100% !important;">
<tbody>
<tr>
<td valign="top" class="mcnTextContent" style="color: #FFFFFF;font-family: Helvetica;font-size: 14px;line-height: 200%;text-align: center;">
<a href="'.$titulo_sel.'" style="text-decoration: none;"><h3 style="color: #FFFFFF; ">'.$site_link.'</h3></a>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<!--[if gte mso 9]>
</td>
<![endif]-->
<table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnFollowContentContainer" style="min-width:100%;">
<tbody><tr>
<td align="center" style="padding-left:9px;padding-right:9px;">
<table border="0" cellpadding="0" cellspacing="0" class="mcnFollowContent">
<tbody><tr>
<td align="center" valign="top" style="padding-top:9px; padding-right:9px; padding-left:9px;">
<table align="center" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td align="center" valign="top">
<!--[if mso]>
<table align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<![endif]-->
';
if(!empty($rede_social_1_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_1_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/facebook.png" alt="Facebook" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_2_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_2_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/instagram.png" alt="Instagram" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_3_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_3_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/linkedin.png" alt="Linkedin" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_4_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_4_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/twitter.png" alt="Twitter" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_5_sel)){
'
$mail->Body .=
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_5_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/google-plus.png" alt="Google Plus" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
if(!empty($rede_social_6_sel)){
$mail->Body .=
'
<!--[if mso]>
<td align="center" valign="top">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" class="mcnFollowStacked" style="display:inline;">
<tbody>
<tr>
<td align="center" valign="top" class="mcnFollowIconContent" style="padding-right:10px; padding-bottom:9px;">
<a href="'.$rede_social_6_sel.'" target="_blank"><img src="'.$site_sel.'/images/email/youtube.png" alt="Youtube" class="mcnFollowBlockIcon" width="48" style="width:48px; max-width:48px; display:block;"></a>
</td>
</tr>
</tbody>
</table>
<!--[if mso]>
</td>
<![endif]-->
';
}
$mail->Body .=
'
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>
</td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnDividerBlock" style="min-width:100%;">
<tbody class="mcnDividerBlockOuter">
<tr>
<td class="mcnDividerBlockInner" style="min-width:100%; padding:18px;">
<table class="mcnDividerContent" border="0" cellpadding="0" cellspacing="0" width="100%" style="min-width: 100%;border-top: 2px solid #FFFFFF;">
<tbody><tr>
<td>
<span></span>
</td>
</tr>
</tbody></table> <td class="mcnDividerBlockInner" style="padding: 18px;">
<hr class="mcnDividerContent" style="border-bottom-color:none; border-left-color:none; border-right-color:none; border-bottom-width:0; border-left-width:0; border-right-width:0; margin-top:0; margin-right:0; margin-bottom:0; margin-left:0;" /> </td>
</tr>
</tbody>
</table><table border="0" cellpadding="0" cellspacing="0" width="100%" class="mcnTextBlock" style="min-width:100%;">
<tbody class="mcnTextBlockOuter">
<tr>
<td valign="top" class="mcnTextBlockInner" style="padding-top:9px;">
<!--[if mso]>
<table align="left" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100%;">
<tr>
<![endif]-->
<!--[if mso]>
<td valign="top" width="600" style="width:600px;">
<![endif]-->
<table align="left" border="0" cellpadding="0" cellspacing="0" style="max-width:100%; min-width:100%;" width="100%" class="mcnTextContentContainer">
<tbody><tr>
<td valign="top" class="mcnTextContent" style="padding-top:0; padding-right:18px; padding-bottom:9px; padding-left:18px;">
<em>
';
if(!empty($complemento_sel)){
$mail->Body .=
'
'.$endereco_sel . " | " . $numero_sel . " | " . $complemento_sel . " | " . $bairro_sel . " | " . $cidade_sel . " | " . $estado_sel.'
';
}else{
$mail->Body .=
'
'.$endereco_sel . " | " . $numero_sel . " | " . $bairro_sel . " | " . $cidade_sel . " | " . $estado_sel.'
';
}
$mail->Body .=
'
<br />
';
$sql_tel_emp = mysqli_query($config, "SELECT telefone FROM tb_email_home_telefone WHERE id_item = '1'") or die(mysqli_error($config));
if(@mysqli_num_rows($sql_tel_emp) <= '0'){
echo "";
}else{
$y_info = 1;
$allRows_info = mysqli_num_rows($sql_tel_emp);
while($r_sql_tel_emp = mysqli_fetch_array($sql_tel_emp)){
if ($allRows_info == $y_info) {
$x_info = 1;
} else {
$x_info = 2;
}
$y_info++;
if ($y_info == 2) {
$mail->Body .=
'
'.$telefone_email_home_sel = $r_sql_tel_emp[0] . " | ".'
';
}else{
$mail->Body .=
'
'.$telefone_email_home_sel = $r_sql_tel_emp[0].'
';
}
}
}
$mail->Body .=
'
</em>
</td>
</tr>
</tbody></table>
<!--[if mso]>
</td>
<![endif]-->
<!--[if mso]>
</tr>
</table>
<![endif]-->
</td>
</tr>
</tbody>
</table></td>
</tr>
</table>
<!--[if gte mso 9]>
</td>
</tr>
</table>
<![endif]-->
</td>
</tr>
</table>
<!-- // END TEMPLATE -->
</td>
</tr>
</table>
</center>
</body>
</html>
';
$mail->AddAddress($email);
if($mail->Send()){
/******************************** Salvar e-mails ********************************/
$salvar_emails = mysqli_query($config, "INSERT INTO tb_emails (nome, email, fone, cidade, estado, pesquisa, mensagem, data_cadastro) VALUES ('$nome', '$email', '$telefone', '$cidade_cli', '$estado_cli', '$pesquisa', '$mensagem', '$data_email')") or die(mysqli_error($config));
if($salvar_emails >= '1'){
echo $exibir_apos_enviar;
}else{
echo "<div class=\"erro\">Erro no sistema</div>";
}
/******************************** Salvar e-mails ********************************/
}else{
echo $exibir_apos_nao_enviar;
}
}
}else{
echo $exibir_apos_enviar;
}
}
}
Coloquei uma marcação "// ERRO AQUI" no código.
Obrigado!
O mais provável que é que a variável $email_email_home_sel esteja chegando vazia no foreach.
Dê um var_dump logo antes do foreach na variável.