对数组中的最后一个值进行排名,并将排名的数字循环到以前创建的数组中


Rank Last Values in Arrays and Loop Ranked Number into Previously Created Array?

我需要获取多维数组中每个数组的最后一个值,将它们相互比较,并将排序后的值放在之前创建的数组的末尾。

我的PHP:

//Arrays
$rsIdeas_array = array();
$total_rank_array = array();
//Get Data
//MySQL Select Queries Here
//loop bizideas into array
do {
//Calculate variables needed
$search_rank = round(($row_rsIdeas['monthlysearches'] / $row_rsMaxSearches['monthlysearches'] * 9) + 1, 1, PHP_ROUND_HALF_EVEN);
$competition_rank = round(10 - (($row_rsIdeas['advcomp'] / ($row_rsMaxCompetition['advcomp']) * 9)), 1, PHP_ROUND_HALF_EVEN);
$search_competition_ease = ($search_rank + $competition_rank + $row_rsIdeas['startease']);
$row_rsIdeas['search_rank'] = $search_rank;
$row_rsIdeas['competition_rank'] = $competition_rank;
$row_rsIdeas['search_competition_ease'] = $search_competition_ease;
$row_rsIdeas = array(
  'ideaID' => $row_rsIdeas['ideaID'],
  'userID' => $row_rsIdeas['userID'],
  'bizidea' => $row_rsIdeas['bizidea'],
  'bizexplained' => $row_rsIdeas['bizexplained'],
  'bizmodel' => $row_rsIdeas['bizmodel'],
  'repkeyword' => $row_rsIdeas['repkeyword'],
  'monthlysearches' => $row_rsIdeas['monthlysearches'],
  'search_rank' => $row_rsIdeas['search_rank'],
  'advcomp' => $row_rsIdeas['advcomp'],
  'competition_rank' => $row_rsIdeas['competition_rank'],
  'search_competition_ease' => $row_rsIdeas['search_competition_ease'],
);
array_push($rsIdeas_array, $row_rsIdeas);
array_push($total_rank_array, $search_competition_ease);
} while ($row_rsIdeas = mysql_fetch_assoc($rsIdeas));

这会产生

Array
(
[0] => Array
    (
        [ideaID] => 1
        [userID] => 1
        [bizidea] => Business Idea 1
        [bizexplained] => Business Idea 1 Explanation
        [bizmodel] => Utility
        [repkeyword] => Business Idea 1 Keyword
        [monthlysearches] => 33100
        [search_rank] => 1
        [advcomp] => 0.95
        [competition_rank] => 1.1
        [search_competition_ease] => 8.1 //Value to Rank From
    )
[1] => Array
    (
        [ideaID] => 2
        [userID] => 1
        [bizidea] => Business Idea 2
        [bizexplained] => Business Idea 2 Explained
        [bizmodel] => Service
        [repkeyword] => Business 2 Keyword
        [monthlysearches] => 6600
        [search_rank] => 1
        [advcomp] => 0.93
        [competition_rank] => 1.3
        [search_competition_ease] => 10.3 //Value to Rank From
    )
)

我有一个产生排名的部分:

arsort($total_rank_array); 
$rank = 1;
foreach($total_rank_array as $ideaId => $value) {
print('Rank: ' . $rank . '<br />Value: ' . $value . '<br />');
$rank++;

哪个创建(数字越高,排名越好):

Rank: 1
Value: 10.3
Rank: 2
Value: 8.1

我需要将这些值放在正确数组的末尾,而无需重新排列数组的顺序。下面是一个示例,说明我希望在已完成的数组中使用什么。

Array
(
[0] => Array
    (
        [ideaID] => 1
        [userID] => 1
        [bizidea] => Business Idea 1
        [bizexplained] => Business Idea 1 Explanation
        [bizmodel] => Utility
        [repkeyword] => Business Idea 1 Keyword
        [monthlysearches] => 33100
        [search_rank] => 1
        [advcomp] => 0.95
        [competition_rank] => 1.1
        [search_competition_ease] => 8.1
        [total_rank] => 2 //Here is where I need the additional value
    )
[1] => Array
    (
        [ideaID] => 2
        [userID] => 1
        [bizidea] => Business Idea 2
        [bizexplained] => Business Idea 2 Explained
        [bizmodel] => Service
        [repkeyword] => Business 2 Keyword
        [monthlysearches] => 6600
        [search_rank] => 1
        [advcomp] => 0.93
        [competition_rank] => 1.3
        [search_competition_ease] => 10.3
        [total_rank] => 1 //Here is where I need the additional value
    )
)

我怎样才能做到这一点?我很抱歉包含了这么多代码,我只是想确保我被完全理解。

提前非常感谢!

如果我理解您的代码,这应该可以工作:

arsort($total_rank_array);
foreach (array_keys($total_rank_array) as $i => $key)
{
    $rsIdeas_array[$key]['total_rank'] = $i+1;
}