$result = mysqli_query($db, $query);
$user[] = mysqli_affected_rows($db);
$query = "Select * from teams where name ='" . $_POST['team'] . "'";
$result = mysqli_query($db, $query);
$team = mysqli_affected_rows($db);
if ($user[0] > 0 || $user[1] > 0 || $user[2] > 0) {
$errors[] = "<p>Entered user already exists.</p>";
}
if ($team > 0) {
$errors[] = "<p>Entered team name already exists.</p>";
}
if (count($errors) == 0) {
insertUser($db, 1);
insertUser($db, 2);
insertUser($db, 3);
insertTeam($db);
}
} else {
$errors[] = "<p>Enter unique phone numbers for each team member</p>";
}
}
}
}
?>
<article id="main">
<header>
<h2>Register your team</h2>
</header>
<section class="wrapper style5" id="r_page">
<div class="inner">
<?php
include 'connect.php';
include 'teams.php';
$con = connect();
insertTeam($con, $_POST);
disconnect($con);
// redirect to teams
header('Location: teams.php');
?>
