21,886
社区成员
发帖
与我相关
我的任务
分享
<?PHP
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");
echo "Salary_July_2009"."\t";
echo $company_name."\t";
echo "\n";
echo "Name\t";
echo "Sex\t";
echo "Salary\t";
echo "Absence\t";
echo "\n";
$link = mssql_connect($local, $user, $password);
//////数据库编码请用utf-8////////////////////////////////
mssql_query('set names utf8');
////////////////////////////////////////////////////////
$sqlStatement = mssql_query('Select Name, Sex, Salary, Absence from t_report');
$row = mssql_fetch_array($sqlStatement);
foreach( $row as $v ){
echo $v['Name']."\t";
echo $v['Sex']."\t";
echo $v['Salary']."\t";
echo $v['Absence']."\t";
echo "\n";
}
mssql_free_result($row);
?>
<?PHP
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");
echo "Salary_July_2009"."\t";
echo $company_name."\t";
echo "\n";
echo "Name\t";
echo "Sex\t";
echo "Salary\t";
echo "Absence\t";
echo "\n";
$link = mssql_connect($local, $user, $password);
$sqlStatement = mssql_query('Select Name, Sex, Salary, Absence from t_report');
$row = mssql_fetch_array($sqlStatement);
foreach( $row as $v ){
echo $v['Name']."\t";
echo $v['Sex']."\t";
echo $v['Salary']."\t";
echo $v['Absence']."\t";
echo "\n";
}
mssql_free_result($row);
?>