如何显示动态PHP javascript日历


How to display dynamic PHP javascript calendar

下面是从数据库表预订中获取日期的javascript代码,显然日历显示的是患者id,而不是名称和时间:数据库是mysqli,我如何使其显示行时间和名称,并使其成为链接

<script type="text/javascript">
        $(document).ready(function(){ 
    // CALENDAR
        var date = new Date();
        var d = date.getDate();
        var m = date.getMonth();
        var y = date.getFullYear();
        $('#calendar').fullCalendar({
            header: {
                left: 'prev,next',
                center: 'title',
                right: 'month,basicWeek,basicDay'
            },
            editable: true,
            height: 550,
            events: [
                <?php 
                $sql2= mysqli_query($db_conn,"SELECT autoid,day,month,year,time,patientid as time FROM booking");
                while($row = mysqli_fetch_array($sql2))
                {
                $autoid = $row['autoid'];
                $day = $row['day'];
                $month = $row['month'];
                $year = $row['year'];
                $time = $row['time'];
                $patientid = $row['patientid'];
                $sql5="SELECT * FROM patients WHERE autoid='$patientid'";
                $result5=mysqli_query($db_conn,  $sql5);
                $row5 = mysqli_fetch_assoc($result5) ;
                $fname= $row5["fname"] ;
                $lname= $row5["lname"] ;    
               ?>
       { title: '<?php echo $lname;?>-<?php echo $time;?>', start: '<?php echo $year;?>, <?php echo $month;?>, <?php echo $day;?>', end: '<?php echo $year;?>, <?php echo $month;?>, <?php echo $day;?>', url: '#' }, 
      <?php
      }
      ?>
                {
                    title: 'Click for ThemeForest',
                    start: new Date(2030, m, 28),
                    end: new Date(2030, m, 29),
                    url: '#'
                }
            ]
        });
     });
    });
        </script>

您的查询中有一个错别字:…时间,像时间一样耐心……Patientid重写时间