function AddRelative($firstname, $lastname, $nickname, $email, $inviteeEmail)
{
include_once '../config/Config.php';
$conn = new DatabaseConnect();
$mysqli = $conn->connect($db_host, $db_username, $db_password, $mysql_db);
//check valid email address
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo "Please enter a valid email address";
die;
} else {
$queryEmReg = "SELECT * FROM parents WHERE email ='" . $email . "'";
$emailCheck = $mysqli->query($queryEmReg);
if (!mysqli_num_rows($emailCheck) < 1) {
echo 'Email address in use';
} else {
$sql = "INSERT INTO parents (FirstName, LastName, NickName, Email)\n\t\t\t\t\t\tVALUES (?,?,?,?)";
$sqlFam = "INSERT INTO Families (Parent2)\n\t\t\t\t\t\t\tVALUES (?,?,?,?)";
$mail = new Parents();
//prepared query statements
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("ssss", $firstname, $lastname, $nickname, $email);
$stmt->execute();
$stmt->bind_result($result);
if ($stmt->affected_rows > 0 && scrollParents($email, $inviteeEmail)) {
echo 'Email sent';
$mail->RelativeVerification($email, $firstname);
} else {
echo 'Error - could not register';
}
$stmt->close();
} else {
echo 'Failed query';
}
}
}
$connect->close();
}
