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"; $Connect = @mysql_connect($DB_Server, $DB_Username, $DB_Password) or die("Couldn't connect to MySQL:<br>" . mysql_error() . "<br>" . mysql_errno()); //select database $Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database:<br>" . mysql_error(). "<br>" . mysql_errno()); //execute query $result = @mysql_query($sql,$Connect) or die("Couldn't execute query:<br>" . mysql_error(). "<br>" . mysql_errno()); $file_ending = "xls"; //header info for browser /*******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 .= "\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......