執(zhí)行下面的代碼時(shí)，它返回錯(cuò)誤“警告無(wú)法修改標(biāo)頭信息 - 標(biāo)頭已由......發(fā)送”。我已經(jīng)編寫(xiě)了以 2 種不同方式提取數(shù)據(jù)的數(shù)組，但仍然收到問(wèn)題。<?php //export.php $connect = mysqli_connect("localhost", "username", "password", "dbname"); $output = ''; if(isset($_POST["export"])){ $query = " select trim(ifnull(application, 'Grand Total' )) as Application, ifnull(sum(Totalcapacity) ,0.00) as 'Capacity (Gig)' from storagedata group by application with rollup "; $result1 = mysqli_query($connect, $query); $result2 = mysqli_query($connect, $query); $dataRow = ""; while($row2 = mysqli_fetch_array($result2)){ $dataRow = $dataRow."<tr><td>$row2[0]</td><td>$row2[1]</td></tr>";}?><html><head> <title>Returning Total Capacity Per DC</title></head><body><!-- Building table --> <table align = 'center' border='2' width='300' height='100'> <tr> <td colspan='2' align='center' bgcolor='lightblue'><b>Total Capacity by DC</b> </td> </tr> <tr> <th>Datacenter</th> <th>Total Capacity (Gig)</th> </tr> <?php while($row1 = mysqli_fetch_array($result1)):;?> <tr> <td><?php echo $row1[0];?></td> <td><?php echo $row1[1];?></td> </tr> <?php endwhile;?></body> <br><br><?php $output .= '</table>'; header('Content-Type: application/xlsx;'); header('Content-Disposition: attachment; filename=download.xlsx'); echo $output; }?>當(dāng)單擊我的導(dǎo)出按鈕時(shí)，它應(yīng)該導(dǎo)出數(shù)據(jù)。同樣的代碼也適用于其他“報(bào)告”。唯一的區(qū)別是頂部的選擇查詢(xún)。
如何修復(fù) PHP 中的“警告：
慕田峪9158850
2021-06-30 09:43:58
