How can I generate a round robin tournament in PHP and MySQL?

by

I created a roundrobin function from scratch as i thought it might be easier to get the same results and also allowing me to use arrays filled with strings directly instead of numbers.

Because i pull a list of names from a database and add into an array i can now schedule this directly with below function. No extra step needed to link numbers to names etc.

Please feel free to try it and if it works then leave a comment.
I also have a version which allows for 2 way (home & return) schedule and or shuffle option. If somone is interested in that one then leave a coment as well.

<?php

/**
 * @author D.D.M. van Zelst
 * @copyright 2012
 */

function scheduler($teams){
    if (count($teams)%2 != 0){
        array_push($teams,"bye");
    }
    $away = array_splice($teams,(count($teams)/2));
    $home = $teams;
    for ($i=0; $i < count($home)+count($away)-1; $i++){
        for ($j=0; $j<count($home); $j++){
            $round[$i][$j]["Home"]=$home[$j];
            $round[$i][$j]["Away"]=$away[$j];
        }
        if(count($home)+count($away)-1 > 2){
            array_unshift($away,array_shift(array_splice($home,1,1)));
            array_push($home,array_pop($away));
        }
    }
    return $round;
}
?>

How to use, for example create an array like:

<?php $members = array(1,2,3,4); ?>

or

<?php $members = array("name1","name2","name3","name4"); ?>

then call the function to create your schedule based on above array:

<?php $schedule = scheduler($members); ?>

To display the resulted array schedule simply do like below or anyway you like:
This little code displays the schedule in a nice format but use it anyway you like.

<?php
foreach($schedule AS $round => $games){
    echo "Round: ".($round+1)."<BR>";
    foreach($games AS $play){
        echo $play["Home"]." - ".$play["Away"]."<BR>";
    }
    echo "<BR>";
}
?>

Leave a note if it worked for you or if you are interested in the 2-way version with shuffle.

More Related Contents:

  1. Prevent creating duplicate entries in PHP
  2. Query database then email posts from where user is subbed to
  3. Laravel – only a zero is saved to the database
  4. I am seeing this error on submitting form Error: query was empty [closed]
  5. PHP Merging Row with same value (more than one column)
  6. Reference: What is a perfect code sample using the MySQL extension? [closed]
  7. Convert from MySQL datetime to another format with PHP
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. Having issue with matching rows in the database using PDO
  10. How can I properly use a PDO object for a parameterized SELECT query
  11. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  12. Whether to use “SET NAMES”
  13. Escaping single quote in PHP when inserting into MySQL [duplicate]
  14. How can I get enum possible values in a MySQL database?
  15. Mechanisms for tracking DB schema changes [closed]
  16. Inserting data using mysqli
  17. Import file size limit in PHPMyAdmin
  18. Updating from MYSQL to MYSQLI [duplicate]
  19. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. How to display image from database using php [duplicate]
  22. Simple PHP SQL login troubleshooting
  23. php warning mysql_fetch_assoc
  24. Check if row exists in the database before inserting
  25. MySQL Table does not exist error, but it does exist
  26. How to create PHP two column table with values from the database?
  27. php, mysql – Too many connections to database error
  28. selected value get from db into dropdown select box option using php mysql error
  29. SELECT row by DATEPART()
  30. Create mysql trigger via PHP?

Leave a Comment