<?php
ob_start();
session_start();

$_SESSION['tournamentName'] = $_POST["tourName"];
$_SESSION['nrOfPlayers'] = $_POST["nrOfPlayers"];
$_SESSION['startDate'] = date("Y-m-d");

include 'functions/htmlFunctions.php';
echo showHtmlHead("FIFA - New Tournament");

    $hostname = "kimjansson.se.mysql";
    $username = "kimjansson_se";
    $database = "kimjansson_se";
    $dbpass = "jRFYRD9h";

    $connect = mysql_connect($hostname, $username, $dbpass);
    if (!$connect) {
        echo "Can not connect to database";
    } else {
        mysql_select_db($database);
        mysql_set_charset('utf8');
    }

    $query1 = "SELECT name FROM USERS ORDER BY name ASC";
    $result1 = mysql_query($query1) or die('Error, query failed');

    $nameArray = array();
    while ($row=mysql_fetch_array($result1)) {
        $nameArray[]=$row[0];
    }

    $query2 = "SELECT name FROM TEAMINFO ORDER BY name ASC";
    $result2 = mysql_query($query2) or die('Error, query failed');

    $teamArray = array();

    while ($row=mysql_fetch_array($result2)) {
        $teamArray[]=$row[0];
    }

     echo "<div id=\"main\">";
     echo "Namn: " . $_SESSION['tournamentName'] . "<br/>";
     echo "Nr: " . $_SESSION['nrOfPlayers'] . "<br/>";
     echo "Date: " . $_SESSION['startDate'] . "<br/><br/><br/>";

   echo "<table><form action=\"insTourUsersData.php\" method=\"post\">";
     for ($nr=1; $nr<=$_SESSION['nrOfPlayers']; $nr++) {
        echo "<tr><td>Spelare nr " . $nr . "</td>
                  <td><select name=\"playername[]\" >";
        foreach ($nameArray as $key => $value )
            {
               echo "<option value=\"$value\">".$value."</option>";
                            }
               echo "</select></td>
               <td><select name=\"teamName\">";
        foreach ($teamArray as $key1 => $value1 )
            {
               echo "<option value=\"$value1\">".$value1."</option>";
                            }
               echo "</select></td></tr>";
     }
     unset($nameArray);
echo "<tr><td colspan=\"2\"><input type=\"submit\" /></td></tr></form></table></div>";
echo showHtmlFooter();

ob_end_flush()
        ?>