如何在 while 循环中填充数组并在每次迭代中获得新范围?

2021-12-26 00:00:00 arrays loops while-loop php

问题是我只得到来自表的最后一个值.我认为这是因为我在将数组的值引用到同一个对象的同时构建数组，并且它一直在变化.我知道 while 循环不会为每次迭代创建一个新的范围，是问题.

The problem is that I get only the last value comming from the Table. I think its because I am building the array while referencing its values to the same object, and it keeps changing. I know while loop doesnt create a new scope for each iteration which IS the problem.

为每次迭代获得新范围的最佳方法是什么?

代码:

    $namesArray= array();
        while ($row=mysql_fetch_array($result))
        {
        $nameAndCode->code = $row['country_code2'];
        $nameAndCode->name = $row['country_name'];           
        array_push($namesArray,$nameAndCode);


        } 
return $namesArray;

推荐答案

您需要在每次迭代时创建一个新对象:

You need to create a new object on each iteration:

while ($row=mysql_fetch_array($result))
{
    $nameAndCode = new stdClass;
    $nameAndCode->code = $row['country_code2'];
    $nameAndCode->name = $row['country_name'];           
    $namesArray[] = $nameAndCode;
}

否则，您将一遍又一遍地引用同一个对象，而只会覆盖其值.

Otherwise you're referencing the same object over and over, and just overwriting its values.

如果你不需要对象，你也可以用数组来做到这一点:

You also can do this with arrays if you don't require objects:

while ($row=mysql_fetch_array($result))
{
    $nameAndCode = array();
    $nameAndCode['code'] = $row['country_code2'];
    $nameAndCode['name'] = $row['country_name'];           
    $namesArray[] = $nameAndCode;
}

或者更简洁:

while ($row=mysql_fetch_array($result))
{
    $namesArray[] = array( 
        'code' => $row['country_code2'],
        'name' => $row['country_name']
    );
}

相关文章