<?php
$teams = array('All-Stars', 'Vets', 'Lightning', 'Bolt');
// HOW MANY WEEKS
$weeks = 3;
// MAKE ENOUGH ARRAY ELEMENTS FOR THE DISTRIBUTION
$array = array_merge($teams, $teams);
// POPULATE THE MATCHES ARRAY
$matches = array();
while ($weeks)
{
foreach ($teams as $ptr => $team)
{
// FIND THE INDEX INTO THE DISTRIBUTION ARRAY
$linkt = $ptr + $weeks;
// SELECT THE HOME AND AWAY TEAMS
$home = $team;
$away = $array[$linkt];
$matches[$team][$weeks] = array('home' => $home, 'away' => $away);
}
// NEXT WEEK
$weeks--;
}
// SORT THE MATCHES SENSIBLY SO WEEK ONE COMES FIRST
foreach ($matches as $team => $contests)
{
ksort($contests);
$matches[$team] = $contests;
}
// ACTIVATE THIS TO SEE WHAT THE $matches ARRAY LOOKS LIKE
// print_r($matches);
// CREATE THE TABLE OF MATCHUPS
$out = NULL;
$out .= "<table>";
$out .= PHP_EOL;
// CREATE THE HEADERS FOR EACH WEEK
$weeknums = end($matches);
$out .= "<tr>";
$out .= '<th> Team </th>';
$out .= '<th> v </th>';
$out .= "<th> Team </th>";
$out .= '</tr>';
$out .= PHP_EOL;
// CREATE THE MATRIX OF MATCHUPS
foreach ($matches as $team => $contests)
{
$out .= "<form class='form-horizontal' action='".$_SERVER['PHP_SELF']."'d method='post'><tr><td><input type='text' name='teamone' value='$team' readonly></td>";
$out .= "<td> <b>v</b></td>";
foreach ($contests as $week => $matchup)
{
// print_r($matchup);
$out .= "<td> <input type='text' name='teamtwo' value='{$matchup["away"]}' readonly> </td>";
}
$out .= "</tr>";
$out .= PHP_EOL;
}
$out .= "<input class='btn btn-primary' type='submit' name='submit'></form></table>";
$out .= PHP_EOL;
foreach ($matches as $team => $contests)
{
foreach ($contests as $week => $matchup)
{
print_r($matchup);
if(is_array($matchup)){
foreach($matchup as $key => $value){
$home = $matchup['home'];
$away = $matchup['away'];
echo "INSERT INTO tourn_fixtures(teamone, teamtwo) values ('$home', '$away')\n";
}
}
}
}
echo "</pre>";
//echo $out;
- Output for 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
- Array
(
[home] => All-Stars
[away] => Vets
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Vets')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Vets')
Array
(
[home] => All-Stars
[away] => Lightning
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Lightning')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Lightning')
Array
(
[home] => All-Stars
[away] => Bolt
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Bolt')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Bolt')
Array
(
[home] => Vets
[away] => Lightning
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Lightning')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Lightning')
Array
(
[home] => Vets
[away] => Bolt
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Bolt')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Bolt')
Array
(
[home] => Vets
[away] => All-Stars
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'All-Stars')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'All-Stars')
Array
(
[home] => Lightning
[away] => Bolt
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Bolt')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Bolt')
Array
(
[home] => Lightning
[away] => All-Stars
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'All-Stars')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'All-Stars')
Array
(
[home] => Lightning
[away] => Vets
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Vets')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Vets')
Array
(
[home] => Bolt
[away] => All-Stars
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'All-Stars')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'All-Stars')
Array
(
[home] => Bolt
[away] => Vets
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Vets')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Vets')
Array
(
[home] => Bolt
[away] => Lightning
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Lightning')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Lightning')
</pre>
- Output for 8.3.5
- Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
Array
(
[home] => All-Stars
[away] => Vets
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Vets')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Vets')
Array
(
[home] => All-Stars
[away] => Lightning
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Lightning')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Lightning')
Array
(
[home] => All-Stars
[away] => Bolt
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Bolt')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('All-Stars', 'Bolt')
Array
(
[home] => Vets
[away] => Lightning
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Lightning')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Lightning')
Array
(
[home] => Vets
[away] => Bolt
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Bolt')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'Bolt')
Array
(
[home] => Vets
[away] => All-Stars
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'All-Stars')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Vets', 'All-Stars')
Array
(
[home] => Lightning
[away] => Bolt
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Bolt')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Bolt')
Array
(
[home] => Lightning
[away] => All-Stars
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'All-Stars')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'All-Stars')
Array
(
[home] => Lightning
[away] => Vets
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Vets')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Lightning', 'Vets')
Array
(
[home] => Bolt
[away] => All-Stars
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'All-Stars')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'All-Stars')
Array
(
[home] => Bolt
[away] => Vets
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Vets')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Vets')
Array
(
[home] => Bolt
[away] => Lightning
)
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Lightning')
INSERT INTO tourn_fixtures(teamone, teamtwo) values ('Bolt', 'Lightning')
</pre>
preferences:
182.21 ms | 409 KiB | 175 Q