PHP把資料庫資料匯入Excel

標籤：

<?phpfunction xlsBOF() { echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); return;}function xlsEOF() { echo pack("ss", 0x0A, 0x00); return;}function format( $STR ){ $STR = str_replace( "\"", "", $STR ); if ( strpos( $STR, "," ) ){  $STR = "\"".$STR."\""; } $STR = iconv( "utf-8", "gb2312", $STR ); return $STR;}function xlsWriteNumber($Row, $Col, $Value) { echo pack("sssss", 0x203, 14, $Row, $Col, 0x0); echo pack("d", $Value); return;}function xlsWriteLabel($Row, $Col, $Value ) { $L = strlen($Value); echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L); echo $Value; return;}function write_excel_line($hang,$lie,$val){ if(is_numeric($val)){  xlsWriteNumber($hang,$lie,$val); }else{  xlsWriteLabel($hang,$lie,$val); }}$mktime = "message";header(‘Content-Type: text/html; charset=utf-8‘);header("Pragma: public");header("Expires: 0");header("Cache-Control: must-revalidate, post-check=0, pre-check=0");header("Content-Type: application/force-download");header("Content-Type: application/octet-stream");header("Content-Type: application/download");header("Content-Disposition: attachment;filename=$mktime.xls ");header("Content-Transfer-Encoding: binary ");// XLS Data CellxlsBOF();xlsWriteLabel(0, 0, format(‘姓名‘));xlsWriteLabel(0, 1, format(‘郵箱‘));xlsWriteLabel(0, 2, format(‘電話‘));xlsWriteLabel(0, 3, format(‘地址‘));xlsWriteLabel(0, 4, format(‘留言內容‘));xlsWriteLabel(0, 5, format(‘留言時間‘));        $conn[email protected]mysql_connect("localhost","root","")  or die(mysql_error());    @mysql_select_db(‘demo‘,$conn) or die(mysql_error());    mysql_query("SET names UTF8");    $sql = "select * from message";    $result=mysql_query($sql);    $i = 0;    while($row = mysql_fetch_array($result)) {        $i++;        write_excel_line($i, 0, $row[‘name‘]);        write_excel_line($i, 1, $row[‘email‘]);        write_excel_line($i, 2, $row[‘phone‘]);        write_excel_line($i, 3, $row[‘address‘]);        write_excel_line($i, 4, $row[‘content‘]);        write_excel_line($i, 5, $row[‘time‘]);           }    xlsEOF();exit();?>

 

PHP把資料庫資料匯入Excel