php part(registration.php)
- <?php
- session_start();
- include ("db_conn.php");
-
- if(isset($_POST['submit'])){
- function validate($data){
- $data = trim($data);
- $data = stripslashes($data);
- $data = htmlspecialchars($data);
- return $data;
- }
- $fatherName = validate($_POST['fatherName']);
- $firstName = validate($_POST['firstName']);
- $grandFatherName = validate($_POST['grandFatherName']);
- $gender = validate($_POST['gender']);
- $nationality = validate($_POST['nationality']);
- $residence = validate($_POST['residence']);
- $country = validate($_POST['country']);
- $regionOrState = validate($_POST['regionOrState']);
- $city = validate($_POST['city']);
- $email = validate($_POST['email']);
- $phone = validate($_POST['phone']);
- $department = validate($_POST['department']);
- $graYear = validate($_POST['year']);
- $studyLevel = validate($_POST['studyLevel']);
- $ocopation = validate($_POST['ocopation']);
- $comment = validate($_POST['comment']);
- $sql2 = "INSERT INTO mebmbertable(
- fatherName, firstName, grandFatherName, gender, nationality, residence, country, regionOrState, city, email, phone, department, graYear, studyLevel, ocopation, comment )
- VALUES
- ('$fatherName', '$firstName', '$grandFatherName', '$gender','$nationality', '$residence', '$country', '$regionOrState', '$city', '$email', '$phone', '$department', '$graYear', '$studyLevel', '$ocopation', '$comment')";
- if (!mysqli_query($conn, $sql2)) {
- echo " Your account has been created successfully. Please login... ";
- }else {
- header("error=unknown error occurred");
- }
- }
- ?>
HTML PART(registrationForm.php)