文件操作 - holidays.php
返回文件管理
返回主菜单
删除本文件
文件: E:\HostingSpaces\kimblycr\api.kimbly.in\wwwroot\holidays.php
编辑文件内容
<?php $year = $_GET['year']; if (!isset($year) || !is_numeric($year)) { die('Invalid year parameter'); } // Connect to your MySQL database $servername='localhost:3309'; $username='satya'; $password='n7galhWvjw#prokuxbfi'; $dbname = "kimalgo"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die('Database connection failed: ' . $conn->connect_error); } // Fetch holidays for the given year $query = "SELECT `date` FROM holidays WHERE `year` = $year"; $result = $conn->query($query); if (!$result) { die('Query failed: ' . $conn->error); } $holidays = []; while ($row = $result->fetch_assoc()) { $holidays[] = $row['date']; } // Close the database connection $conn->close(); // Return the holidays as JSON header('Content-Type: application/json'); echo json_encode($holidays); ?>
修改文件时间
将文件时间修改为当前时间的前一年
删除文件