Powered By Blogger

Friday, June 13, 2014

Data from MYSQL database into excel and excel store in server side

<?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);
 
?>

No comments:

Post a Comment