我是網絡編程的新手,我試圖從我的數據庫中獲取時間和日期并將它們顯示在我的fullcalendar 上。我將如何獲得時間數據類型的值以顯示在我的日歷上,以及如何向其中添加 daysOfWeek。我有這段代碼可用于獲取日期時間數據類型的事件,但我需要另一個代碼來處理每周從數據庫中發生的靜態事件。fetchevents.php<?php require_once "dbconn.php"; $json = array(); $sqlQuery = "SELECT * FROM tbl_events ORDER BY id"; $result = mysqli_query($conn, $sqlQuery); $eventArray = array(); while ($row = mysqli_fetch_assoc($result)) { array_push($eventArray, $row); } mysqli_free_result($result); mysqli_close($conn); echo json_encode($eventArray);?>這是我試過的一些代碼,數組是錯誤的,但這是我所做的fetchevents.php$result = mysqli_query($conn, $sqlQuery); $eventArray = array( 'title' => $row['section_name'], 'startTime' => $row['time_start'], 'endTime' => $row['time_end'], 'daysOfWeek' => $row['day_id'] ); while ($row = mysqli_fetch_assoc($result)) { array_push($eventArray, $row); }然后我在我的eventSources上調用它eventSources:[ { url: "../include/fetchevents.php" } ],這段代碼產生了我期望的輸出,但我不知道如何從我的數據庫中獲取值并分配它們。events:[ { title: 'Exams', // get title from db startTime: '10:00', // get start time from db endTime: '13:00', // get end time from db daysOfWeek: ['1','3'] // get daysID from db } ]
1 回答

一只甜甜圈
TA貢獻1836條經驗 獲得超5個贊
您應該在 while 循環內生成事件數組,如下所示:
$eventArray = array(); // Initialize empty array
while ($row = mysqli_fetch_assoc($result)) {
// Push to the eventArray one array for each row
$eventArray[] = array(
'title' => $row['section_name'],
'startTime' => $row['time_start'],
'endTime' => $row['time_end'],
'daysOfWeek' => $row['day_id']
);
}
- 1 回答
- 0 關注
- 208 瀏覽
添加回答
舉報
0/150
提交
取消