我使用以下代码来循环遍历我的数据库中的一个表:
我会得到这个:
我得到了下面奇怪的结果,不太是我想要的:
理想情况下,我认为它应该返回这个:
我该怎么做才能搞定它?是我使用了错误的PHP语法/默认函数吗?
$items_thread = $connection -> fetch_all($sql);
如果我将数组打印出来:
print_r($items_thread);
我会得到这个:
Array
(
[0] => Array
(
[RecipientID] => 3
[RecipientScreenname] => Tom L
[RecipientFirstname] => Thomas
[RecipientEmail] => info@xx.com
)
[1] => Array
(
[RecipientID] => 3
[RecipientScreenname] => Tom L
[RecipientFirstname] => Thomas
[RecipientEmail] => info@xx.com
)
[2] => Array
(
[RecipientID] => 1
[RecipientScreenname] => Lau T
[RecipientFirstname] => TK
[RecipientEmail] => lau@xx.co.uk
)
)
但我想要从数组中去除重复项,所以我使用了array_unique
函数。
print_r(array_unique($items_thread));
我得到了下面奇怪的结果,不太是我想要的:
以下是需要翻译的内容:
Array
(
[0] => Array
(
[RecipientID] => 3
[RecipientScreenname] => Tom L
[RecipientFirstname] => Thomas
[RecipientEmail] => info@xx.com
)
)
理想情况下,我认为它应该返回这个:
Array
(
[0] => Array
(
[RecipientID] => 3
[RecipientScreenname] => Tom L
[RecipientFirstname] => Thomas
[RecipientEmail] => info@xx.com
)
[1] => Array
(
[RecipientID] => 1
[RecipientScreenname] => Lau T
[RecipientFirstname] => TK
[RecipientEmail] => lau@xx.co.uk
)
)
我该怎么做才能搞定它?是我使用了错误的PHP语法/默认函数吗?
array_unique()
会将所有的数组缩减为一个,因为它将内部数组比较为字符串,并且所有的数组都会被评估为Array
。因此每个数组都被视为相同。此外,在手册中指出:"请注意,array_unique()
不适用于多维数组。" - BoltClock