skrypt php tworzy zawartość pliku ics czyli kalendarza (gdy podglądnę kod źródłowy strony). jak sprawić, żeby uruchomienie tego skryptu utworzyło plik ics?
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "calendar";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error); }
$conn->set_charset("utf8");
$sql = "SELECT * FROM calendar WHERE id_employee='0100000001'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "BEGIN:VCALENDAR \n"; echo "PRODID:-//Google Inc//Google Calendar 70.9054//EN \n"; echo "CALSCALE:GREGORIAN \n"; echo "METHOD:PUBLISH \n"; echo "X-WR-CALNAME:Kalendarz \n"; echo "X-WR-TIMEZONE:Europe/Warsaw \n";
while($row = $result->fetch_assoc()) {
$h_start = $row['h_start'];
$h_end = $row['h_end'];
$imie = $row['imie'];
$nazwisko = $row['nazwisko'];
$schedule_notes = $row['schedule_notes'];
$komorka = $row['komorka'];
echo "SUMMARY:"; //20211227T190000
echo "DTSTART:"; //20211227T190000 echo DateTime
::createFromFormat('Y-m-d H:i:s', $h_start)->format('Ymd'); echo DateTime
::createFromFormat('Y-m-d H:i:s', $h_start)->format('His');
echo "DTEND:"; //20211227T190000 echo DateTime
::createFromFormat('Y-m-d H:i:s', $h_end)->format('Ymd'); echo DateTime
::createFromFormat('Y-m-d H:i:s', $h_end)->format('His');
echo "UID:"; //7ko43dfm8luc0l4ouv5c16rs10@google.com
} else {
}
} else {
}
echo "CREATED:20200504T070405Z";
echo "LAST-MODIFIED:20200504T070405Z";
echo "DTSTAMP:20211227T214436Z";
}
} else {
}
#$conn->close();
?>