我一直致力于使用資源列開發(fā) fullCalendar 拖放事件?，F(xiàn)在，我已經(jīng)對可拖動事件區(qū)域進行了硬編碼；現(xiàn)在嘗試從數(shù)據(jù)庫中獲取它。該數(shù)據(jù)庫以前有兩個表 - 資源和事件。事件被刪除到日歷后，會在事件表中更新。資源列是從數(shù)據(jù)庫中獲取的，為了添加新資源，我構(gòu)建了一個房間按鈕，它將新資源保存在資源表中。到目前為止，我的主文件中只有五個可拖動事件，但現(xiàn)在我也正在努力從數(shù)據(jù)庫中獲取這些事件。因此，我在數(shù)據(jù)庫中又創(chuàng)建了一個名為draggableevents 的表。該表包含兩列 id 和 EventName。這是代碼：拖拽事件.php<?phprequire "connection.php";$conn = DB::databaseConnection();$conn->beginTransaction();$sql = "Select * FROM DraggableEvents";$stmt = $conn->prepare($sql);if ($stmt->execute()) {while($result = $stmt->fetch(PDO::FETCH_ASSOC));return $result;} else {return null;}?>表單.php<head><link href='https://unpkg.com/@fullcalendar/core@4.4.0/main.min.css' rel='stylesheet' /><link href='https://unpkg.com/@fullcalendar/daygrid@4.4.0/main.min.css' rel='stylesheet' /><link href='https://unpkg.com/@fullcalendar/timegrid@4.4.0/main.min.css' rel='stylesheet' /><script src='https://unpkg.com/@fullcalendar/core@4.4.0/main.min.js'></script><script src='https://unpkg.com/@fullcalendar/interaction@4.4.0/main.min.js'></script><script src='https://unpkg.com/@fullcalendar/daygrid@4.4.0/main.min.js'></script><script src='https://unpkg.com/@fullcalendar/timegrid@4.4.0/main.min.js'></script><script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script><link href='https://unpkg.com/@fullcalendar/timeline@4.4.0/main.min.css' rel='stylesheet' /><link href='https://unpkg.com/@fullcalendar/resource-timeline@4.4.0/main.min.css' rel='stylesheet' /> <script src='https://unpkg.com/@fullcalendar/timeline@4.4.0/main.min.js'></script> <script src='https://unpkg.com/@fullcalendar/resource-common@4.4.0/main.min.js'></script> <script src='https://unpkg.com/@fullcalendar/resource-timeline@4.4.0/main.min.js'></script> <link rel="stylesheet" href="css/main.css" media="all"> <link href="main.css" rel="stylesheet"> <script src='main.js'></script></head>上面的代碼會產(chǎn)生一個空白的可拖動事件區(qū)域。刷新頁面時，draggableevents.php 文件似乎沒有加載。我在網(wǎng)絡(luò)面板中沒有看到它，因此沒有與之相關(guān)的錯誤。
1 回答
皈依舞
TA貢獻1851條經(jīng)驗 獲得超3個贊
有一些明顯的邏輯問題，但與 fullCalendar 沒有太大關(guān)系：
1）我在之前的問題中多次提到過這一點：return當(dāng)您不在函數(shù)內(nèi)部時不返回值。您認(rèn)為您到底要把它返回到哪里？require沒有辦法
2）即使有效，您也永遠不會返回任何事件，因為您的while循環(huán)已關(guān)閉并且不執(zhí)行任何操作。
3)$result無論如何都會超出 while 循環(huán)之外的范圍。
4）你從不執(zhí)行你的查詢
5) 你沒有知道echo活動名稱。
您需要將所有數(shù)據(jù)庫結(jié)果放入一個數(shù)組中，然后循環(huán)該數(shù)組以生成與fc-event數(shù)組中的條目一樣多的 div。
這是一種方法 - 我將draggableevents.php 的功能放入一個函數(shù)中，您可以在需要時調(diào)用它。
拖拽事件.php
<?php
require "connection.php";
function getDraggableEvents() {
$conn = DB::databaseConnection();
$sql = "Select * FROM DraggableEvents";
$stmt = $conn->prepare($sql);
$stmt->execute();
$results = array();
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$results[] = $row;
}
return $results;
}
?>
表單.php
<html>
<head>
<link href='https://unpkg.com/@fullcalendar/core@4.4.0/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/daygrid@4.4.0/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/timegrid@4.4.0/main.min.css' rel='stylesheet' />
<script src='https://unpkg.com/@fullcalendar/core@4.4.0/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/interaction@4.4.0/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/daygrid@4.4.0/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/timegrid@4.4.0/main.min.js'></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script>
<link href='https://unpkg.com/@fullcalendar/timeline@4.4.0/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/resource-timeline@4.4.0/main.min.css' rel='stylesheet' />
<script src='https://unpkg.com/@fullcalendar/timeline@4.4.0/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/resource-common@4.4.0/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/resource-timeline@4.4.0/main.min.js'></script>
<link rel="stylesheet" href="css/main.css" media="all">
<link href="main.css" rel="stylesheet">
<script src='main.js'></script>
</head>
<body>
<div id='external-events'>
<p>
<strong>Draggable Events</strong>
</p>
<?php
require 'draggableevents.php';
$events = getDraggableEvents();
foreach ($events as $event)
{
?>
<div class='fc-event'><?php echo $event['EventName']; ?></div>
<?php
}
?>
<p>
<input type='checkbox' id='drop-remove' />
<label for='drop-remove'>remove after drop</label>
</p>
</div>
<div id='calendar-container'>
<div id='calendar'></div>
</div>
</body>
</html>
- 1 回答
- 0 關(guān)注
- 157 瀏覽
添加回答
舉報
0/150
提交
取消