我想將數據導出到 CI 中的 excel。但我有問題Undefined index: wc_order_id如果我print_r(array_values($data)); exit;該值是正確的,只是我無法導出到 Excel。這是我的控制器:public function createExcel($awals, $akhirs, $status) { $fileName = 'Reservation.xlsx'; $data['data'] = $this->M_reservation->all_order($awals, $akhirs, $status) ; $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); $total = 0; $sheet->setCellValue('A1', 'No'); $sheet->setCellValue('B1', 'Booking ID'); $sheet->setCellValue('C1', 'Order Date'); $sheet->setCellValue('D1', 'Client Name'); $sheet->setCellValue('E1', 'Client Email'); $sheet->setCellValue('F1', 'Phone'); $sheet->setCellValue('G1', 'Inclution'); $sheet->setCellValue('H1', 'Room name'); $sheet->setCellValue('I1', 'Bed Order'); $sheet->setCellValue('J1', 'Status'); $sheet->setCellValue('K1', 'Total Order'); $rows = 2; $no = 1; $total=0; foreach ($data as $val){ $sheet->setCellValue('A' . $rows, $no++); $sheet->setCellValue('B' . $rows, $val['wc_order_id']); $sheet->setCellValue('C' . $rows, $val['post_date']); $sheet->setCellValue('D' . $rows, $val['display_name']); $sheet->setCellValue('E' . $rows, $val['user_email']); $sheet->setCellValue('F' . $rows, $val['meta_value']); $sheet->setCellValue('G' . $rows, $val['display_name']); $sheet->setCellValue('H' . $rows, $val['post_title']); $sheet->setCellValue('I' . $rows, $val['room_num_search']); $sheet->setCellValue('J' . $rows, $val['status']); $sheet->setCellValue('K' . $rows, $val['total_order']); $total = $total+$val['total_order']; $rows++; }
未定義索引:wc_order_id
慕尼黑8549860
2023-05-12 10:33:30