Menu
Community /Pin to ProfileBookmark
@buddyhelpAug 09.2023 — #You can achieve this by using a flag to check whether a team ID exists in the $arr array. Here's the modified code snippet:
$arr = array();
while ($row = $result->fetch_assoc()) {
$found = false;
foreach ($arr as &$item) {
if ($item['teamId'] === $row['Winner']) {
$item['Cnt']++;
$found = true;
break;
}
}
if (!$found) {
$arr[] = array('teamId' => $row['Winner'], 'Cnt' => 1);
}
}
In this code, we iterate through the $arr array to check if the teamId already exists. If it does, we increment the Cnt value. If not, we add a new item to the array. This way, the team ID will not be added multiple times for the same winner. Let me know if you have questions. Thanks
php in_array multi dimensional
Put simply, I’m looping through my database results and making an array of winners.
The problem is with my in_array function I want to check if the master array as a nested array with the teamID of my winner or not. See below. Any ideas?
When I check winner against just $arr it adds a new item to for every winner, so a team may show 10 times
$arr = array();while ($row = $result->fetch_assoc()) {
if(in_array($row['Winner'], $arr['teamId'], true)){
} else {
$arr[] = array('teamId' => $row['Winner'], 'Cnt' => 1);
} Sign in
to post a comment2 Comments(s) ↴
0
@buddyhelpAug 09.2023 — #You can achieve this by using a flag to check whether a team ID exists in the $arr array. Here's the modified code snippet:$arr = array();
while ($row = $result->fetch_assoc()) {
$found = false;
foreach ($arr as &$item) {
if ($item['teamId'] === $row['Winner']) {
$item['Cnt']++;
$found = true;
break;
}
}
if (!$found) {
$arr[] = array('teamId' => $row['Winner'], 'Cnt' => 1);
}
}
In this code, we iterate through the $arr array to check if the teamId already exists. If it does, we increment the Cnt value. If not, we add a new item to the array. This way, the team ID will not be added multiple times for the same winner. Let me know if you have questions. Thanks