源代码如下:<?php
include "db/dbconnect0.php";
$db = new dbclass();
header('Content-Type:text/html;charset=utf-8');
$dat = $_REQUEST['date'];
$dat = date('Y-m-d',strtotime($dat));
$sql = "select distinct ebay_products_order from ebay_order_products where ebay_products_order like '%$dat%' and status=1";
$sql = $db->execute($sql);
$sql = $db->getResultArray($sql);
$now_date = date('Y-m-d');
$file_type = "vnd.ms-excel";
$file_ending = "xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=".$dat.".$file_ending");
header("Pragma: no-cache");
header("Expires: 0");
echo "ID\tregister\tname\taddress\tDestination\tItem Weight (g) \tBuyerid\tebaycount";
print "\n";
for($i=0;$i<count($sql);$i++){
$ordersn = $sql[$i]['ebay_products_order'];
$sg = "select * from ebay_peloes where ebay_order='$ordersn'";
$sg = $db->execute($sg);
$sg = $db->getResultArray($sg);
$ebay_id = $sg[0]['ebay_id'];
$buyerid = $sg[0]['ebay_buyerid'];
@$name = iconv('utf-8','gbk',$sg[0]['ebay_name']);
$street1 = $sg[0]['ebay_street1'];
$street2 = $sg[0]['ebay_street2'];
$city = $sg[0]['ebay_city'];
$state = $sg[0]['ebay_state'];
$ebay_country = $sg[0]['ebay_country'];
$zip = $sg[0]['ebay_postalcode'];
$tel = $sg[0]['ebay_tel'];
$sure = $sg[0]['ebay_account'];
@$address = $name." ".$street1." ".$street2." ".$city." ".$state." ".$ebay_country." ".$zip." ".$tel;
$st = "select track from ebay_track where bill='$ordersn'";
$st = $db->execute($st);
$st = $db->getResultArray($st);
@$register = $st[0]['track']?$st[0]['track']:" ";
echo $ebay_id."\t".$register."\t".$name."\t".$address."\t".$ebay_country."\t"." 0"."\t".$buyerid."\t".$sure;
echo "\n";
}
?>
include "db/dbconnect0.php";
$db = new dbclass();
header('Content-Type:text/html;charset=utf-8');
$dat = $_REQUEST['date'];
$dat = date('Y-m-d',strtotime($dat));
$sql = "select distinct ebay_products_order from ebay_order_products where ebay_products_order like '%$dat%' and status=1";
$sql = $db->execute($sql);
$sql = $db->getResultArray($sql);
$now_date = date('Y-m-d');
$file_type = "vnd.ms-excel";
$file_ending = "xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=".$dat.".$file_ending");
header("Pragma: no-cache");
header("Expires: 0");
echo "ID\tregister\tname\taddress\tDestination\tItem Weight (g) \tBuyerid\tebaycount";
print "\n";
for($i=0;$i<count($sql);$i++){
$ordersn = $sql[$i]['ebay_products_order'];
$sg = "select * from ebay_peloes where ebay_order='$ordersn'";
$sg = $db->execute($sg);
$sg = $db->getResultArray($sg);
$ebay_id = $sg[0]['ebay_id'];
$buyerid = $sg[0]['ebay_buyerid'];
@$name = iconv('utf-8','gbk',$sg[0]['ebay_name']);
$street1 = $sg[0]['ebay_street1'];
$street2 = $sg[0]['ebay_street2'];
$city = $sg[0]['ebay_city'];
$state = $sg[0]['ebay_state'];
$ebay_country = $sg[0]['ebay_country'];
$zip = $sg[0]['ebay_postalcode'];
$tel = $sg[0]['ebay_tel'];
$sure = $sg[0]['ebay_account'];
@$address = $name." ".$street1." ".$street2." ".$city." ".$state." ".$ebay_country." ".$zip." ".$tel;
$st = "select track from ebay_track where bill='$ordersn'";
$st = $db->execute($st);
$st = $db->getResultArray($st);
@$register = $st[0]['track']?$st[0]['track']:" ";
echo $ebay_id."\t".$register."\t".$name."\t".$address."\t".$ebay_country."\t"." 0"."\t".$buyerid."\t".$sure;
echo "\n";
}
?>
0元开个网店,自己开心赚钱
交易开店注册不收任何费用
http://www.cddzsc.cn/
还有就是看你这个页面文件保存的编码类型是不是也是utf8
MYSQL下的数据库文件都用记事本先打开 后再用EXECL打开的人飘过