php - 如果满足条件，如何在函数内运行函数

Question

请我一直在尝试创建一个函数来查询数据库，从表中选择，如果行数不等于 6，则从表中选择一行并重复(或可能重复)，直到行数为等于 6。我在 StackOverflow 中搜索了这个，但没有得到任何接近的结果。如果您有与此类似的链接，请将其发布在这里，我会尝试一下。

这是我的代码:

//List All active adverts
function showActiveAdverts()
{

    $status = 1;
    //Build final queries.
    $query = mysql_query("SELECT * FROM table WHERE 
             status = '".mysql_real_escape_string($status)."' ORDER BY rand() LIMIT 6") or die(mysql_error());

    $count = mysql_num_rows($query);
    $row = mysql_fetch_assoc($query);

# My question here, check if the $count >= 1 && $count != 6, then do getDefaultBannner() and repeat it until it runs for 6 times.
    if($count >= 1){ 
        do{ 
            $list[] = $row['id']; 
        }while($row = mysql_fetch_assoc($query));
        return $list;
    }
    else{ return FALSE; }
    }

这是 getDefaultBannner() 的代码

function getDefaultBannner()
{
    $status = 6;
    $query = mysql_query("SELECT id FROM table WHERE status = '".mysql_real_escape_string($status)."' ") 
            or die(mysql_error());

    $count = mysql_num_rows($query);
    $row = mysql_fetch_assoc($query);


    if($count >= 1){ 
        do{ 
            $list[] = $row['id']; 
        }while($row = mysql_fetch_assoc($query));
        return $list;
    }
    else{ return FALSE; }
}

提前致谢!

Answer 1

您可以将代码重写为这样

//List All active adverts

$query = mysql_query("SELECT * FROM table WHERE 
             status = '".mysql_real_escape_string($status)."' ORDER BY rand() LIMIT 6") or die(mysql_error());

$count = mysql_num_rows($query);

if($count >= 1 && $count != 6)
  $list = getDefaultBannner();
else
  $list = showActiveAdverts($query);

function showActiveAdverts($query)
{

    $status = 1;
    //Build final queries.

    $row = mysql_fetch_assoc($query);

    if($count >= 1){ 
        do{ 
            $list[] = $row['id']; 
        }while($row = mysql_fetch_assoc($query));
        return $list;
    }
    else{ return FALSE; }
    }