从查询结果 PHP 添加键值对 - key value pair addition from query result, php

key value pair addition from query result, php

本文关键字：添加键值对 PHP 结果查询 | 更新日期: 2023-09-27

我在下面遇到了一些问题，想要将查询结果"id"添加为值"concat"的键 - 我需要为此提供一个foreach吗？最好的方法是什么？

$concatCol = mysqli_query( $connS, "SELECT id, ShipmentNumber, InvoiceNumber, BillofLading from testTable");
$data =array();
while ($row = mysqli_fetch_array($concatCol)) {
    $id = $row["id"];
    $ShipmentNumber = $row["ShipmentNumber"];
    $InvoiceNumber = $row["InvoiceNumber"];
    $BillofLading = $row["BillofLading"];
    $concat = $ShipmentNumber.$InvoiceNumber.$BillofLading;
    echo $concat."<br>";
    $data[] = $concat;
}

我不太确定你的预期输出是什么。但我认为以下方法之一对您有用：

$data[]['id'] = $concat;

这将导致如下数组：

Array
(
  [0] => Array
  (
    [id] => ShipmentNumberInvoiceNumberBillofLanding
  )
  [1] => Array
  (
    [id] => ShipmentNumberInvoiceNumberBillofLanding
  )
)

第二个选项是：

$data[$id] = $concat;

这将产生如下结果：

Array
(
  [1] => ShipmentNumberInvoiceNumberBillofLanding
  [4] => ShipmentNumberInvoiceNumberBillofLanding
)

其中键1和4是每个返回行的$id。在这两个示例中，ShipmentNumberInvoiceNumberBillofLanding当然是每行的串联值。