function RegisterMember(User $newUser, $RegDate, $name, $image) { global $connection; // if (!find_member($Lname,$DOB)) { $query = "INSERT INTO members(id,Lname,Fname,Title,Gender,DOB,MemberImageName,MemberImage,Phone,Email,Program,Year,Hall,Parish,Subgroups,RegDate) \n\tVALUES(\n\t\t'',\n\t\t'{$newUser->getLastName()}',\n\t\t'{$newUser->getFirstName()}',\n\t\t'{$newUser->getTitle()}',\n\t\t'{$newUser->getGender()}',\n\t\t'{$newUser->getDateOfBirth()}',\n\t\t'{$name}',\n\t\t'{$image}',\n\t\t'{$newUser->getPhoneNumber()}',\n\t\t'{$newUser->getEmail()}',\n\t\t'{$newUser->getProgram()}',\n\t\t'{$newUser->getYear()}',\n\t\t'{$newUser->getHall()}',\n\t\t'{$newUser->getParish()}',\n\t\t'{$newUser->getSubGroup()}',\n\t\t'{$RegDate}'\n\t\t)"; // mysql_query($query,$connection); // // confirm_query($result_set); // if (mysql_affected_rows() == 1) { // echo "success"; // } // else { // echo "err2"; // } $mysqli = new Mysqli('localhost', 'root', 'PASSword1', 'paxromanadata'); return $mysqli->query($query); }