php - 使用php将excel文件保存到服务器

Question

我正在从数据库中检索数据并使用以下代码将其导出到 excel 中，我可以从中导出到 excel 并从浏览器中保存文件。

$sql_select= "my query";
$queryRes = mysql_query($sql_select);

$header = "Country" . "\t";
$header .= "Network" . "\t";
$header .= "MCC" . "\t";
$header .= "MNC" . "\t";
$header .= "ClientPrice" . "\t";
$header .= "Currency" . "\t";

$data = '';
while( $row = mysql_fetch_assoc($queryRes)){
$row1 = array();
$row1[] = $row['country'];
$row1[] = $row['networkname'];
$row1[] = $row['mcc'];
$row1[] = $row['mnc'];
$row1[] = $row['clientprice'];
$row1[] = $row['currency'];
$data .= join("\t", $row1)."\n";
//$data= $first_name."\t";
//$data .= $row['originator']."\t";
}

header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=expot.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data"; 
exit(); 

我正在使用以下代码将 excel 文件保存到此位置“/pricelists/example.xls”

file_put_contents("/pricelists/example.xls",$data);
print "$header\n$data";

它显示警告

Warning: file_put_contents(/pricelists/example.xls) [function.file-put-contents]: failed to open stream:

谁能指导我如何解决这个谢谢？

Answer 1

您的文件是否存在于路径/pricelists/example.xls 中？

使用文件的相对路径可以解决问题。

file_put_contents("pricelists/example.xls",$data);