我正在嘗試將產(chǎn)品庫存下載為 .csv 文件。使用以下 php 腳本啟用打開頁面后，文件將自動下載。<?php$args = array( 'status' => 'publish', 'limit' => 100, 'orderby' => 'title', 'order' => 'ASC');$products = wc_get_products( $args );$counter = 1;echo "<input type='submit' value='Export' name='Export'>";if (count($products)) { echo "<table align='center'><tr>"; echo "<td>"; // Open the table echo "<table style ='background-color:#ffffff;border-collapse: collapse; margin-right:10px'><thead><tr> <th width='50' style='border:1px solid black'>Sl No.</th> <th width='400' style='border:1px solid black'>Product Name</th> <th style='border:1px solid black' width='54'>Stock</th> </tr></thead>"; // Cycle through the array foreach ($products as $product) { // Output a row if($product->stock_status == 'instock'){ echo "<tr>"; echo "<td align='center' style='border:1px solid black'>$counter</td>"; echo "<td style='border:1px solid black'>$product->name</td>"; echo "<td align='center' style='border:1px solid black'>$product->stock_quantity</td>"; echo "</tr>"; $counter++; $user_arr[] = array($counter,$product->name,$product->stock_quantity); } } // Close the table echo "</table>"; echo "</td>"; //-----------------------out of stock------------ echo "<td valign='top'>"; // Open the table echo "<table style = 'background-color:#ffffff;border-collapse: collapse;'><thead><tr> <th width='50' style='border:1px solid black'>Sl No.</th> <th width='400' style='border:1px solid black'>Out of stock products</th> <th style='border:1px solid black' width='54'>Stock</th> </tr></thead>"; // Close the table echo "</table>"; echo "</td>"; echo "</tr></table>";}打開“product_stock.csv”下載文件后，它沒有與預(yù)期的行值正確對齊，但在每一行和每一列上顯示 html 腳本。單擊“導(dǎo)出”按鈕后如何下載文件 product_stock.csv 并在行中添加預(yù)期值？
1 回答
慕姐8265434
TA貢獻1813條經(jīng)驗 獲得超2個贊
我得到了解決方案。添加帶有按鈕的表單。
<form style="margin-left: 79%;margin-top: -59px;" method="post" id="export-form" action="">
<?php submit_button('Export Stock Report', 'primary', 'download_csv' ); ?>
</form>
然后添加標題以正確對齊，這避免了 product_stock.csv 中的 html 標簽
header('Content-Type: text/csv; charset=utf-8'); //For .csv
header('Content-Disposition: attachment; filename=product-stock-report-' . date('d-m-Y') . '.csv');
$output = fopen('php://output', 'w');
$headings = array( 'Sl. No.','Product Name', 'Stock' );
fputcsv($output, $headings );
- 1 回答
- 0 關(guān)注
- 94 瀏覽
添加回答
舉報
0/150
提交
取消