mysql to excel genration using php
Posted
by pmms
on Stack Overflow
See other posts from Stack Overflow
or by pmms
Published on 2010-04-26T12:59:18Z
Indexed on
2010/04/26
13:03 UTC
Read the original article
Hit count: 181
<?php
// DB Connection here
mysql_connect("localhost","root",""); mysql_select_db("hitnrunf_db");
$select = "SELECT * FROM jos_users ";
$export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) );
$fields = mysql_num_fields ( $export );
for ( $i = 0; $i < $fields; $i++ ) { $header .= mysql_field_name( $export , $i ) . "\t"; }
while( $row = mysql_fetch_row( $export ) )
{
$line = '';
foreach( $row as $value )
{
if ( ( !isset( $value ) ) || ( $value == "" ) )
{
$value = "\t";
}
else
{
$value = str_replace( '"' , '""' , $value );
$value = '"' . $value . '"' . "\t";
}
$line .= $value;
}
$data .= trim( $line ) . "\n";
}
$data = str_replace( "\r" , "" , $data );
if ( $data == "" )
{
$data = "\n(0) Records Found!\n";
}
header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=your_desired_name.xls"); header("Pragma: no-cache"); header("Expires: 0"); print "$header\n$data";
?> the above code is used for genrating mysql to excel sheet but we are getting following error
the file youare trying to open, 'users.xls',is in a different format than specified by the file extension. verify that the file is not corrupted and is from a trusted source before opening the file. do you want to open the file now?
© Stack Overflow or respective owner
