function addTeam($team, $p1, $p2 = "", $p3 = "") { $sql = "INSERT INTO mad_team(team, register_date) VALUES(:team, NOW())"; $parms = array(':team', $team); $result = DatabaseHandler::Execute($sql, $parms); $teamid = getTeamId($team); if ($p1) { $sql = "INSERT INTO mad_registrations(user_id, team_id) VALUES(:p1, :teamid)"; $parms = array(':p1' => $p1, ':teamid' => $teamid); $result = DatabaseHandler::Execute($sql, $parms); } if ($p2) { $sql = "INSERT INTO mad_registrations(user_id, team_id) VALUES(:p2, :teamid)"; $parms = array(':p2' => $p2, ':teamid' => $teamid); $result = DatabaseHandler::Execute($sql, $parms); } if ($p3) { $sql = "INSERT INTO mad_registrations(user_id, team_id) VALUES(:p3, :teamid)"; $parms = array(':p3' => $p3, ':teamid' => $teamid); $result = DatabaseHandler::Execute($sql, $parms); } return 1; }
<?php include_once 'interface.php'; if(isset($_POST['eventid'])) { echo json_encode(getTeamId($_POST['eventid'])); } if(isset($_POST['tatid'])){ echo json_encode(partEventList($_POST['tatid'])); } if(isset($_POST['rgeventid']) && isset($_POST['rgteamid']) && isset($_POST['rgcaptainid']) && isset($_POST['rgpart1']) && isset($_POST['rgpart2']) && isset($_POST['rgpart3']) && isset($_POST['rgpart4']) && isset($_POST['rgpart5']) && isset($_POST['rgpart6'])){ updateTeam($_POST['rgeventid'], $_POST['rgteamid'], $_POST['rgcaptainid'], $_POST['rgpart1'], $_POST['rgpart2'], $_POST['rgpart3'], $_POST['rgpart4'], $_POST['rgpart5'], $_POST['rgpart6']); }