我查询了数据库,并将结果存储到数组中.看起来像这样:
Array
(
[0] => Array
(
[Submission_ID] => 111
[First_Name] => Dylan
[Last_Name] => Taylor
[Abstract_Title] => Research 1
)
[1] => Array
(
[Submission_ID] => 222
[First_Name] => Michael
[Last_Name] => Jones
[Abstract_Title] => Research 2
)
[2] => Array
(
[Submission_ID] => 333
[First_Name] => Wills
[Last_Name] => Adams
[Abstract_Title] => Research 3
)
)
所有这些都放在一个名为$results的变量中.目前,我正在页面上显示一些数据,如下所示:
echo $results[0][Abstract_Title]
一切正常,但是,如果将索引键替换为提交ID,则很方便:
Array
(
[111] => Array
(
[Submission_ID] => 111
[First_Name] => Dylan
[Last_Name] => Taylor
[Abstract_Title] => Research 1
)
[222] => Array
(
[Submission_ID] => 222
[First_Name] => Michael
[Last_Name] => Jones
[Abstract_Title] => Research 2
)
[333] => Array
(
[Submission_ID] => 333
[First_Name] => Wills
[Last_Name] => Adams
[Abstract_Title] => Research 3
)
)
因此,我可以改为执行此操作(否则,我每次都必须打印该数组以查找索引键):
echo $results[111][Abstract_Title]
有任何想法吗? (我是编程的新手.)我找到的最接近的答案是:php replace array id keys,但我无法解决这个问题.我以为forloop是最好的选择?新数组应该放在相同变量还是新变量中?
解决方法:
$final_result = array_combine(array_column($result,'Submission_ID'),$result);
print_r($final_result);
标签:arrays,php
来源: https://codeday.me/bug/20191026/1939979.html