php - jQuery Ajax json根据循环条件从数据库设置值

Question

我有 jQuery json 从数据库获取数据。

var list = ["Imsak", "Subuh", "Terbit", "Dhuhur", "Ashar", "Maghrib", "Isya"];

geo = [jsonStr.longitude, jsonStr.latitude, jsonStr.altitude];
timezone = jsonStr.timezone;

prayTimes.tune({ imsak: 2, subuh: 2, terbit: -2, dhuhur: 121, ashar: 2, maghrib: 2, isya: 2 });

var date = new Date(); // today 
prayTimes.setMethod(jsonStr.calculationMethod);
var times = prayTimes.getTimes(date, geo, timezone);

$.ajax(
{
    url: "chk",
    type: "POST",
    data:
    {
    },
    dataType: "JSON",
    success: function (jsonStr)
    {
        var sholatNameLen = jsonStr.sholatName.length;
        for(var i=0; i<sholatNameLen; i++)
        {
            var sholatName = jsonStr.sholatName[i];

            if(jsonStr.time10 == times[list[i].toLowerCase()] + ":00")
            {
                if(list[i] == sholatName)
                {
                    alert(jsonStr.audio_before_adzan);
                }
            }
        }
    }
});

我的 table 上有数据

sholat_name  | audio_before_adzan | iqamah
Subuh        | Alfatihah.mp3      | 10
Dhuhur       | Al-Baqarah.mp3     | 10

在我的 PHP json

$time10 = date("H:i:s", strtotime('+ 10 minutes'));
$qAdzanIqomah = mysqli_query($con, "SELECT * FROM tb_sholat WHERE active = 'Y'");
while($dAdzanIqomah = mysqli_fetch_array($qAdzanIqomah))
{
    $sholatName[] = $dAdzanIqomah['sholat_name'];
    $iqamah[] = $dAdzanIqomah['iqamah'];
    $audio_before_adzan[] = $dAdzanIqomah['audio_before_adzan'];
}

$data = array(
    "audio_before_adzan"     => $audio_before_adzan,
    'time10' => $time10
);

echo json_encode($data);

我想要的是，当 if(jsonStr.time10 == times[list[i].toLowerCase()] + ":00") 为 true 时，然后根据 sholatName 获取 audio_before_adzan。

我尝试了上面的代码，但是这个函数if(list[i] == sholatName)可能不正确。

Answer 1

我认为你只是搞乱了你的 for 循环。您似乎对 2 个不同的循环使用相同的变量 i 。您应该拆分循环才能使其有用:

下面的代码只是success函数中的部分:

var sholatNameLen = jsonStr.sholatName.length;
    for(var i=0; i<sholatNameLen; i++)
    {
        var sholatName = jsonStr.sholatName[i];
        for (var j = 0; j < list.lenght; j++) {
             if(jsonStr.time10 == times[list[j].toLowerCase()] + ":00")
             {

                if(list[j] == sholatName)
                {
                    alert(jsonStr.audio_before_adzan[i]);
                }
            }
        }
    }