function RegisterUser($username, $password, $name, $parentEmail, $avatarSetup, $avatarImage)
{
include_once '../config/Config.php';
$conn = new DatabaseConnect();
$mysqli = $conn->connect($db_host, $db_username, $db_password, $mysql_db);
//check valid email address if entered
if (!filter_var($parentEmail, FILTER_VALIDATE_EMAIL) && $parentEmail != null) {
echo "Please try your parent's email address again";
die;
}
$md5_password = md5($password);
$hash = md5(rand(1, 10000));
$add = new Child_Functions();
//Function which either adds or creates new family entry
$add->childFamilyAdd($parentEmail, $username);
//NEED TO INSERT ID NOT USERNAME
$queryEmReg = "SELECT '" . $username . "' FROM Child_Account WHERE email ='" . $email . "'";
$emailCheck = $mysqli->query($queryEmReg);
if (!mysqli_num_rows($emailCheck) < 1) {
echo 'Username already in use';
echo $queryEmReg;
} else {
$sql = "INSERT INTO Child_Account (Username,Password,Name,ParentsEmail,hash)\n\t\t\t\t\tVALUES (?,?,?,?,?)";
//avatarSetup,avatarImage,
$mail = new Child_Functions();
//prepared query statements
if ($stmt = $mysqli->prepare($sql)) {
$stmt->bind_param("sssss", $username, $md5_password, $name, $parentEmail, $hash);
$stmt->execute();
$stmt->bind_result($result);
if ($stmt->affected_rows > 0) {
echo 'Email sent';
$mail->VerificationParent($parentEmail, $name, $hash);
} else {
echo 'Error - could not register';
}
$stmt->close();
} else {
echo 'Failed register child database query';
echo $stmt->errno;
}
}
$connect->close();
}