<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

include "db-con.php";

if (isset($_REQUEST['submit'])) {
	$member_id = $_POST['member_id'];
	$member_name = $_POST['member_name'];
	$member_address = $_POST['member_address'];
	$issue_date = $_POST['issue_date'];
	//$end_date = $_POST['end_date'];
	$membership_plan = $_POST['membership_plan'];
	$type_board_affiliation = $_POST['type_board_affiliation'];
    $status_school_management = $_POST['status_school_management'];
    // $authorised_person = $_POST['authorised_person'];
    $auth_details = $_POST['auth_details'];
    $contact_number  = $_POST['contact_number'];
    $email  = $_POST['email'];
	
	$membership_no = $_POST['membership_no'];

 	$issue_Cmonth = date("m", strtotime($issue_date));

    $issue_fyear = date("Y", strtotime($issue_date));

    $issue_Uyear= $issue_fyear+1;
	if($issue_Cmonth == 01 || $issue_Cmonth == 02 || $issue_Cmonth == 03){

	//echo $issue_fyear;

	}else{

	//echo $issue_Uyear;

	};

	$final_end_date = "31-03-".$issue_Uyear;

	$contiunue = "Lifetime";


	if($membership_plan == "Annual"){

        // 	$updateData = "UPDATE membership SET member_id = '$member_id', member_name= '$member_name', member_address= '$member_address', issue_date= '$issue_date', end_date= '$final_end_date', membership_plan= '$membership_plan', type_board_affiliation='$type_board_affiliation', status_school_management='$status_school_management', authorised_person='$authorised_person', member_no='$membership_no' WHERE member_id = '$member_id'";
        $updateData = "UPDATE membership SET member_id = '$member_id', member_name= '$member_name', member_address= '$member_address', issue_date= '$issue_date', end_date= '$final_end_date', membership_plan= '$membership_plan', type_board_affiliation='$type_board_affiliation', status_school_management='$status_school_management', authorised_person_contact_details='$auth_details', contact_number='$contact_number', email='$email', member_no='$membership_no' WHERE member_id = '$member_id'";

	}else{

        // 	$updateData = "UPDATE membership SET member_id = '$member_id', member_name= '$member_name', member_address= '$member_address', issue_date= '$issue_date', end_date= '$contiunue', membership_plan= '$membership_plan', type_board_affiliation='$type_board_affiliation', status_school_management='$status_school_management', authorised_person='$authorised_person', member_no= '$membership_no' WHERE member_id = '$member_id'";
        $updateData = "UPDATE membership SET member_id = '$member_id', member_name= '$member_name', member_address= '$member_address', issue_date= '$issue_date', end_date= '$contiunue', membership_plan= '$membership_plan', type_board_affiliation='$type_board_affiliation', status_school_management='$status_school_management', authorised_person_contact_details='$auth_details', contact_number='$contact_number', email='$email', member_no= '$membership_no' WHERE member_id = '$member_id'";

	}
	
    $result = $con->query($updateData) or die("query error");
	
	    if ($result == TRUE) {

	        $con->close();	

	    	header("Location: https://ais.org.in/digitalcertificate/member_edit.php?id=$member_id");
	        exit;


		}else{


		}


}else{

	echo "No post";
}






?>