File manager - Edit - /home/webapp69.cm.in.th/u69319090041/Shop41/public/admin/export.php
Back
<?php require_once __DIR__ . '/../../config/config.php'; require_once __DIR__ . '/../../includes/auth.php'; requireAdmin(); $db = getDBConnection(); if (isset($_GET['download']) && $_GET['download'] === 'csv') { header('Content-Type: text/csv; charset=utf-8'); header('Content-Disposition: attachment; filename=sales_report_' . date('Y-m-d') . '.csv'); $output = fopen('php://output', 'w'); // Output UTF-8 BOM for Excel compatibility with Thai characters fputs($output, $bom = (chr(0xEF) . chr(0xBB) . chr(0xBF))); fputcsv($output, ['Order No', 'Customer Name', 'Total Amount', 'Payment Method', 'Payment Status', 'Order Status', 'Date']); $stmt = $db->query("SELECT o.order_no, u.fullname, o.total_amount, o.payment_method, o.payment_status, o.order_status, o.created_at FROM orders o JOIN users u ON o.user_id = u.id ORDER BY o.id DESC"); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { fputcsv($output, $row); } fclose($output); exit; } require_once __DIR__ . '/../../includes/admin_header.php'; ?> <h3 class="fw-bold mb-4">📄 สรุปรายงาน & Export ข้อมูล</h3> <div class="card card-custom p-4 text-center py-5"> <div class="fs-1 mb-2">📊</div> <h4 class="fw-bold">ส่งออกข้อมูลคำสั่งซื้อเป็นไฟล์ CSV / Excel</h4> <p class="text-muted">รองรับการเปิดอ่านภาษาไทยใน Microsoft Excel ได้อย่างถูกต้องทันที</p> <div class="mt-3"> <a href="export.php?download=csv" class="btn btn-success rounded-pill px-4 py-2 fs-5"> 📥 ดาวน์โหลดรายงาน (CSV Export) </a> </div> </div> <?php require_once __DIR__ . '/../../includes/admin_footer.php'; ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.23 |
proxy
|
phpinfo
|
Settings