MySQL to Excel

[Anon]

Hi,

How do i create a "Excel" file with the data taken from MySQL. Have you come across any such Articles or Source Code.
Any guidence is greatly appreciated.

[Anon]

One way is to take all the data from the MySQL and put it in a text file with a defined delimiter (eg ':') then import the text file into Excel.

Al

[shastry]

Hi Ajay,
try with this code..

send2Excel.php

<?php
$dbHost = "shastry.techbooks.com";
$dbUser = "umesh";
$dbPwd = "******";

if ($dbDB) {

} 
else { 
      $dbDB        =  "urDataBaseName Here"; 
} 
if ($table) {

 } 
else { 
      $table        =  "urTableName Here"; 
} 

$ExcelQuery    =  "SELECT * FROM " . $table; 

Header( "Content-Type: application/vnd.ms-excel"); 

$dbLink = mysql_connect($dbHost,$dbUser,$dbPwd); 
mysql_select_db($dbDB, $dbLink); 

$MyExcel_Result = mysql_query($ExcelQuery, $dbLink); 
$fieldcounts = mysql_num_fields($MyExcel_Result); 
for($i = 0; $i < $fieldcounts; $i++) { 
    $fieldtype = mysql_fetch_field($MyExcel_Result, $i);        
    echo  "$fieldtype->name"; 
    if ($i < ($fieldcounts-1)) 
        echo  "\t"; 
    else 
        echo  "\n"; 
} 
while ($myrow = mysql_fetch_array($MyExcel_Result)) {        
    for($i = 0; $i < $fieldcounts; $i++) { 
        $fieldname = mysql_field_name($MyExcel_Result, $i); 
        if ($i < ($fieldcounts-1)) echo $myrow[$fieldname] .  "\t"; 
            else echo $myrow[$fieldname] .  "\n";            
    } 
} 

?>

---

Hope it'll help
--Shastry