如何将存储在数据库中的事件显示在日历中？

Question

如何将存储在数据库中的事件显示在日历中？我不知道如何用自己的日期替换随机日期.....是不是必须遍历数据库获得的数据？并把数据修改为JSON格式？我可以用前轮吗？

这是zabuto日历下载网站提供的代码：

<?php include_once 'includes/sessions.php'; ?>
<?php include_once 'includes/connect.php';
/**
 * Example of JSON data for calendar
*
* @package zabuto_calendar
*/


if (!empty($_REQUEST['year']) && !empty($_REQUEST['month'])) {
$year = intval($_REQUEST['year']);
$month = intval($_REQUEST['month']);
$lastday = intval(strftime('%d', mktime(0, 0, 0, ($month == 12 ? 1 : $month + 1), 0, ($month == 12 ? $year + 1 : $year))));


$dates = array();
for ($i = 0; $i <= (rand(4, 10)); $i++) {
    $date = $year . '-' . str_pad($month, 2, '0', STR_PAD_LEFT) . '-' . str_pad(rand(1, $lastday), 2, '0', STR_PAD_LEFT);

$dates[$i] = array(
        'date' => $date,
        'badge' => ($i & 1) ? true : false,
        'title' => 'Example for ' . $date,
        'body' => '<p class="lead">Information for this date</p><p>You can add <strong>html</strong> in this block</p>',
        'footer' => 'Extra information',
    );

    if (!empty($_REQUEST['grade'])) {
        $dates[$i]['badge'] = false;
        $dates[$i]['classname'] = 'grade-' . rand(1, 4);
    }

    if (!empty($_REQUEST['action'])) {
        $dates[$i]['title'] = 'Action for ' . $date;
        $dates[$i]['body'] = '<p>The footer of this modal window consists of two buttons. One button to close the modal window without further action.</p>';
        $dates[$i]['body'] .= '<p>The other button [Go ahead!] fires myFunction(). The content for the footer was obtained with the AJAX request.</p>';
        $dates[$i]['body'] .= '<p>The ID needed for the function can be retrieved with jQuery: <code>dateId = $(this).closest(\'.modal\').attr(\'dateId\');</code></p>';
        $dates[$i]['body'] .= '<p>The second argument is true in this case, so the function can handle closing the modal window: <code>myFunction(dateId, true);</code></p>';
        $dates[$i]['footer'] = '
        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
        <button type="button" class="btn btn-primary" onclick="dateId = $(this).closest(\'.modal\').attr(\'dateId\'); myDateFunction(dateId, true);">Go ahead!</button>
        ';
    }
}

echo json_encode($dates);

} else {
echo json_encode(array());
}