//single elimination,double elimination or round robin $team_count = $_REQUEST['team_count']; $court_count = $_REQUEST['court_count']; $start_date = $_REQUEST['start_date']; $end_date = $_REQUEST['end_date']; if (!($token && $event_name && $start_date && $end_date && $tournament_type && $competition_level && $league_level && $team_count && $court_count)) { $success = "0"; $msg = "Incomplete Parameters"; $data = array(); } else { // +-----------------------------------+ // + STEP 3: perform operations + // +-----------------------------------+ $user_id = Users::getUserId($token); if ($user_id) { $event_id = Tournament::StartEvent($user_id, $competition_level, $league_level, $event_status); $sql = "SELECT * FROM event_tournament WHERE user_id=:user_id and event_id=:event_id"; $sth = $conn->prepare($sql); $sth->bindValue('user_id', $user_id); $sth->bindValue('event_id', $event_id); try { $sth->execute(); } catch (Exception $e) { } $tour = $sth->fetchAll(PDO::FETCH_ASSOC); if (!count($tour)) { $sql = "INSERT into event_tournament(id,user_id,event_id,tournament_name,tournament_type,team_count,court_count,start_date,end_date,created_on) \n\t\tVALUES(DEFAULT,:user_id,:event_id,:tournament_name,:tournament_type,:team_count,:court_count,:start_date,:end_date,UTC_TIMESTAMP())"; $sth = $conn->prepare($sql); $sth->bindValue('user_id', $user_id); $sth->bindValue('event_id', $event_id); $sth->bindValue('tournament_name', $event_name);