PHP 添加到在 foreach 中创建的现有数组

Question

我正在从数据库中选择值并将它们添加到循环中的数组中foreach，这是有效的。

之后，我在第二个查询中选择其他值，我想将这些值添加到同一个数组中，如何实现这一点？

请注意，我还不担心代码的安全性。

我的（简化的）代码如下；

$users_arr = array();

// first query

$db->setQuery("SELECT id, name, username, email FROM sometable WHERE name = '$name' ");

$results = $db->loadObjectList();

foreach ($results as $result) {

    $userid = $result->id;

    $name = $result->name;

    $username = $result->username;

    $email= $result->email;

    $users_arr[] = array(

      "id" => $userid, 

      "name" => $name, 

      "username" => $username, 

      "email" => $email);

}

// second query

$db->setQuery("SELECT status AS wb_status FROM anothertable ");

$wb = $db->loadObject();

$wb_status = $wb->wb_status;

// add to original array 

$users_arr[] = array("wb_status" => $wb_status);

echo json_encode($users_arr);

exit();

这会产生；

[

  {

    "id": "981",

    "name": "jo",

    "username": "jo123",

    "email": "[e-mail]"

  },

  {

    "wb_status": "Complete"

  }

]

我需要这种格式；

[

  {

    "id": "981",

    "name": "jo",

    "username": "jo123",

    "email": "[e-mail]",

    "wb_status": "Complete"

  }

]

Answer 1

在第一个查询之前运行第二个查询并将元素添加到数组中foreach：// second query becomes first$db->setQuery("SELECT status AS wb_status FROM anothertable ");$wb = $db->loadObject();$wb_status = $wb->wb_status;$users_arr = array();// first query becomes second$db->setQuery("SELECT id, name, username, email FROM sometable WHERE name = '$name' ");$results = $db->loadObjectList();    foreach ($results as $result) {    $userid = $result->id;    $name = $result->name;    $username = $result->username;    $email= $result->email;    $users_arr[] = array(      "id" => $userid,       "name" => $name,       "username" => $username,       "email" => $email      "wb_status" => $wb_status, // Here    );}echo json_encode($users_arr);exit();更新：另一种方法是迭代$users_arr并向每个元素插入所需的数据：// ...$db->setQuery("SELECT status AS wb_status FROM anothertable ");$wb = $db->loadObject();$wb_status = $wb->wb_status;// I use `&` here so as to pass `$item` as a// reference to original item in `$users_arr`foreach ($users_arr as &$item) {    $item["wb_status"] = $wb_status;}echo json_encode($users_arr);exit();