PHP foreach 循环只给出 1 个结果

Question

我有这个数组:

$cust = xtc_db_query("SELECT customers_id FROM orders");
$customers = xtc_db_fetch_array($cust);

当我尝试显示每条记录时，我只得到第一条:

foreach ($customers as $v) {
    echo "ID: $v.\n <br>";
}

我尝试手动设置数组然后它工作正常:

$customers = array(1, 2, 3, 17);

Answer 1

您的$customers 数组将只包含一个值(查询的最后一个结果)。您需要使用 while 循环:

$cust = xtc_db_query("SELECT customers_id FROM orders");
while($customers = xtc_db_fetch_array($cust))
{
    // Use $customers here.
}