php - php foreach循环中的HTML表，其中仅当元素等于表列标题名称时才填充单元格数据

Question

我使用以下方法在我的表格中创建了我的列标题:

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 是:

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
        )

)

这正是我想要的结果，因为 $round 不会总是产生相同数量的列。

我想要在这些标题下方的表格行中的数据只需要包含列标题名称的那些项目。

假设列标题是:<强>| -7 | -6 | -5 | -4 | -3 | -2 | -1 | 1 | 2 | 3 | 4 | 5 | 6 |基于上面的 foreach 循环。

然后我使用以下内容填充下一行中的第一列:

<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>

虽然它有效，但这只是因为我知道表中第一列的标题是 -7。我试图弄清楚如何仅显示那些与我的列标题相同的项目，以根据列标题显示在下一行中，以便我可以执行另一个 foreach 循环来显示我的表的其余部分。所以基本上，我需要做什么而不是上面的 -7？我完全是一片空白。

$match['match']['round'] 等于列标题。如果有帮助，下面是一个小样本 $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"}}]

我尝试使用以下方法重新索引数组:

$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;
    }
  }

期望的输出是这样的:

Answer 1

您可以使用字典来存储基于回合的所有匹配项:

<?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>