各位大大好:
想請問 $value1是陣列要怎麼將其中手機欄前為0開頭的資料轉CSV檔的時候不會消失，$value1['phone'] fputcsv($fp,$value1);不知道要怎麼改 謝謝

$sql = "SELECT * FROM checkin  LIMIT 20"; 
$statement = $conn->prepare($sql);
$statement->execute();
$rows = $statement->fetchAll(PDO::FETCH_ASSOC); 
$columnNames = array();
if(!empty($rows)){
  $firstRow = $rows[0];
  foreach($firstRow as $colName => $val){
  $columnNames[] =$colName;    //取第一行欄位
   }
   }
  $fileName = 'mysql-export.csv';
  header('Content-Type: application/vnd.ms-excel;charset=utf-8');
  header('Content-Disposition: attachment; filename="' . $fileName . '"');
  $fp = fopen('php://output', 'w');
  fputcsv($fp, $columnNames);
  foreach ($rows as $value1) {
                        
  fputcsv($fp,$value1);
        }
fclose($fp);