Witam!
tworzę prosty plik xls za pomocą PHP:
/*******EDIT LINES 3-8*******/
$DB_Server = "xxx"; //MySQL Server
$DB_Username = "xxx"; //MySQL Username
$DB_Password = "****"; //MySQL Password
$DB_DBName = "xxx"; //MySQL Database Name
$DB_TBLName = "xxx"; //MySQL Table Name
$filename = "plikxls"; //File Name
/*******YOU DO NOT NEED TO EDIT ANYTHING BELOW THIS LINE*******/
//create MySQL connection
$sql = "Select * from $DB_TBLName";
//select database
//execute query
$file_ending = "xls";
//header info for browser
header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=$filename.xls"); /*******Start of Formatting for Excel*******/
//define separator (defines columns in excel & tabs in word)
$sep = "\t"; //tabbed character
//start of printing column names as names of MySQL fields
}
//end of printing column names
//start while loop to get data
{
$schema_insert = "";
for($j=0; $j<mysql_num_fields($result);$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("/\r\n|\n\r|\n|\r/", " ", $schema_insert); $schema_insert .= "\I";
}
chciałbym go zapisać na serwerze, aby go dołączyć jako załącznik do email-a, jak mam to zrobić. Teraz mi się po prostu pobiera.
Umiem takie cuda robić z pdf, ale tu poległem......