<?php
$DB_Server = "localhost";
$DB_Username = "root";
$DB_Password = "bnm6qaz5mlp7tyu";
$DB_DBName = "innomobile";
$DB_TBLName = "wp_cf7dbplugin_submits";
$filename = "contact-info-DB"; //File Name
//create MySQL connection
$sql = "Select `field_name`,`field_value` from $DB_TBLName WHERE `submit_time` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY); " ;
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
//select database
$Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
//execute query
$result = @mysql_query($sql,$Connect) or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$sep = "\t";
@$data="Name \t Email ID \t Phone Number \t Subject \t Message \n";
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=1; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif (($row[$j] != "") )
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
if (($row[0]=='your-name') || ($row[0]=='your-email') || ($row[0]=='Contact') || ($row[0]=='your-subject') || ($row[0]=='your-message') ) {
@$data .= $schema_insert;
}
if($row[0] == 'Submitted From'){
@$data .="\n";
}
}
file_put_contents("excelfile/contact-info-DB.xls",$data);
?>
$DB_Server = "localhost";
$DB_Username = "root";
$DB_Password = "bnm6qaz5mlp7tyu";
$DB_DBName = "innomobile";
$DB_TBLName = "wp_cf7dbplugin_submits";
$filename = "contact-info-DB"; //File Name
//create MySQL connection
$sql = "Select `field_name`,`field_value` from $DB_TBLName WHERE `submit_time` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY); " ;
$Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno());
//select database
$Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno());
//execute query
$result = @mysql_query($sql,$Connect) or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno());
$sep = "\t";
@$data="Name \t Email ID \t Phone Number \t Subject \t Message \n";
while($row = mysql_fetch_row($result))
{
$schema_insert = "";
for($j=1; $j<mysql_num_fields($result);$j++)
{
if(!isset($row[$j]))
$schema_insert .= "NULL".$sep;
elseif (($row[$j] != "") )
$schema_insert .= "$row[$j]".$sep;
else
$schema_insert .= "".$sep;
}
$schema_insert = str_replace($sep."$", "", $schema_insert);
$schema_insert = preg_replace("/\r\n|\n\r|\n|\r/", " ", $schema_insert);
if (($row[0]=='your-name') || ($row[0]=='your-email') || ($row[0]=='Contact') || ($row[0]=='your-subject') || ($row[0]=='your-message') ) {
@$data .= $schema_insert;
}
if($row[0] == 'Submitted From'){
@$data .="\n";
}
}
file_put_contents("excelfile/contact-info-DB.xls",$data);
?>
No comments:
Post a Comment