Question

我试图做的是,通过gra取数据库信息并把它放入 j阵列,制造滑坡。目前,我正在利用“jquery ajax”功能,把信息从单独的“Candre”档案中提出来。这里是我的《加拿大刑法》:

mysql_connect( x ,  x ,  x ) or die( Not Connecting );
mysql_select_db( x ) or die ( No Database Selected );

$i = 0;
$sql = mysql_query("SELECT comicname FROM comics ORDER BY upldate ASC");

while($row = mysql_fetch_array($sql, MYSQL_ASSOC)) {
echo "comics[" .$i. "]= comics/" .$row[ comicname ]. " ;";
$i++;
}

What I want is to create the array in php from the mysql query and then be able to reference it with javascript in order to build a simple slideshow script. Please let me know if you have any questions or suggestions.

Answer 1

Ok有您的网址:echo json_encode(您的网址名称);。

然后,在javascript一侧,你应该看一看这样的东西:

$.ajax({
        data:       "query string to send to your php file if you need it",
        url:        "youphpfile.php",
        datatype:   "json",
        success:    function(data, textStatus, xhr) {
                        data = JSON.parse(xhr.responseText);
                        for (i=0; i<data.length; i++) {
                        alert(data[i]); //this should tell you if your pulling the right information in

                        }
        });

可替换数据。如果你获得正确数据,使用你的JSArray.push(数据);我相信,实际上会有更直接的方法......

Answer 2

您不妨将所有浏览量排入一个大型阵列,然后将其编码为<代码>。 JSON :

$ret = array();
while($row = mysql_fetch_array($sql, MYSQL_ASSOC))
        $ret[] = $row
echo json_encode($ret);

然后,客户方面就这样说:

function mycallback(data)
{
        console.log(data[0].comicname); // outputs the first returned comicname
}

$.ajax
        (
        {
        url:  myscript.php ,
        dataType:  json ,
        success: mycallback
        }
        );

Upon successful request completion, mycallback will be called and passed an array of maps, each map representing a record from your resultset.

Answer 3

很难从您的提问中解答,但这样:

You are making an AJAX call to your server in JS
Your server (using PHP) responds with the results
When the results come back jQuery invokes the callback you passed to it ...
And you re lost at this point? ie. the point of putting those AJAX results in to an array so that your slideshow can use them?

如果是这样,解决办法非常简单:在你们的非洲复兴开发银行呼吁中,结果将变成一个全球变量(例如窗口)。我的Results = 结果FromAjax;然后提到你希望开始幻灯时的变数。

然而,由于时间问题很可能是个问题,或许更有意义的是,实际上从你的反馈中开始幻灯。作为一种额外奖金,这种办法并不需要全球变量。

如果是你 st的灯塔,请张贴更多的信息。

友情链接