我是網(wǎng)絡(luò)編程的新手，我試圖從我的數(shù)據(jù)庫(kù)中獲取時(shí)間和日期并將它們顯示在我的fullcalendar 上。我將如何獲得時(shí)間數(shù)據(jù)類型的值以顯示在我的日歷上，以及如何向其中添加 daysOfWeek。我有這段代碼可用于獲取日期時(shí)間數(shù)據(jù)類型的事件，但我需要另一個(gè)代碼來(lái)處理每周從數(shù)據(jù)庫(kù)中發(fā)生的靜態(tài)事件。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);?>這是我試過(guò)的一些代碼，數(shù)組是錯(cuò)誤的，但這是我所做的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上調(diào)用它eventSources:[ { url: "../include/fetchevents.php" } ],這段代碼產(chǎn)生了我期望的輸出，但我不知道如何從我的數(shù)據(jù)庫(kù)中獲取值并分配它們。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貢獻(xiàn)1836條經(jīng)驗(yàn) 獲得超5個(gè)贊
您應(yīng)該在 while 循環(huán)內(nèi)生成事件數(shù)組，如下所示：
$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 關(guān)注
- 211 瀏覽
添加回答
舉報(bào)
0/150
提交
取消