I have created my column headers in my table by using:
if (count($round) > 0): ?>
<table>
<thead>
<tr>
<?php foreach ($round as $colhead): array_map('htmlentities', $colhead); ?>
<th><?php echo implode('</th><th>',$colhead); ?></th>
</tr>
<?php endforeach; endif;
?>
</thead>
$round
is:
Array
(
[0] => Array
(
[32] => -7
[31] => -6
[29] => -5
[27] => -4
[23] => -3
[19] => -2
[17] => -1
[0] => 1
[2] => 2
[10] => 3
[14] => 4
[16] => 5
[33] => 6
)
)
This results in exactly what I want because $round
won’t always result in the same number of columns.
The data I want in the table row beneath those headers needs to be only those items that contain the column header’s name.
Let’s say the column headers are:
| -7 | -6 | -5 | -4 | -3 | -2 | -1 | 1 | 2 | 3 | 4 | 5 | 6 |
based on the foreach
loop above.
I used the following to then populate my first column in the next row:
<tbody>
<tr>
<td>
<?php foreach ($matches as $match) {
$firstCharacter = $match['match']['scores_csv'][0];
$lastCharacter = $match['match']['scores_csv'][-1];
$id1 = $match['match']['player1_id'];
$id2 = $match['match']['player2_id'];
if ($match['match']['round'] === -7)
echo "Table: ".$match['match']['player1_votes']."</br>".$participants[$id1]["name"].$participants[$id1]['misc'].": ".$firstCharacter. "</br>".$participants[$id2]["name"].$participants[$id2]['misc'].":".$lastCharacter. "</br>";
}
?>
</td>
</tr>
</tbody>
</table>
And while it works, it’s only because I know the header of my first column in the table is -7. I’m trying to figure out how to only display those items that are equal to my column header to display in the following row based on the column header so that I can then do another foreach loop to display the remainder of my table. So basically, instead of -7 that I have above, what do I need to do? I’m completely drawing a blank.
$match[‘match’][’round’] is what is equal to the column headers. And a small sample $matches is below in case that helps.
[{"match":{"id":246811883,"tournament_id":10128202,"state":"complete","player1_id":152239163,"player2_id":152239166,"player1_prereq_match_id":null,"player2_prereq_match_id":null,"player1_is_prereq_match_loser":false,"player2_is_prereq_match_loser":false,"winner_id":152239166,"loser_id":152239163,"started_at":"2021-08-07T01: 59: 51.967+02: 00","created_at":"2021-08-07T01: 59: 51.692+02: 00","updated_at":"2021-08-07T02: 22: 29.417+02: 00","identifier":"A","has_attachment":false,"round":1,"player1_votes":1,"player2_votes":null,"group_id":null,"attachment_count":null,"scheduled_time":null,"location":null,"underway_at":"2021-08-07T02: 05: 31.834+02: 00","optional":false,"rushb_id":null,"completed_at":"2021-08-07T02: 22: 29.455+02: 00","suggested_play_order":null,"forfeited":null,"open_graph_image_file_name":null,"open_graph_image_content_type":null,"open_graph_image_file_size":null,"prerequisite_match_ids_csv":"","scores_csv":"0-2"}},{"match":{"id":246811884,"tournament_id":10128202,"state":"complete","player1_id":152239594,"player2_id":152239168,"player1_prereq_match_id":null,"player2_prereq_match_id":null,"player1_is_prereq_match_loser":false,"player2_is_prereq_match_loser":false,"winner_id":152239594,"loser_id":152239168,"started_at":"2021-08-07T01: 59: 51.984+02: 00","created_at":"2021-08-07T01: 59: 51.698+02: 00","updated_at":"2021-08-07T02: 32: 30.655+02: 00","identifier":"B","has_attachment":false,"round":1,"player1_votes":2,"player2_votes":null,"group_id":null,"attachment_count":null,"scheduled_time":null,"location":null,"underway_at":"2021-08-07T02: 05: 23.667+02: 00","optional":false,"rushb_id":null,"completed_at":"2021-08-07T02: 32: 30.690+02: 00","suggested_play_order":null,"forfeited":null,"open_graph_image_file_name":null,"open_graph_image_content_type":null,"open_graph_image_file_size":null,"prerequisite_match_ids_csv":"","scores_csv":"2-1"}}]
I’ve attempted to reindex the array by using:
$matchesa = array_column($matches, 'match');
$matchesa = array_column($matchesa, null, 'round');
foreach ( $matches as $match ) {
$id1 = $match['match']['round'];
{
echo $matchesa[$id1]['round'].PHP_EOL;
}
}
Advertisement
Answer
You can use a dictionary to store all the matches based on the rounds:
<?php
/*#########SAMPLE DATA########*/
$matches = <<<MATCHES
[{"match":{"id":246811883,"tournament_id":10128202,"state":"complete","player1_id":152239163,"player2_id":152239166,"player1_prereq_match_id":null,"player2_prereq_match_id":null,"player1_is_prereq_match_loser":false,"player2_is_prereq_match_loser":false,"winner_id":152239166,"loser_id":152239163,"started_at":"2021-08-07T01: 59: 51.967+02: 00","created_at":"2021-08-07T01: 59: 51.692+02: 00","updated_at":"2021-08-07T02: 22: 29.417+02: 00","identifier":"A","has_attachment":false,"round":1,"player1_votes":1,"player2_votes":null,"group_id":null,"attachment_count":null,"scheduled_time":null,"location":null,"underway_at":"2021-08-07T02: 05: 31.834+02: 00","optional":false,"rushb_id":null,"completed_at":"2021-08-07T02: 22: 29.455+02: 00","suggested_play_order":null,"forfeited":null,"open_graph_image_file_name":null,"open_graph_image_content_type":null,"open_graph_image_file_size":null,"prerequisite_match_ids_csv":"","scores_csv":"0-2"}},{"match":{"id":246811884,"tournament_id":10128202,"state":"complete","player1_id":152239594,"player2_id":152239168,"player1_prereq_match_id":null,"player2_prereq_match_id":null,"player1_is_prereq_match_loser":false,"player2_is_prereq_match_loser":false,"winner_id":152239594,"loser_id":152239168,"started_at":"2021-08-07T01: 59: 51.984+02: 00","created_at":"2021-08-07T01: 59: 51.698+02: 00","updated_at":"2021-08-07T02: 32: 30.655+02: 00","identifier":"B","has_attachment":false,"round":1,"player1_votes":2,"player2_votes":null,"group_id":null,"attachment_count":null,"scheduled_time":null,"location":null,"underway_at":"2021-08-07T02: 05: 23.667+02: 00","optional":false,"rushb_id":null,"completed_at":"2021-08-07T02: 32: 30.690+02: 00","suggested_play_order":null,"forfeited":null,"open_graph_image_file_name":null,"open_graph_image_content_type":null,"open_graph_image_file_size":null,"prerequisite_match_ids_csv":"","scores_csv":"2-1"}}]
MATCHES;
$round = <<<ROUND
[-7, -6, -5, -4, -3, -2, -1, 1, 2, 3, 4, 5, 6]
ROUND;
$matches = json_decode($matches, true);
$round = json_decode($round);
/*###########################*/
//class to define data when we found a match
class MatchInfo {
public $firstCharacter;
public $lastCharacter;
public $player1Votes;
public $player1Name;
public $player1Misc;
public $player2Name;
public $player2Misc;
}
$tableHeaders = null;
$matchInfoData = [];
//$participants = [...]
if (!empty($round)) { //if we have round
//get the html for table headers
$tableHeaders = array_map(function($colHead){
return "<th>Round: {$colHead}</th>";
}, $round);
$tableHeaders = implode("", $tableHeaders);
//remove item in matches
while ($match = array_pop($matches)) {
$targetRound = $match['match']['round'];
if (!in_array($targetRound, $round)) continue; //skip item if match round is not in our column
if (!array_key_exists($targetRound, $matchInfoData)) { //if we never look at this round before
$matchInfoData[$targetRound] = []; //initialize array to hold other match based on the round
}
$id1 = $match['match']['player1_id'];
$id2 = $match['match']['player2_id'];
//new up and save off the data
$matchInfo = new MatchInfo();
$matchInfo->firstCharacter = $match['match']['scores_csv'][0];
$matchInfo->lastCharacter = $match['match']['scores_csv'][-1];
$matchInfo->player1Votes = $match['match']['player1_votes'];
$matchInfo->player1Name = "Player1 Name"; //$participants[$id1]["name"];
$matchInfo->player1Misc = "Player1 Misc"; //$participants[$id1]["misc"];
$matchInfo->player2Name = "Player2 Name"; //$participants[$id2]["name"];
$matchInfo->player2Misc = "Player2 Misc"; // $participants[$id2]["misc"];
$matchInfoData[$targetRound][] = $matchInfo; //add data to the round...array_push
}
}
//if no matches found exit
if (empty($matchInfoData)) {
echo "No match info";
exit;
}
$tableData = '';
//now we loop through all the array to be sure its the same order as the ths
foreach ($round as $td) {
$columnHtml = '';
if (array_key_exists($td, $matchInfoData)) { //if what we stored contains the targeted column
//create a td html
$dataHtmlArray = array_map(function(MatchInfo $curItem){
return <<<ITEMDATA
<div class="match-info">
Table: {$curItem->player1Votes} <br/>
{$curItem->player1Name} {$curItem->player1Misc} {$curItem->firstCharacter} <br/>
{$curItem->player2Name} {$curItem->player2Misc} {$curItem->lastCharacter } <br/>
</div>
ITEMDATA;
},$matchInfoData[$td]);
$dataHtml = implode("<br/>", $dataHtmlArray);
$columnHtml = "<td><div class='match-container'> {$dataHtml} </div></td>";
}else { //otherwise it needs a blank td to go to next column
$columnHtml = "<td></td>";
}
$tableData .= $columnHtml;
}
?>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.0/dist/css/bootstrap.min.css" integrity="sha384-KyZXEAg3QhqLMpG8r+8fhAXLRk2vvoC2f3B09zVXn8CA5QIVfZOJ3BCsw2P0p/We" crossorigin="anonymous">
<table class="table table-bordered">
<thead>
<tr><?php echo $tableHeaders; ?></tr>
</thead>
<tbody>
<tr>
<?php echo $tableData; ?>
</tr>
</tbody>
</table>
<style>
.match-info {
border: 1px solid #dadde5;
padding: 24px;
border-radius: 4px;
}
</style>