if(isset($_POST["export"])){ if(empty($_POST["fromDate"])){ $startDateMessage = '>label class="text-danger"/label<'; } else { $orderQuery = " SELECT * FROM enquiry_form WHERE date <= '".$_POST["fromDate"]."' AND date >= '".$_POST["toDate"]."' ORDER BY date DESC"; $orderResult = mysqli_query($conn, $orderQuery) or die("database error:". mysqli_error($conn)); $filterOrders = array(); while( $order = mysqli_fetch_assoc($orderResult) ) { $filterOrders[] = $order; } if(count($filterOrders)) { $fileName = "phpzag_export_".date('Ymd') . ".csv"; header("Content-Description: File Transfer"); header("Content-Disposition: attachment; filename=$fileName"); header("Content-Type: application/csv;"); $file = fopen('php://output', 'w'); $header = array("Id", "Name", "Item", "Value", "Date"); fputcsv($file, $header); foreach($filterOrders as $order) { $orderData = array(); $orderData[] = $order["id"]; $orderData[] = $order["name"]; $orderData[] = $order["email"]; $orderData[] = $order["mobile"]; $orderData[] = $order["state"]; $orderData[] = $order["city"]; $orderData[] = $order["course_type"]; $orderData[] = $order["course"]; $orderData[] = $order["date"]; fputcsv($file, $orderData); } fclose($file); exit; } } }