排序在PHP多维数组 [英] Sorting multidimensional array in PHP
问题描述
我目前正在建立一个由值从MySQL查询排序方法。
I am currently creating a sorting method that consists of values from an mysql query.
下面是该阵列的简要观点：
Here's a brief view of the array:
Array
(
[0] => Array
(
['id'] = 1;
['countries'] = 'EN,CH,SP';
)
[1] => Array
(
['id'] = 2;
['countries'] = 'GE,SP,SV';
)
)
我已经成功地使基础上的数字ID值正常usort，但我宁愿希望通过现场的国家的内容排序的数组（如果它包含了一组字符串，一国code在这种情况下），然后由id字段
I have succeeded in making a normal usort based on the numeric id values, but I rather want to sort the array by the content of the "countries" field (if it contains a set string, a country code in this case), and then by the id field.
下面的代码片段是我的怎么办呢最初的想法，但我不知道如何把它合并到工作理念的功能：
The following snippet was my first idea of how to do it, but I have no idea of how to incorporate it into an working function:
in_array('EN', explode(",",$a['countries']) );
你会怎么做呢？
谢谢！
我真的这个不幸的是一事无成。
I am really getting nowhere with this unfortunately.
下面是我的时刻，它给了我什么，但错误： uasort（）[function.uasort]：无效的比较函数
Here is what I have for the moment, and its giving me nothing but errors: uasort() [function.uasort]: Invalid comparison function
function compare($a, $b) {
global $usercountry;
if ( in_array($usercountry, $a['countries']) && in_array($usercountry, $a['countries']) ) {
$return = 0;
}
else if (in_array($usercountry, $a['countries'])) {
$return = 1;
}
else {
$return = -1;
}
return $return;
}
$array= usort($array, "compare");
是否有任何人谁可以给我一个如何与它去一个暗示？
Is there anyone who might give me a hint of how to go on with it?
推荐答案
就个人而言，我会配合使用自定义（匿名）函数的 usort（） 。
Personally, I would use a custom (anonymous) function in conjunction with usort().
编辑 - 重新您的评论。希望这将让你在正确的轨道上。该功能提供了相同的优先级，以二者均具有EN，或者都没有EN或调整的优先内容时，只是一个有EN。
Re - your comment. Hopefully this will put you on the right track. This function gives equal priority to elements which both have EN or neither have EN, or adjusted priority when just one has EN.
usort($array,function ($a, $b) {
$ac = strpos($a['countries'],'EN');
$bc = strpos($a['countries'],'EN');
if (($ac !== false && $bc !== false) || ($ac == false && $bc == false)) {
return 0;
}
elseif ($ac !== false) {
return 1;
}
else {
return -1;
}
});
此功能，在另一方面，给出了相同的优先级，如果双方都有EN，更高，如果一个人EN，并执行文本比较，如果既没有EN。
This function, on the other hand, gives equal priority if both have EN, higher if one has EN, and does a text comparison if neither has EN.
usort($array,function ($a, $b) {
$ac = strpos($a['countries'],'EN');
$bc = strpos($a['countries'],'EN');
if ($ac !== false && $bc !== false)) {
return 0;
}
elseif ($ac !== false) {
return 1;
}
elseif ($bc !== false) {
return -1;
}
else {
if ($a['countries'] == $b['countries']) {
return 0;
}
elseif($a['countries'] > $b['countries']) {
return 1;
}
else {
return -1;
}
}
});
再次希望这会给你足够的方向在自己的前进。如果您有任何问题，随意张贴更多的意见，我会尽力帮助。 如果你绑多个属性，重量比较的注意事项：尝试一个时髦的开关模块，例如
Again, hopefully this will give you enough direction to move forward on your own. If you are having any problems, feel free to post more comments and I'll try to help. A note if you're tying to compare multiple properties with weight: try out a funky switch block, e.g.
$ac = array_flip(explode(',',$a['countries']));
$bc = array_flip(explode(',',$b['countries']));
switch (true) {
case array_key_exists('EN',$ac) && !array_key_exists('EN',$bc):
return 1;
case array_key_exists('DE',$ac) && !array_key_exists('EN',$bc) && !array_key_exists('EN',$bc):
return 1;
// and so on
}
其实，我想更复杂的排序问题，我想出了以下的解决方案，供大家参考。这将允许你定义在此基础上会出现在国家索引关键字数字排名。这里是code，其中包括一个例子：
Actually, I was thinking more on the problem of complex sorting, and I have come up with the following solution, for your consideration. It will allow you to define numerical rankings based on keywords which would appear in the countries index. Here is the code, including an example:
示例阵列
$array = array(
array(
'countries' => 'EN,DE,SP',
),
array(
'countries' => 'EN,CH,SP',
),
array(
'countries' => 'DE,SP,CH',
),
array(
'countries' => 'DE,SV,SP',
),
array(
'countries' => 'EN,SP,FR',
),
array(
'countries' => 'DE,FR,CH',
),
array(
'countries' => 'CH,EN,SP',
),
);
排序例程
$rankings = array(
'EN' => 10,
'SP' => 8,
'FR' => 7,
'DE' => 5,
'CH' => 3,
'SV' => 1,
);
usort($array, function (&$a, &$b) use ($rankings) {
if (isset($a['_score'])) {
$aScore = $a['_score'];
}
else {
$aScore = 0;
$aCountries = explode(',',$a['countries']);
foreach ($aCountries as $country) {
if (isset($rankings[$country])) {
$aScore += $rankings[$country];
}
}
$a['_score'] = $aScore;
}
if (isset($b['_score'])) {
$bScore = $b['_score'];
}
else {
$bScore = 0;
$bCountries = explode(',',$b['countries']);
foreach ($bCountries as $country) {
if (isset($rankings[$country])) {
$bScore += $rankings[$country];
}
}
$b['_score'] = $bScore;
}
if ($aScore == $bScore) {
return 0;
}
elseif ($aScore > $bScore) {
return -1;
}
else {
return 1;
}
});
注：此code将在排名最高的entires排序的数组的顶部。如果你想扭转行为，更改此：
Note: This code will sort the highest ranking entires to the top of the array. If you want reverse behavior, change this:
elseif ($aScore > $bScore) {
到
elseif ($aScore < $bScore) {
注意，改变为一个小于符号大于-进行此更改将导致在排名最低的项目进行排序的数组的顶部。希望这一切都有助于！
Note that the greater-than was changed to a less-than symbol. Making this change will result in the lowest ranking entries being sorted to the top of the array. Hope all this helps!
这code将使一个小的变化，以您的数组，因为它增加了_score元素每个阵列。但愿这不是一个问题，因为通过存储这个数值我是从字面上能够通过增加一倍以上（0.00038，0.00041降至0.00016，0.00018在我的基准测试），以提高速度。如果没有，删除获取的缓存值如果块，并让其他块执行每一次的内容，当然除了用于存储的得分值的部分。
This code will make a small change to your array, in that it adds the _score element to each array. Hopefully this is not a problem, as by storing this value I was literally able to increase speed by more than double (.00038-.00041 down to .00016-.00018 in my benchmarks). If not, remove the if blocks that retrieve the cached value and let the contents of the else blocks execute every time, except of course for the part which stores the score value.
顺便说一句，这里有一个 var_export（）数组的转储有人排序之后：
By the way, here's a var_export() dump of the array after it was sorted:
array (
0 => array (
'countries' => 'EN,SP,FR',
'_score' => 25,
),
1 => array (
'countries' => 'EN,DE,SP',
'_score' => 23,
),
2 => array (
'countries' => 'EN,CH,SP',
'_score' => 21,
),
3 => array (
'countries' => 'CH,EN,SP',
'_score' => 21,
),
4 => array (
'countries' => 'DE,SP,CH',
'_score' => 16,
),
5 => array (
'countries' => 'DE,FR,CH',
'_score' => 15,
),
6 => array (
'countries' => 'DE,SV,SP',
'_score' => 14,
),
)
享受！
这篇关于排序在PHP多维数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
