export php page to a file (excel or pdf)

[houssam_ballout]

 

Hello,

I need help to export or create an excel file through php. The data are being collected from mysql table.

Thanks in advance

[jcbones]

I would suggest the first link

[IrOnMaSk]

is your output going to be display as webpage?

one of the best ways is do the read/write to file if you only need specific data from the table...

select the data then write it to file...

Super simple instruction here, might just do the trick

http://www.w3schools.com/php/php_file.asp

 

goodluck

[houssam_ballout]

no need to display it on webpage, just export it as a file, then send it back via php mail

 

[jcbones]

I posted a link to a tutorial that fit your request exactly.

[houssam_ballout]

well, its nice tutorial

How can I save the file to my server?

Thanks

[jcbones]

Well, you take his code snippet:

<?PHP 
   function cleanData($str) { 
      $str = preg_replace("/\t/", "\\t", $str); 
      $str = preg_replace("/\r?\n/", "\\n", $str);
    }
header("Content-Type: text/plain"); 
  $flag = false;
  foreach($data as $row) { 
     if(!$flag) { 
        # display field/column names as first row 
        echo implode("\t", array_keys($row)) . "\r\n"; 
        $flag = true; 
    } 
     array_walk($row, 'cleanData');
   echo implode("\t", array_values($row)) . "\r\n";  
  } 
?>

 

And make some changes:

<?PHP 
    function cleanData($str) { 
      $str = preg_replace("/\t/", "\\t", $str); 
      $str = preg_replace("/\r?\n/", "\\n", $str);
    }
//header("Content-Type: text/plain"); //<-lose the header function.
$filename = 'excel_export.xls';
$output = NULL; //define our holding variable.
  $flag = false;
  foreach($data as $row) { 
     if(!$flag) { 
        # display field/column names as first row 
        $output .= implode("\t", array_keys($row)) . "\r\n"; //set this row to our variable.
        $flag = true; 
    } 
    array_walk($row, 'cleanData');
   $output .= implode("\t", array_values($row)) . "\r\n";  //set this row to our variable.
  } 
file_put_contents($filename,$output);  //write the output to a file;
?>

 

[houssam_ballout]

in the array where can I put data. The data are in mysql table, when I do the while() to get the info from table, how can I add array dynamically to hold all data from that table,,

Thx

[jcbones]

Well, I guess that was on me, as I thought you knew how to populate an array from the database.  Being that I don't know your database structure, I will give you arbitrary code.

 

<?php

include 'database_connection.php';

$sql = "SELECT * FROM table";
$result = mysql_query($sql) or trigger_error($sql . ' has an error.<br/>' . mysql_error());
if(mysql_num_rows($result) > 0) {
while($row = mysql_fetch_assoc($result)) {
    $data[] = $row;
  }
}

if(!is_array($data)) {
  exit('There is no data to create an excel file from');
}

   function cleanData($str) { 
      $str = preg_replace("/\t/", "\\t", $str); 
      $str = preg_replace("/\r?\n/", "\\n", $str);
    }
//header("Content-Type: text/plain"); //<-lose the header function.
$filename = 'excel_export.xls';
$output = NULL; //define our holding variable.
  $flag = false;
  foreach($data as $row) { 
     if(!$flag) { 
        # display field/column names as first row 
        $output .= implode("\t", array_keys($row)) . "\r\n"; //set this row to our variable.
        $flag = true; 
    } 
    array_walk($row, 'cleanData');
   $output .= implode("\t", array_values($row)) . "\r\n";  //set this row to our variable.
  } 
file_put_contents($filename,$output);  //write the output to a file;
?>