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

Sundar · 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.