How to export in Excel format

Question

Hi! Please want to export a report to excel using php and mysql, am stock, kindly help me

Sundaram Subramanian · Answer

To make meaning column names, Take the Columns from Table with Alias Name. Eg Select first_name as FirstName, last_name as LastName from TableName

Mukil Vendhan · Answer

Just Try With The Following : PHP Part : /*******EDIT LINES 3-8*******/ $DB_Server = "localhost" ; //MySQL Server $DB_Username = "username" ; //MySQL Username $DB_Password = "password" ; //MySQL Password $DB_DBName = "databasename" ; //MySQL Database Name $DB_TBLName = "tablename" ; //MySQL Table Name $filename = "excelfilename" ; //File Name /*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/ //create MySQL connection $sql = "Select * from $DB_TBLName" ; $Connect = @mysql_connect( $DB_Server , $DB_Username , $DB_Password ) or die ( "Couldn't connect to MySQL: " . mysql_error() . " " . mysql_errno()); //select database $Db = @mysql_select_db( $DB_DBName , $Connect ) or die ( "Couldn't select database: " . mysql_error(). " " . mysql_errno()); //execute query $result = @mysql_query( $sql , $Connect ) or die ( "Couldn't execute query: " . mysql_error(). " " . mysql_errno()); $file_ending = "xls" ; //header info for browser header( "Content-Type: application/xls" ); header( "Content-Disposition: attachment; filename=$filename.xls" ); header( "Pragma: no-cache" ); header( "Expires: 0" ); /*******Start of Formatting for Excel*******/ //define separator (defines columns in excel & tabs in word) $sep = "	" ; //tabbed character //start of printing column names as names of MySQL fields for ( $i = 0; $i $result ); $i ++) { echo mysql_field_name( $result , $i ) . "	" ; } print( "
" ); //end of printing column names //start while loop to get data while ( $row = mysql_fetch_row( $result )) { $schema_insert = "" ; for ( $j =0; $j $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( "/
|
|
|/" , " " , $schema_insert ); $schema_insert .= "	" ; print(trim( $schema_insert )); print "
" ; } ?> I think this may help you to resolve your problem.

Abdulrasheed Ibrahim · Answer

Thank you Mukil Vendhan your answer work fine, but please how can I change the columns heading because in my db short words are used so in exporting I need to make it full. For example in my db I use fname instead of First Name, cd instead of Current Date. Kindly, help me through I appreciate your quick response which make me very happy. Thanks in advance.