$ALT_Db = @mysql_select_db($DB_DBName, $Connect) or die("Couldn't select database");
$result = @mysql_query($sql, $Connect) or die(mysql_error());
//转换编码函数，防止乱码
function codeutf8($str)
{
return iconv("utf-8", "gb2312", $str);
}
/*写入表字段名*/
echo codeutf8("序号") . "\t";
echo codeutf8("ID") . "\t";
echo codeutf8("收款人姓名") . "\t";
echo codeutf8("银行名称") . "\t";
echo codeutf8("银行卡号") . "\t";
echo codeutf8("付款金额") . "\t";
echo codeutf8("0(第二天到账)/1(2小时到账)") . "\t";
echo codeutf8("备注") . "\n";
echo "\n";
/*写入表数据*/
$sep = "\t";
while ($row = mysql_fetch_row($result)) {
$data = "";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
if (!isset($row[$i])) {
$data .= "NULL" . $sep;
} elseif ($row[$i] != "") {
$datmp = iconv("utf-8", "gbk", $row[$i]);
$data .= $datmp . $sep;
} else {
$data .= "" . $sep;
}
//处理空字段
//转换编码函数，防止乱码
function codeutf8($str)
{
return iconv("utf-8", "gb2312", $str);
}
/*写入表字段名*/
echo codeutf8("ID") . "\t";
echo codeutf8("订单号") . "\t";
echo codeutf8("买家ID") . "\t";
echo codeutf8("受益人ID") . "\t";
echo codeutf8("分成资金（未扣手续费）") . "\t";
echo codeutf8("分成资金（已扣除5%手续费）") . "\t";
echo codeutf8("付款时间") . "\t";
echo codeutf8("确认收货时间") . "\t";
echo codeutf8("操作状态（1=待处理、2=已分成、3=换货、4=退货、5=等级不符）") . "\t";
echo codeutf8("分成模式") . "\n";
echo "\n";
/*写入表数据*/
$sep = "\t";
while ($row = mysql_fetch_row($result)) {
$data = "";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
if (!isset($row[$i])) {
$data .= "NULL" . $sep;
} elseif ($row[$i] != "") {
$datmp = iconv("utf-8", "gbk", $row[$i]);
if ($i == 1) {
$data .= "'" . $datmp . $sep;
} elseif ($i == 6) {
$data .= date("Y-m-d H:i:s", $datmp) . $sep;
} elseif ($i == 7) {
