javascript - 如何在javascript中使用PHP调用SQL记录

Question

已关闭。此问题需要 debugging details 。目前不接受答案。

---

编辑问题以包含 desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem 。这将有助于其他人回答问题。

已关闭 7 年前。

Improve this question

<?php include('db.php'); 

//it's connect the database to server

$sql = "select * from event";
$query = mysql_query ($sql);
?>


<script>
$(document).ready(function() {
    $('#calendar').fullCalendar({
        defaultDate: '2016-03-01',
        editable: true,
        eventLimit: true, // allow "more" link when too many events
        events: [
        <?php while($rs = mysql_fetch_array ($query)){
        ?>
            {
                title: '<?php echo $rs['title']?>',
                start: '<?php echo $rs['date']?>'
            },
        <?php }?>
        ]
    });
});

只要我的数据库表中有记录，我就想显示标题和日期。但这段代码不起作用。谢谢

Answer 1

试试这个

<?php include('db.php'); 

    //it's connect the database to server

$sql = "select * from event";
$query = mysql_query ($sql);
$events = array();
while($rs = mysql_fetch_array ($query)){
    $events[] = array(
        'title' => $rs['title'],
        'start' => date('Y-m-d H:i:s', strtotime($rs['date']))
    );
}
?>


<script>
$(document).ready(function() {
    $('#calendar').fullCalendar({
        defaultDate: '2016-03-01',
        editable: true,
        eventLimit: true, // allow "more" link when too many events
        events: <?php echo json_encode($events)?>
    });
});