Javascript SetInterval只使用一次Else

Javascript SetInterval Use Else Only Once

本文关键字:一次 Else SetInterval Javascript      更新时间:2023-09-26

我需要else{}只工作一次。我怎么能做到呢?谢谢你。

    setInterval(function(){
    mysqlConnection.query('SELECT `dog` FROM `pets` WHERE `name`=`nice`', function(err, row, fields) {
   var nice_pet = (row[0].dog);
                                                                mysqlConnection.query('SELECT `food` FROM `info`', function(err, row, fields) {
        mysqlConnection.query('SELECT COUNT(Distinct food) AS DistinctCount FROM `something', function(err, row, fields) {
            var check = row[0].DistinctCount;
            if (check <= 10) {
        // Do it many times
         } else {
        // Do it only once if it goes to here
         }
    })
    })
    })
    }, 1000);

创建一个标志,并将其用作else if

的条件
var once = false;
setInterval(function(){
  mysqlConnection.query('SELECT `dog` FROM `pets` WHERE `name`=`nice`', function(err, row, fields) {
    var nice_pet = (row[0].dog);
    mysqlConnection.query('SELECT `food` FROM `info`', function(err, row, fields) {
      mysqlConnection.query('SELECT COUNT(Distinct food) AS DistinctCount FROM `something', function(err, row, fields) {
        var check = row[0].DistinctCount;
        if (check <= 10) {
          // Do it many times
        } else if(!once) {
          once = true;
          // Do it only once if it goes to here
        }
      })
    })
  })
}, 1000);