使用 PHP 修改查询结果以返回更可用的数组

发布于 2024-11-10 12:24:40 字数 396 浏览 1 评论 0原文

嘿大家，我有一个查询结果作为带有活动记录的数组返回：

Array ( 
[0] => Array ( [name] => Betty Glassmaker ) 
[1] => Array ( [name] => John Johnson ) 
[2] => Array ( [name] => Bill Pratt ) 
)

但由于我的查询专门只要求名称列，我宁愿修改结果以反映此数组结构：

Array (
[0] => Betty Glassmaker 
[2] => John Johnson 
[3] => Bill Pratt
)

什么可能是获取结果的最简单方法我'我在找什么？

原文

Hey everyone,
I have a query result returned as an array with active record:

Array ( 
[0] => Array ( [name] => Betty Glassmaker ) 
[1] => Array ( [name] => John Johnson ) 
[2] => Array ( [name] => Bill Pratt ) 
)

But since my query specifically only asks for the name column, I would rather the results be modified to reflect this array structure:

Array (
[0] => Betty Glassmaker 
[2] => John Johnson 
[3] => Bill Pratt
)

What might be the easiest way to get the result I'm looking for?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

走过海棠暮 2024-11-17 12:24:41

你可以循环遍历你的数组，像这样（未经测试）

// $resultset is you multidimensional array

$optimised = Array();  // good habit to initialise before usage.

foreach($resultset as $key => $value){
   $optimised[] = $value['name'];
}

祝你好运！

You could loop through your array, something like this ( not tested )

// $resultset is you multidimensional array

$optimised = Array();  // good habit to initialise before usage.

foreach($resultset as $key => $value){
   $optimised[] = $value['name'];
}

Good-luck!

回复收藏 0 原文

~没有更多了~