<?php
$To="gnanasekaran.l@innomobileapps.com";
$Sub = "auto email from contact db";
$Headers = 'MIME-Version: 1.0' . "\r\n";
$Headers .= 'Content-type: text/html; charset=iso-8859-1'."\r\n";
$Headers .= 'From:'.$To."\r\n";
$db=mysql_connect("localhost","root","mysqlpass");
mysql_select_db("innomobile",$db);
$result = mysql_query(" SELECT `submit_time`,`form_name`, `field_name`, `field_value` FROM `wp_cf7dbplugin_submits` WHERE `submit_time` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY);");
$i=0;
while ( @$row = mysql_fetch_array($result) ) {
$i++;
if ($i<6) {
@$EmailContent .= $row['field_name'] .":". $row['field_value'] ."<br />" ;
}
if($i==7){
@mail($To,$Sub,$EmailContent,$Headers);
$i=0;
$EmailContent ="";
}
}
?>
$To="gnanasekaran.l@innomobileapps.com";
$Sub = "auto email from contact db";
$Headers = 'MIME-Version: 1.0' . "\r\n";
$Headers .= 'Content-type: text/html; charset=iso-8859-1'."\r\n";
$Headers .= 'From:'.$To."\r\n";
$db=mysql_connect("localhost","root","mysqlpass");
mysql_select_db("innomobile",$db);
$result = mysql_query(" SELECT `submit_time`,`form_name`, `field_name`, `field_value` FROM `wp_cf7dbplugin_submits` WHERE `submit_time` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY);");
$i=0;
while ( @$row = mysql_fetch_array($result) ) {
$i++;
if ($i<6) {
@$EmailContent .= $row['field_name'] .":". $row['field_value'] ."<br />" ;
}
if($i==7){
@mail($To,$Sub,$EmailContent,$Headers);
$i=0;
$EmailContent ="";
}
}
?>
No comments:
Post a Comment