JQuery 周日历问题

发布于 2024-12-21 08:09:07 字数 992 浏览 0 评论 0原文

在我的项目中，我使用 JQuery 周日历插件。我调用 php 脚本来检索数据并将其显示在日历中。以下是我的

var id = 3; 
     var type = "c";
     var dataString = "id=" + id + "&t=" + type;
     $.ajax({
        type:"post",
        url:"actions/client.php",
        data: dataString,
        dataType:"json",
        success: function(data){
            alert(data);
        }
    });

PHP 代码：

function getCalendarData($appoint_id){
                $retunArray = array();
                $sql = "SELECT id, appoint_start, appoint_end, total FROM account WHERE id = '".$appoint_id."'";
                $result = mysql_query($sql);
                while($row = mysql_fetch_object($result)){
                    $retunArray[] == $row;  
                }
                echo json_encode($retunArray);
            }

它给了我 500 错误。以前有人用过 PHP 吗？有人可以帮我从数据库获取数据并显示吗？还有比这更好的替代方法吗

谢谢

原文

In my project, I am using the JQuery week calendar plugin. I call a php script to retrieve the data and show it in the calandar. Following is my code

var id = 3; 
     var type = "c";
     var dataString = "id=" + id + "&t=" + type;
     $.ajax({
        type:"post",
        url:"actions/client.php",
        data: dataString,
        dataType:"json",
        success: function(data){
            alert(data);
        }
    });

In PHP:

function getCalendarData($appoint_id){
                $retunArray = array();
                $sql = "SELECT id, appoint_start, appoint_end, total FROM account WHERE id = '".$appoint_id."'";
                $result = mysql_query($sql);
                while($row = mysql_fetch_object($result)){
                    $retunArray[] == $row;  
                }
                echo json_encode($retunArray);
            }

It gives me a 500 error. Has anyone used it before with PHP. Can anybody help me to get the data from the db and show? any alternative good way than this

Thanks

分享到QQ

分享到微博