コード例 #1
0
function pullTeamsSelect($area)
{
    global $db;
    try {
        $teamsQuery = $db->prepare("SELECT * FROM teams WHERE area=:area ORDER BY name");
        $teamsQuery->execute(array(':area' => $area));
    } catch (PDOException $e) {
        exit("error in query");
    }
    while ($cur = $teamsQuery->fetch(PDO::FETCH_ASSOC)) {
        echo "<tr><td><input type='text' name='" . $cur['ID'] . "name' value=\"" . $cur['name'] . "\" /></td>";
        echo "<td><select name='" . $cur['ID'] . "lead'>";
        teamLeaderSelect($area, $cur['lead']);
        echo "</select></td></tr>";
    }
}
コード例 #2
0
<h1>Training Team Leaders</h1>
<h4>INSTRUCTIONS: After editing a team name or changing a team leader <br/>click "Submit Changes" BEFORE doing anything else or your changes will not be saved.</h4>
</div>
<form name='addTeam' method='post'>
	<div class='center'>
    <input type='button' name='newTeam' value="Insert New Team" onclick='$("#createTeamDialog").dialog("open")' />
	
    <input type='submit' class='button' name='submit' value="Submit Changes" /> 
     
	</div>
	<div name='results' id='results' class='center'>
	
	</div>
	<br/>
</form>

<div id="createTeamDialog" title = "Create New Team">
	<form id = "createTeam" name = "createTeam" method = "post" action = "insertTeam.php">
		<label for = "createTeamName">Team Name: </label>
		<input type = "text" id = "createTeamName" name = "createTeamName">
		
		<label for = "createTeamLeader">Team Leader: </lable>
		<select name = "createTeamLeader"><?php 
teamLeaderSelect($area, '');
?>
</select>
	</form>
</div>

<?php 
require '../includes/includeAtEnd.php';