Powered By Blogger

Tuesday, June 10, 2014

Read data from MYSQL database and send mail

<?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 ="";
  }
}
?>

No comments:

Post a Comment