Forum PHP.pl

poniższy kod zamienia plik .csv do .ics (kalendarz). w przetwarzanym pliku csv są różne pola np.nr telefonu, uwagi. jak pobrać konkretne pole (kolumnę), żeby utworzyć dla niej np:
SUMMARY: Imię i Nazwisko
DESCRIPTION: uwagi\nTel: xxx-xxx-xxx

[PHP] pobierz, plaintext 
<?php
 
      $fp = fopen("calendar.csv", 'r');
 
      $i = 0;
 
      if ($fp){
        if (flock($fp, LOCK_SH)){
          while (!feof($fp)) {
 
            $line = fgets($fp);
            $line = trim($line);
          #  $line = mb_convert_encoding($line, 'auto', 'auto');
            $line = str_replace(PHP_EOL, '', $line);
            if($i == 0){
              // header of csv file
              $header = $line;
            }else{
              $data[] = $line;
            }
            $i++;
          }
          flock($fp, LOCK_UN);
        }
      }
 
      fclose($fp);
 
      #unlink($filepath);
 
      $header_item = explode(",", $header);
 
      // designate file path
      $file_name = "calendar.ics";
 
      // open file
      $fp = fopen($file_name, 'w');
 
      // number of data
      $i = $i - 2;
 
 
//X-WR-TIMEZONE:Europe/Warsaw
      // write header part
      $common = "BEGIN:VCALENDAR" . "\n";
      fputs($fp, $common);
      $common = "VERSION:2.0" . "\n";
      fputs($fp, $common);
      $common = "PRODID:-//Google Inc//Google Calendar 70.9054//EN" . "\n";
      fputs($fp, $common);
      $common = "CALSCALE:GREGORIAN" . "\n";
      fputs($fp, $common);
      $common = "METHOD: PUBLISH" . "\n";
      fputs($fp, $common);
      $common = "X-WR-CALNAME:Pacjenci PŁ" . "\n";
      fputs($fp, $common);
      $common = "X-WR-TIMEZONE:Europe/Warsaw" . "\n";
      fputs($fp, $common);
 
      // write data
      for($count = 0; $count < $i; $count++){
        $common = "BEGIN:VEVENT" . "\n";
        fputs($fp, $common);
        for($j = 0; $j < count($header_item); $j++){
          $data_item = explode(",", $data[$count]);
          $item = $header_item[$j] . ":" . $data_item[$j] . "\n";
          fputs($fp, $item);
        }
        $common = "END:VEVENT" . "\n";
        fputs($fp, $common);
      }
 
      // write footer part
      $common = "END:VCALENDAR" . "\n";
      fputs($fp, $common);
 
      fclose($fp);
 
      // download ics file
      $fname = "calendar.ics";
      #header('Content-Type: application/force-download');
     # header('Content-Length: ' . filesize($file_name));
      #header('Content-disposition: attachment; filename="' . $fname . '"');
      readfile($file_name);
 
      // delete file
      #unlink($file_name);
?>
[PHP] pobierz, plaintext 

Ten post edytował dentopolis 30.12.2021, 00:38:06

Masz
a,b,c,d

Teraz jak ma być?
a:b,a:c,a:d



Ten post edytował Neutral 30.12.2021, 14:06:41