<?php

	session_start();

	include 'connection.php';

	$hostname = "localhost";
	$database = "cccm_db";

	$username = "test";
	$password = "test";

	//Instansiate Variables to $_POST

		// Client Table Variables
			$first_name = $_POST['fname'];
			$last_name = $_POST['lname'];
			$DOB = $_POST['dob'];
			$phone = $_POST['phone'];
			$street = $_POST['street'];
			$suburb = $_POST['suburb'];
			$postcode = $_POST['postcode'];
			switch($_POST['state'])
		    {
		      case "act": $state = "Australian Capital Territory"; break;
		      case "nsw": $state = "New South Wales"; break;
			  case "nt": $state = "Northern Territory"; break;
			  case "qld": $state = "Queensland"; break;
			  case "sa": $state = "South Australia"; break;
		      case "tas": $state = "Tasmania"; break;
		      case "vic": $state = "Victoria"; break;
			  case "wa": $state = "Western Australia"; break;
		      default: echo("Error!"); exit(); break;
		    }

		// Caretaker Table Variables
			$caretaker_fname = $_POST['caretakerFirstName'];
			$caretaker_lname = $_POST['caretakerLastName'];
			$caretaker_phone = $_POST['caretakerPhone'];
			$caretaker_DOB = $_POST['caretakerDOB'];
			$caretaker_Nationality = $_POST['caretakerNationality'];
			$caretaker_status = $_POST['caretakerStatus'];
			$caretaker_extra = $_POST ['caretakerAdditionalInfo'];

		// Doctor Table Variables
			$doctor_fname = $_POST['doctorFirstName'];
			$doctor_lname = $_POST['doctorLastName'];
			$doctor_practice = $_POST['doctorPrac'];
			$doctor_phone = $_POST['doctorPhone'];

		// Non-Response to Scheduled Visit Contacts
			$contactName1 = $_POST['contactName1'];
			$contactName2 = $_POST['contactName2'];
			$contactName3 = $_POST['contactName3'];
			$telephone1 = $_POST['telephone1'];
			$telephone2 = $_POST['telephone2'];
			$telephone3 = $_POST['telephone3'];

		// Pharmacy
			$pharmacy = $_POST['pharmacyName'];
			$pharmacy_phone = $_POST['pharmacyPhone'];
			$pharmacy_address = $_POST['pharmacyAddress'];
			$pharmacy_suburb = $_POST['pharmacySuburb'];
			$pharmacy_postcode = $_POST['pharmacyPostcode'];
			$pharmacy_hours = $_POST['businessHours'];

		// Client Profile
			$important_to_me = $_POST['importantToMe'];
			$good_day = $_POST['goodDay'];
			$spend_time = $_POST['spendTime'];
			$personal_qualities = $_POST['personalQualities'];
			$best_support = $_POST['bestSupport'];
			$achieve_from_service = $_POST['achieveFromService'];
			$role_arranging_support = $_POST['roleArrangingSupport'];

			switch($_POST['socialNetwork'])
			{
			  case "regular": $socialNetwork = "Regular Contact/Support"; break;
			  case "periodic": $socialNetwork = "Periodic Contact/Support"; break;
			  case "little": $socialNetwork = "Little Contact/Support"; break;
			  default: echo("Error!"); exit(); break;
			}

			$culturalConsideration = $_POST['culturalConsideration'];
			$networkDetails = $_POST['networkDetails'];
			$lifeHistory = $_POST['lifeHistory'];

		// Service Type
			$serviceFreq = $_POST['serviceFreq'];
			$serviceDays = $_POST['serviceDays'];
			$serviceDuration = $_POST['serviceDuration'];
			$serviceTime = $_POST['serviceTime'];


//Connection to db through PDO
	$conn = new PDO("mysql:host=$hostname;dbname=$database", $username, $password);

// PDO prepared statement for Doctor Table

	$doctorQuery = $conn->prepare("INSERT INTO doctor (firstname, lastname, practice, phone) VALUES (:docFirstName, :docLastName, :docPrac, :docPhone)");

	$doctorQuery ->bindParam(':docFirstName', $doctor_fname);
	$doctorQuery ->bindParam(':docLastName', $doctor_lname);
	$doctorQuery ->bindParam(':docPrac', $doctor_practice);
	$doctorQuery ->bindParam(':docPhone', $doctor_phone);
	$doctorQuery ->execute();

	$doctor_id = $conn->lastInsertId();


// PDO prepared statement for Client Table
	$clientQuery = $conn->prepare("INSERT INTO client (first_name, last_name, DOB, address, suburb, state, postcode, phone, doctor_id) VALUES (:fName, :lName, :DOB, :address, :suburb, :state, :postcode, :phone, :doctor)");

	$clientQuery -> bindParam(':fName', $first_name);
	$clientQuery -> bindParam(':lName', $last_name);
	$clientQuery -> bindParam(':DOB', $DOB);
	$clientQuery -> bindParam(':address', $street);
	$clientQuery -> bindParam(':suburb', $suburb);
	$clientQuery -> bindParam(':state', $state);
	$clientQuery -> bindParam(':postcode', $postcode);
	$clientQuery -> bindParam(':phone', $phone);
	$clientQuery -> bindParam(':doctor', $doctor_id);

	$clientQuery -> execute();

	$client_id = $conn->lastInsertId();


// PDO prepared statement for Caretaker Table

	$caretakerQuery = $conn->prepare("INSERT INTO caretaker (client_id, firstname, lastname, phone, DOB, Nationality, Status, extrainfo) VALUES (:careClientId, :careFirstName, :careLastName, :carePhone, :careDOB, :careNation, :careStatus, :careExtra)");

	$caretakerQuery ->bindParam(':careClientId', $client_id);
	$caretakerQuery ->bindParam(':careFirstName', $caretaker_fname);
	$caretakerQuery ->bindParam(':careLastName', $caretaker_lname);
	$caretakerQuery ->bindParam(':carePhone', $caretaker_phone);
	$caretakerQuery ->bindParam(':careDOB', $caretaker_DOB);
	$caretakerQuery ->bindParam(':careNation', $caretaker_Nationality);
	$caretakerQuery ->bindParam(':careStatus', $caretaker_status);
	$caretakerQuery ->bindParam(':careExtra', $caretaker_extra);
	$caretakerQuery ->execute();

// PDO prepared statement for Health Table

	if(isset($_POST['healthCondition']) && $_POST['healthCondition'] == '1') {
		$healthCondition = 1;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $healthCondition);
		$healthQuery ->execute();
	}else{
		$healthCondition = 0;
	}

	if(isset($_POST['cognitiveImpairment']) && $_POST['cognitiveImpairment'] == '1') {
		$cognitiveImpairment = 2;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $cognitiveImpairment);
		$healthQuery ->execute();
	}else{
		$cognitiveImpairment = 0;
	}

	if(isset($_POST['lockedBox']) && $_POST['lockedBox'] == '1') {
		$lockedBox = 3;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $lockedBox);
		$healthQuery ->execute();
	}else{
		$lockedBox = 0;
	}

	if(isset($_POST['pendantAlarm']) && $_POST['pendantAlarm'] == '1') {
		$pendantAlarm = 4;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $pendantAlarm);
		$healthQuery ->execute();
	}else{
		$pendantAlarm = 0;
	}

	if(isset($_POST['healthAllergies']) && $_POST['healthAllergies'] == '1') {
		$healthAllergies = 5;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $healthAllergies);
		$healthQuery ->execute();

	}else{
		$healthAllergies = 0;
	}

	if(isset($_POST['advancedCare']) && $_POST['advancedCare'] == '1') {
		$advancedCare = 6;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $advancedCare);
		$healthQuery ->execute();
	}else{
		$advancedCare = 0;
	}

	if(isset($_POST['powerOfAttorney']) && $_POST['powerOfAttorney'] == '1') {
		$powerOfAttorney = 7;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $powerOfAttorney);
		$healthQuery ->execute();
	}else{
		$powerOfAttorney = 0;
	}

	if(isset($_POST['enduringPOA']) && $_POST['enduringPOA'] == '1') {
		$enduringPOA = 8;

		$healthQuery = $conn->prepare("INSERT INTO client_health (client_id, health_id) VALUES (:healthClientID, :healthID)");

		$healthQuery ->bindParam(':healthClientID', $client_id);
		$healthQuery ->bindParam(':healthID', $enduringPOA);
		$healthQuery ->execute();
	}else{
		$enduringPOA = 0;
	}


// PDO prepared statement for the Mobility and WellBeing Table
	if(isset($_POST['mobIndependent']) && $_POST['mobIndependent'] == '1') {
		$mobIndependent = 1;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $mobIndependent);
		$mobilityQuery ->execute();
	}else{
		$mobIndependent = 0;
	}

	if(isset($_POST['mobSupervision']) && $_POST['mobSupervision'] == '1') {
		$mobSupervision = 2;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $mobSupervision);
		$mobilityQuery ->execute();
	}else{
		$mobSupervision = 0;
	}

	if(isset($_POST['mobAssistance']) && $_POST['mobAssistance'] == '1') {
		$mobAssistance = 3;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $mobAssistance);
		$mobilityQuery ->execute();
	}else{
		$mobAssistance = 0;
	}

	if(isset($_POST['fallRisk']) && $_POST['fallRisk'] == '1') {
		$fallRisk = 4;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $fallRisk);
		$mobilityQuery ->execute();
	}else{
		$fallRisk = 0;
	}

	if(isset($_POST['disasterAssistance']) && $_POST['disasterAssistance'] == '1') {
		$disasterAssistance = 5;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $disasterAssistance);
		$mobilityQuery ->execute();
	}else{
		$disasterAssistance = 0;
	}

	if(isset($_POST['noSupport']) && $_POST['noSupport'] == '1') {
		$noSupport = 6;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $noSupport);
		$mobilityQuery ->execute();
	}else{
		$noSupport = 0;
	}

	if(isset($_POST['walker']) && $_POST['walker'] == '1') {
		$walker = 7;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $walker);
		$mobilityQuery ->execute();
	}else{
		$walker = 0;
	}

	if(isset($_POST['glasses']) && $_POST['glasses'] == '1') {
		$glasses = 8;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $glasses);
		$mobilityQuery ->execute();
	}else{
		$glasses = 0;
	}

	if(isset($_POST['dentures']) && $_POST['dentures'] == '1') {
		$dentures = 9;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $dentures);
		$mobilityQuery ->execute();
	}else{
		$dentures = 0;
	}

	if(isset($_POST['hearingAid']) && $_POST['hearingAid'] == 'left') {
		$hearingAid = 10;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $hearingAid);
		$mobilityQuery ->execute();
	}elseif(isset($_POST['hearingAid']) && $_POST['hearingAid'] == 'right') {
		$hearingAid = 11;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $hearingAid);
		$mobilityQuery ->execute();
	}elseif(isset($_POST['hearingAid']) && $_POST['hearingAid'] == 'both') {
		$hearingAid = 12;

		$mobilityQuery = $conn->prepare("INSERT INTO client_mobility (client_id, mobility_id) VALUES (:mobilityClientID, :mobilityID)");

		$mobilityQuery ->bindParam(':mobilityClientID', $client_id);
		$mobilityQuery ->bindParam(':mobilityID', $hearingAid);
		$mobilityQuery ->execute();
	}else{
		$hearingAid = 0;
	}


// PDO prepared statement for the Contacts Table
	if(!empty($telephone1)){
		$nonResponseQuery = $conn->prepare("INSERT INTO contacts (client_id, name, phone) VALUES (:contactClientID, :contactName, :contactPhone)");

		$nonResponseQuery ->bindParam(':contactClientID', $client_id);
		$nonResponseQuery ->bindParam(':contactName', $contactName1);
		$nonResponseQuery ->bindParam(':contactPhone', $telephone1);

		$nonResponseQuery ->execute();
	}
	if(!empty($telephone2)){
		$nonResponseQuery = $conn->prepare("INSERT INTO contacts (client_id, name, phone) VALUES (:contactClientID, :contactName, :contactPhone)");

		$nonResponseQuery ->bindParam(':contactClientID', $client_id);
		$nonResponseQuery ->bindParam(':contactName', $contactName2);
		$nonResponseQuery ->bindParam(':contactPhone', $telephone2);

		$nonResponseQuery ->execute();
	}
	if(!empty($telephone3)){
		$nonResponseQuery = $conn->prepare("INSERT INTO contacts (client_id, name, phone) VALUES (:contactClientID, :contactName, :contactPhone)");

		$nonResponseQuery ->bindParam(':contactClientID', $client_id);
		$nonResponseQuery ->bindParam(':contactName', $contactName3);
		$nonResponseQuery ->bindParam(':contactPhone', $telephone3);

		$nonResponseQuery ->execute();
	}

// PDO prepared statement for the Transport Table
	if(isset($_POST['ownTransport']) && $_POST['ownTransport'] == 'morning') {
		$ownTransport = 1;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $ownTransport);

		$transportQuery ->execute();
	}elseif(isset($_POST['ownTransport']) && $_POST['ownTransport'] == 'afternoon') {
		$ownTransport = 2;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $ownTransport);

		$transportQuery ->execute();
	}elseif(isset($_POST['ownTransport']) && $_POST['ownTransport'] == 'both') {
		$ownTransport = 3;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $ownTransport);

		$transportQuery ->execute();
	}else{
		$ownTransport = 0;
	}

	if(isset($_POST['centreTransport']) && $_POST['centreTransport'] == 'morning') {
		$centreTransport = 4;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $centreTransport);

		$transportQuery ->execute();
	}elseif(isset($_POST['centreTransport']) && $_POST['centreTransport'] == 'afternoon') {
		$centreTransport = 5;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $centreTransport);

		$transportQuery ->execute();
	}elseif(isset($_POST['centreTransport']) && $_POST['centreTransport'] == 'both') {
		$centreTransport = 6;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $centreTransport);

		$transportQuery ->execute();
	}else{
		$centreTransport = 0;
	}

	if(isset($_POST['transportMode']) && $_POST['transportMode'] == 'minibus') {
		$transportMode = 7;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $transportMode);

		$transportQuery ->execute();
	}elseif(isset($_POST['transportMode']) && $_POST['transportMode'] == 'car') {
		$transportMode = 8;

		$transportQuery = $conn->prepare("INSERT INTO client_transport (client_id, transport_id) VALUES (:transportClientID, :transportID)");

		$transportQuery ->bindParam(':transportClientID', $client_id);
		$transportQuery ->bindParam(':transportID', $transportMode);

		$transportQuery ->execute();
	}else{
		$transportMode = 0;
	}

// PDO prepared statement for the Dietary Table
		if(isset($_POST['foodAllergies']) && $_POST['foodAllergies'] == '1') {
			$foodAllergies = 1;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $foodAllergies);

			$dietaryQuery ->execute();
		}else{
			$foodAllergies = 0;
		}

		if(isset($_POST['vegetarian']) && $_POST['vegetarian'] == '1') {
			$vegetarian = 2;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $vegetarian);

			$dietaryQuery ->execute();
		}else{
			$vegetarian = 0;
		}

		if(isset($_POST['glutenFree']) && $_POST['glutenFree'] == '1') {
			$glutenFree = 3;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $glutenFree);

			$dietaryQuery ->execute();
		}else{
			$glutenFree = 0;
		}

		if(isset($_POST['lactoseIntolerant']) && $_POST['lactoseIntolerant'] == '1') {
			$lactoseIntolerant = 4;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $lactoseIntolerant);

			$dietaryQuery ->execute();
		}else{
			$lactoseIntolerant = 0;
		}

		if(isset($_POST['foodOther']) && $_POST['foodOther'] == '1') {
			$foodOther = 5;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $foodOther);

			$dietaryQuery ->execute();
		}else{
			$foodOther = 0;
		}

		if(isset($_POST['likesDislikes']) && $_POST['likesDislikes'] == '1') {
			$likesDislikes = 6;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $likesDislikes);

			$dietaryQuery ->execute();
		}else{
			$likesDislikes = 0;
		}

		if(isset($_POST['culturalFood']) && $_POST['culturalFood'] == '1') {
			$culturalFood = 7;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $culturalFood);

			$dietaryQuery ->execute();
		}else{
			$culturalFood = 0;
		}

		if(isset($_POST['foodIndependent']) && $_POST['foodIndependent'] == '1') {
			$foodIndependent = 8;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $foodIndependent);

			$dietaryQuery ->execute();
		}else{
			$foodIndependent = 0;
		}

		if(isset($_POST['foodSupervision']) && $_POST['foodSupervision'] == '1') {
			$foodSupervision = 9;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $foodSupervision);

			$dietaryQuery ->execute();
		}else{
			$foodSupervision = 0;
		}

		if(isset($_POST['foodAssistance']) && $_POST['foodAssistance'] == '1') {
			$foodAssistance = 10;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $foodAssistance);

			$dietaryQuery ->execute();
		}else{
			$foodAssistance = 0;
		}

		if(isset($_POST['foodRoutine']) && $_POST['foodRoutine'] == '1') {
			$foodRoutine = 11;

			$dietaryQuery = $conn->prepare("INSERT INTO client_diet (client_id, diet_id) VALUES (:dietClientID, :dietID)");

			$dietaryQuery ->bindParam(':dietClientID', $client_id);
			$dietaryQuery ->bindParam(':dietID', $foodRoutine);

			$dietaryQuery ->execute();
		}else{
			$foodRoutine = 0;
		}


// PDO prepared statement for Pharmacy Table

	// Pharmacy
	$pharmacyQuery = $conn->prepare("INSERT INTO pharmacy (name, phone, address, suburb, postcode, business_hours) VALUES (:pharmacy, :pharmPhone, :pharmAddress, :pharmSuburb, :pharmPostcode, :businessHours)");

	$pharmacyQuery ->bindParam(':pharmacy', $pharmacy);
	$pharmacyQuery ->bindParam(':pharmPhone', $pharmacy_phone);
	$pharmacyQuery ->bindParam(':pharmAddress', $pharamcy_address);
	$pharmacyQuery ->bindParam(':pharmSuburb',$pharmacy_suburb);
	$pharmacyQuery ->bindParam(':pharmPostcode', $pharmacy_postcode);
	$pharmacyQuery ->bindParam(':businessHours', $pharmacy_hours);
	$pharmacyQuery ->execute();

	$pharmacy_id = $conn->lastInsertId();

	// Client-pharmacy

	$clientPharmacyQuery = $conn->prepare("INSERT INTO client_pharmacy (client_id, pharmacy_id) VALUES (:pharmClientID, :pharmacyID)");

	$pharmacyQuery ->bindParam(':pharmClientID', $client_id);
	$pharmacyQuery ->bindParam(':pharmacyID', $pharmacy_id);
	$pharmacyQuery ->execute();


// PDO prepared statement for Self-Care/Social Support
	if(isset($_POST['careIndependent']) && $_POST['careIndependent'] == '1') {
		$careIndependent = 1;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $careIndependent);

		$socialQuery ->execute();
	}else{
		$careIndependent = 0;
	}

	if(isset($_POST['careSupervision']) && $_POST['careSupervision'] == '1') {
		$careSupervision = 2;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $careSupervision);

		$socialQuery ->execute();
	}else{
		$careSupervision = 0;
	}

	if(isset($_POST['careAssistance']) && $_POST['careAssistance'] == '1') {
		$careAssistance = 3;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $careAssistance);

		$socialQuery ->execute();
	}else{
		$careAssistance = 0;
	}

	if(isset($_POST['careRoutine']) && $_POST['careRoutine'] == '1') {
		$careRoutine = 4;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $careRoutine);

		$socialQuery ->execute();
	}else{
		$careRoutine = 0;
	}

	if(isset($_POST['continence']) && $_POST['continence'] == '1') {
		$continence = 5;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $continence);

		$socialQuery ->execute();
	}else{
		$continence = 0;
	}

	if(isset($_POST['bladder']) && $_POST['bladder'] == '1') {
		$bladder = 6;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $bladder);

		$socialQuery ->execute();
	}else{
		$bladder = 0;
	}

	if(isset($_POST['bowel']) && $_POST['bowel'] == '1') {
		$bowel = 7;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $bowel);

		$socialQuery ->execute();
	}else{
		$bowel = 0;
	}

	if(isset($_POST['shopping']) && $_POST['shopping'] == '1') {
		$shopping = 8;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $shopping);

		$socialQuery ->execute();
	}else{
		$shopping = 0;
	}

	if(isset($_POST['appointments']) && $_POST['appointments'] == '1') {
		$appointments = 9;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $appointments);

		$socialQuery ->execute();
	}else{
		$appointments = 0;
	}

	if(isset($_POST['socialOther']) && $_POST['socialOther'] == '1') {
		$socialOther = 10;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $socialOther);

		$socialQuery ->execute();
	}else{
		$socialOther = 0;
	}

	if(isset($_POST['disabilityParking']) && $_POST['disabilityParking'] == '1') {
		$disabilityParking = 11;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $disabilityParking);

		$socialQuery ->execute();
	}else{
		$disabilityParking = 0;
	}

	if(isset($_POST['cashHandling']) && $_POST['cashHandling'] == '1') {
		$cashHandling = 12;

		$socialQuery = $conn->prepare("INSERT INTO client_social (client_id, social_id) VALUES (:socialClientID, :socialID)");

		$socialQuery ->bindParam(':socialClientID', $client_id);
		$socialQuery ->bindParam(':socialID', $cashHandling);

		$socialQuery ->execute();
	}else{
		$cashHandling = 0;
	}


// PDO prepared statement for Profile Table

	$profileQuery = $conn->prepare("INSERT INTO profile (client_id, what_important, good_day, spend_time, strengths_qualities, best_support, like_to_achieve, role_I_would_like, support_interval, social_network, cultural_considerations, life_history) VALUES (:profileClientID, :whatImportant, :goodDay, :spendTime, :strengthQual, :bestSupport, :likeAchieve, :roleILike, :supportInterval, :socialNetwork, :lifeHistory, :culturalConsider)");

	$profileQuery ->bindParam(':profileClientID', $client_id);
	$profileQuery ->bindParam(':whatImportant', $important_to_me);
	$profileQuery ->bindParam(':goodDay', $good_day);
	$profileQuery ->bindParam(':spendTime', $spend_time);
	$profileQuery ->bindParam(':strenthQual', $personal_qualities);
	$profileQuery ->bindParam(':bestSupport', $best_support);
	$profileQuery ->bindParam(':likeAchieve', $achieve_from_service);
	$profileQuery ->bindParam(':roleILike', $role_arranging_support);
	$profileQuery ->bindParam(':supportInterval', $socialNetwork);
	$profileQuery ->bindParam(':socialNetwork', $networkDetails);
	$profileQuery ->bindParam(':lifeHistory', $lifeHistory);
	$profileQuery ->bindParam(':culturalConsider', $culturalConsideration);
	$profileQuery ->execute();


// PDO prepared statement for Activities Table
	// Computing
		if(isset($_POST['computing']) && $_POST['computing'] == 'Email') {
			$email = 1;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $email);

			$activityQuery ->execute();
		}else{
			$email = 0;
		}

		if(isset($_POST['computing']) && $_POST['computing'] == 'Games') {
			$games = 2;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $games);

			$activityQuery ->execute();
		}else{
			$games = 0;
		}

		if(isset($_POST['computing']) && $_POST['computing'] == 'Internet') {
			$internet = 3;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $internet);

			$activityQuery ->execute();
		}else{
			$intenet = 0;
		}

	// Literary Arts
		if(isset($_POST['literaryArts']) && $_POST['literaryArts'] == 'Poetry') {
			$poetry = 4;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $poetry);

			$activityQuery ->execute();
		}else{
			$poetry = 0;
		}

		if(isset($_POST['literaryArts']) && $_POST['literaryArts'] == 'Novels') {
			$novels = 5;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $novels);

			$activityQuery ->execute();
		}else{
			$novel = 0;
		}

		if(isset($_POST['literaryArts']) && $_POST['literaryArts'] == 'Short Stories') {
			$shortStories = 6;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $shortStories);

			$activityQuery ->execute();
		}else{
			$shortStories = 0;
		}

	// Games
		if(isset($_POST['games']) && $_POST['games'] == 'Bingo') {
			$bingo = 7;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $bingo);

			$activityQuery ->execute();
		}else{
			$bingo = 0;
		}

		if(isset($_POST['games']) && $_POST['games'] == 'Cards') {
			$cards = 8;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $cards);

			$activityQuery ->execute();
		}else{
			$cards = 0;
		}

		if(isset($_POST['games']) && $_POST['games'] == 'Chess/Checkers') {
			$chess = 9;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $chess);

			$activityQuery ->execute();
		}else{
			$chess = 0;
		}

		if(isset($_POST['games']) && $_POST['games'] == 'Jigsaw') {
			$jigsaw = 10;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $jigsaw);

			$activityQuery ->execute();
		}else{
			$jigsaw = 0;
		}

		if(isset($_POST['games']) && $_POST['games'] == 'Trivia') {
			$trivia = 11;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $trivia);

			$activityQuery ->execute();
		}else{
			$trivia = 0;
		}

		if(isset($_POST['games']) && $_POST['games'] == 'Word Puzzles') {
			$wordPuzzles = 12;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $wordPuzzles);

			$activityQuery ->execute();
		}else{
			$wordPuzzles = 0;
		}

	// Performing Arts
		if(isset($_POST['performingArts']) && $_POST['performingArts'] == 'Concerts/Music') {
			$concerts = 13;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $concerts);

			$activityQuery ->execute();
		}else{
			$concerts = 0;
		}

		if(isset($_POST['performingArts']) && $_POST['performingArts'] == 'Dance/Ballet') {
			$dance = 14;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $dance);

			$activityQuery ->execute();
		}else{
			$dance = 0;
		}

		if(isset($_POST['performingArts']) && $_POST['performingArts'] == 'Opera') {
			$opera = 15;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $opera);

			$activityQuery ->execute();
		}else{
			$opera = 0;
		}

		if(isset($_POST['performingArts']) && $_POST['performingArts'] == 'Plays') {
			$plays = 16;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $plays);

			$activityQuery ->execute();
		}else{
			$plays = 0;
		}

		if(isset($_POST['performingArts']) && $_POST['performingArts'] == 'Singing') {
			$singing = 17;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $singing);

			$activityQuery ->execute();
		}else{
			$singing = 0;
		}

		if(isset($_POST['performingArts']) && $_POST['performingArts'] == 'Theatre/Drama') {
			$theatre = 18;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $theatre);

			$activityQuery ->execute();
		}else{
			$theatre = 0;
		}

	// Leisure
		if(isset($_POST['leisure']) && $_POST['leisure'] == 'Eating Out') {
			$eatingOut = 19;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $eatingOut);

			$activityQuery ->execute();
		}else{
			$eatingOut = 0;
		}

		if(isset($_POST['leisure']) && $_POST['leisure'] == 'Films/Movies') {
			$films = 20;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $films);

			$activityQuery ->execute();
		}else{
			$films = 0;
		}

		if(isset($_POST['leisure']) && $_POST['leisure'] == 'Galleries/Museums') {
			$galleries = 21;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $galleries);

			$activityQuery ->execute();
		}else{
			$galleries = 0;
		}

		if(isset($_POST['leisure']) && $_POST['leisure'] == 'Outings') {
			$outings = 22;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $outings);

			$activityQuery ->execute();
		}else{
			$outings = 0;
		}

		if(isset($_POST['leisure']) && $_POST['leisure'] == 'Picnics') {
			$picnics = 23;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $picnics);

			$activityQuery ->execute();
		}else{
			$picnics = 0;
		}

		if(isset($_POST['leisure']) && $_POST['leisure'] == 'Shopping') {
			$goingShopping = 24;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $goingShopping);

			$activityQuery ->execute();
		}else{
			$goingShopping = 0;
		}

	// Visual Arts
		if(isset($_POST['visualArts']) && $_POST['visualArts'] == 'Architecture') {
			$architecture = 25;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $architecture);

			$activityQuery ->execute();
		}else{
			$architecture = 0;
		}

		if(isset($_POST['visualArts']) && $_POST['visualArts'] == 'Drawing') {
			$drawing = 26;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $drawing);

			$activityQuery ->execute();
		}else{
			$drawing = 0;
		}

		if(isset($_POST['visualArts']) && $_POST['visualArts'] == 'Fashion') {
			$fashion = 27;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $fashion);

			$activityQuery ->execute();
		}else{
			$fashion = 0;
		}

		if(isset($_POST['visualArts']) && $_POST['visualArts'] == 'Painting') {
			$painting = 28;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $painting);

			$activityQuery ->execute();
		}else{
			$painting = 0;
		}

		if(isset($_POST['visualArts']) && $_POST['visualArts'] == 'Photography') {
			$photography = 29;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $photography);

			$activityQuery ->execute();
		}else{
			$photography = 0;
		}

		if(isset($_POST['visualArts']) && $_POST['visualArts'] == 'Pottery/Sculpture') {
			$pottery = 30;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $pottery);

			$activityQuery ->execute();
		}else{
			$pottery = 0;
		}

	//Hair/Beauty
		if(isset($_POST['hairBeauty']) && $_POST['hairBeauty'] == 'Hairdressing') {
			$hairdressing = 31;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $hairdressing);

			$activityQuery ->execute();
		}else{
			$hairdressing = 0;
		}

		if(isset($_POST['hairBeauty']) && $_POST['hairBeauty'] == 'Facials') {
			$facials = 32;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $facials);

			$activityQuery ->execute();
		}else{
			$facials = 0;
		}

		if(isset($_POST['hairBeauty']) && $_POST['hairBeauty'] == 'Manicures') {
			$manicures = 33;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $manicures);

			$activityQuery ->execute();
		}else{
			$manicures = 0;
		}

		if(isset($_POST['hairBeauty']) && $_POST['hairBeauty'] == 'Pedicures') {
			$pedicures = 34;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $pedicures);

			$activityQuery ->execute();
		}else{
			$pedicures = 0;
		}

	//Men's Shed
		if(isset($_POST['mensShed']) && $_POST['mensShed'] == 'Bicycle Repairs') {
			$menBike = 35;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $menBike);

			$activityQuery ->execute();
		}else{
			$menBike = 0;
		}

		if(isset($_POST['mensShed']) && $_POST['mensShed'] == 'Framing') {
			$menFraming = 36;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $menFraming);

			$activityQuery ->execute();
		}else{
			$menFraming = 0;
		}

		if(isset($_POST['mensShed']) && $_POST['mensShed'] == 'Metal work') {
			$menMetal = 37;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $menMetal);

			$activityQuery ->execute();
		}else{
			$menMetal = 0;
		}

		if(isset($_POST['mensShed']) && $_POST['mensShed'] == 'Wood work') {
			$menWood = 38;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $menWood);

			$activityQuery ->execute();
		}else{
			$menWood = 0;
		}

	//Girl's Shed
		if(isset($_POST['girlsShed']) && $_POST['girlsShed'] == 'Bicycle Repairs') {
			$girlsBike = 39;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $girlsBike);

			$activityQuery ->execute();
		}else{
			$girlsBike = 0;
		}

		if(isset($_POST['girlsShed']) && $_POST['girlsShed'] == 'Framing') {
			$girlsFraming = 40;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $girlsFraming);

			$activityQuery ->execute();
		}else{
			$girlsFraming = 0;
		}

		if(isset($_POST['girlsShed']) && $_POST['girlsShed'] == 'Metal work') {
			$girlsMetal = 41;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $girlsMetal);

			$activityQuery ->execute();
		}else{
			$girlsMetal = 0;
		}

		if(isset($_POST['girlsShed']) && $_POST['girlsShed'] == 'Wood work') {
			$girlsWood = 42;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $girlsWood);

			$activityQuery ->execute();
		}else{
			$girlsWood = 0;
		}

	//Physical Activity
		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Fishing') {
			$fishing = 43;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $fishing);

			$activityQuery ->execute();
		}else{
			$fishing = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Gardening') {
			$gardening = 44;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $gardening);

			$activityQuery ->execute();
		}else{
			$gardening = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Golf') {
			$golf = 45;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $golf);

			$activityQuery ->execute();
		}else{
			$golf = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Lawn Bowls') {
			$lawnBowls = 46;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $lawnBowls);

			$activityQuery ->execute();
		}else{
			$lawnBowls = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Sailing/Boating') {
			$sailing = 47;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $sailing);

			$activityQuery ->execute();
		}else{
			$sailing = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Snooker') {
			$snooker = 48;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $snooker);

			$activityQuery ->execute();
		}else{
			$snooker = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Swimming') {
			$swimming = 49;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $swimming);

			$activityQuery ->execute();
		}else{
			$swimming = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Tai Chi') {
			$taiChi = 50;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $taiChi);

			$activityQuery ->execute();
		}else{
			$taiChi = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Tennis') {
			$tennis = 51;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $tennis);

			$activityQuery ->execute();
		}else{
			$tennis = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Ten Pin Bowling') {
			$bowling = 52;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $bowling);

			$activityQuery ->execute();
		}else{
			$bowling = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Walking') {
			$walking = 53;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $walking);

			$activityQuery ->execute();
		}else{
			$walking = 0;
		}

		if(isset($_POST['physicalActivity']) && $_POST['physicalActivity'] == 'Yoga') {
			$yoga = 54;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $yoga);

			$activityQuery ->execute();
		}else{
			$yoga = 0;
		}

	// Crafts
		if(isset($_POST['crafts']) && $_POST['crafts'] == 'Card Making') {
			$cardMaking = 55;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $cardMaking);

			$activityQuery ->execute();
		}else{
			$cardMaking = 0;
		}

		if(isset($_POST['crafts']) && $_POST['crafts'] == 'Crochet') {
			$crochet = 56;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $crochet);

			$activityQuery ->execute();
		}else{
			$crochet = 0;
		}

		if(isset($_POST['crafts']) && $_POST['crafts'] == 'Craftwork') {
			$craftwork = 57;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $craftwork);

			$activityQuery ->execute();
		}else{
			$craftwork = 0;
		}

		if(isset($_POST['crafts']) && $_POST['crafts'] == 'Jewellery Making') {
			$jewellery = 58;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $jewellery);

			$activityQuery ->execute();
		}else{
			$jewellery = 0;
		}

		if(isset($_POST['crafts']) && $_POST['crafts'] == 'Knitting') {
			$knitting = 59;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $knitting);

			$activityQuery ->execute();
		}else{
			$knitting = 0;
		}

		if(isset($_POST['crafts']) && $_POST['crafts'] == 'Needlework') {
			$needlework = 60;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $needlework);

			$activityQuery ->execute();
		}else{
			$needlework = 0;
		}

	// Natural Therapies
		if(isset($_POST['naturalTherapies']) && $_POST['naturalTherapies'] == 'Aromatherapy') {
			$aromatherapy = 61;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $aromatherapy);

			$activityQuery ->execute();
		}else{
			$aromatherapy = 0;
		}

		if(isset($_POST['naturalTherapies']) && $_POST['naturalTherapies'] == 'Massage') {
			$massage = 62;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $massage);

			$activityQuery ->execute();
		}else{
			$massage = 0;
		}

		if(isset($_POST['naturalTherapies']) && $_POST['naturalTherapies'] == 'Meditation') {
			$meditation = 63;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $meditation);

			$activityQuery ->execute();
		}else{
			$meditation = 0;
		}

		if(isset($_POST['naturalTherapies']) && $_POST['naturalTherapies'] == 'Relaxation') {
			$relaxation = 64;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $relaxation);

			$activityQuery ->execute();
		}else{
			$relaxation = 0;
		}

	//Other
		if(isset($_POST['other']) && $_POST['other'] == 'Cooking') {
			$cooking = 65;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $cooking);

			$activityQuery ->execute();
		}else{
			$cooking = 0;
		}

		if(isset($_POST['other']) && $_POST['other'] == 'Flower Arranging') {
			$flowerArrange = 66;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $flowerArrange);

			$activityQuery ->execute();
		}else{
			$flowerArrange = 0;
		}

		if(isset($_POST['other']) && $_POST['other'] == 'Education') {
			$education = 67;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $education);

			$activityQuery ->execute();
		}else{
			$education = 0;
		}

		if(isset($_POST['other']) && $_POST['other'] == 'Languages') {
			$languages = 68;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $languages);

			$activityQuery ->execute();
		}else{
			$languages = 0;
		}

		if(isset($_POST['other']) && $_POST['other'] == 'Model Building') {
			$models = 69;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $models);

			$activityQuery ->execute();
		}else{
			$models = 0;
		}

		if(isset($_POST['other']) && $_POST['other'] == 'Volunteering') {
			$volunteer = 70;

			$activityQuery = $conn->prepare("INSERT INTO client_activity (client_id, activity_id) VALUES (:activityClientID, :activityID)");

			$activityQuery ->bindParam(':activityClientID', $client_id);
			$activityQuery ->bindParam(':activityID', $volunteer);

			$activityQuery ->execute();
		}else{
			$volunteer = 0;
		}

// PDO Statement for the Service Table
		if(isset($_POST['VHC']) && $_POST['VHC'] == '1') {
			$vhc = 1;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $vhc);

			$serviceQuery ->execute();
		}else{
			$vhc = 0;
		}

		if(isset($_POST['BP4H']) && $_POST['BP4H'] == '1') {
			$bp4h = 2;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $bp4h);

			$serviceQuery ->execute();
		}else{
			$bp4h = 0;
		}

		if(isset($_POST['CHSP']) && $_POST['CHSP'] == '1') {
			$chsp = 3;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $chsp);

			$serviceQuery ->execute();
		}else{
			$chsp = 0;
		}

		if(isset($_POST['QCCS']) && $_POST['QCCS'] == '1') {
			$qccs = 4;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $qccs);

			$serviceQuery ->execute();
		}else{
			$qccs = 0;
		}

		if(isset($_POST['homeCarePackage']) && $_POST['homeCarePackage'] == '1') {
			$homeCarePackage = 5;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $homeCarePackage);

			$serviceQuery ->execute();
		}else{
			$homeCarePackage = 0;
		}

		if(isset($_POST['domesticAssist']) && $_POST['domesticAssist'] == '1') {
			$domesticAssist = 6;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $domesticAssist);

			$serviceQuery ->execute();
		}else{
			$domesticAssist = 0;
		}

		if(isset($_POST['personalCare']) && $_POST['personalCare'] == '1') {
			$personalCare = 7;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $personalCare);

			$serviceQuery ->execute();
		}else{
			$personalCare = 0;
		}

		if(isset($_POST['socialSupport']) && $_POST['socialSupport'] == '1') {
			$socialSupport = 8;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $socialSupport);

			$serviceQuery ->execute();
		}else{
			$socialSupport = 0;
		}

		if(isset($_POST['inHomeRespite']) && $_POST['inHomeRespite'] == '1') {
			$inHomeRespite = 9;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $inHomeRespite);

			$serviceQuery ->execute();
		}else{
			$inHomeRespite = 0;
		}

		if(isset($_POST['activeProgram']) && $_POST['activeProgram'] == '1') {
			$activeProgram = 10;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $activeProgram);

			$serviceQuery ->execute();
		}else{
			$activeProgram = 0;
		}

		if(isset($_POST['overnightRespite']) && $_POST['overnightRespite'] == '1') {
			$overnightRespite = 11;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $overnightRespite);

			$serviceQuery ->execute();
		}else{
			$overnightRespite = 0;
		}

		if(isset($_POST['serviceOther']) && $_POST['serviceOther'] == '1') {
			$serviceOther = 12;

			$serviceQuery = $conn->prepare("INSERT INTO client_funding (client_id, funding_id) VALUES (:serviceClientID, :serviceID)");

			$serviceQuery ->bindParam(':serviceClientID', $client_id);
			$serviceQuery ->bindParam(':serviceID', $serviceOther);

			$serviceQuery ->execute();
		}else{
			$serviceOther = 0;
		}


// PDO Statement for Service Details Table

	$detailsuery = $conn->prepare("INSERT INTO service_details (client_id, frequency, duration, days, time) VALUES (:detailsClientID, :frequency, :duration, :detailDays, :detailTime)");

	$detailsuery ->bindParam(':detailsClientID', $client_id);
	$detailsuery ->bindParam(':frequency', $serviceFreq);
	$detailsuery ->bindParam(':duration', $serviceDuration);
	$detailsuery ->bindParam(':detailDays', $serviceDays);
	$detailsuery ->bindParam(':detailTime', $serviceTime);
	$detailsuery ->execute();

// PDO Statement for Additional Information Table

	if(!empty($_POST['preferredHospital'])) {
		$preferredID = 1;
		$preferredHospital = $_POST['preferredHospital'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $preferredID);
		$addQuery ->bindParam(':addDetails', $preferredHospital);

		$addQuery ->execute();
	}else{
		$preferredHospital = '';
	}

	if(!empty($_POST['healthAdditional'])) {
		$healthID = 2;
		$healthAdditional = $_POST['healthAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $healthID);
		$addQuery ->bindParam(':addDetails', $healthAdditional);

		$addQuery ->execute();
	}else{
		$healthAdditional = '';
	}

	if(!empty($_POST['mobilityAdditional'])) {
		$mobilityID = 3;
		$mobilityAdditional = $_POST['mobilityAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $mobilityID);
		$addQuery ->bindParam(':addDetails', $mobilityAdditional);

		$addQuery ->execute();
	}else{
		$mobilityAdditional = '';
	}

	if(!empty($_POST['nonResponseAdditional'])) {
		$nonResponseID = 4;
		$nonResponseAdditional = $_POST['nonResponseAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $nonResponseID);
		$addQuery ->bindParam(':addDetails', $nonResponseAdditional);

		$addQuery ->execute();
	}else{
		$nonResponseAdditional = '';
	}

	if(!empty($_POST['supportAdditional'])) {
		$supportID = 5;
		$supportAdditional = $_POST['supportAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $supportID);
		$addQuery ->bindParam(':addDetails', $supportAdditional);

		$addQuery ->execute();
	}else{
		$supportAdditional = '';
	}

	if(!empty($_POST['transportAdditional'])) {
		$transportID = 6;
		$transportAdditional = $_POST['transportAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $transportID);
		$addQuery ->bindParam(':addDetails', $transportAdditional);

		$addQuery ->execute();
	}else{
		$transportAdditional = '';
	}

	if(!empty($_POST['dietAdditional'])) {
		$dietID = 7;
		$dietAdditional = $_POST['dietAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $dietID);
		$addQuery ->bindParam(':addDetails', $dietAdditional);

		$addQuery ->execute();
	}else{
		$dietAdditional = '';
	}

	if(!empty($_POST['medicationAdditional'])) {
		$medicationID = 8;
		$medicationAdditional = $_POST['medicationAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $medicationID);
		$addQuery ->bindParam(':addDetails', $medicationAdditional);

		$addQuery ->execute();
	}else{
		$medicationAdditional = '';
	}

	if(!empty($_POST['selfCareAdditional'])) {
		$selfCareID = 9;
		$selfCareAdditional = $_POST['selfCareAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $selfCareID);
		$addQuery ->bindParam(':addDetails', $selfCareAdditional);

		$addQuery ->execute();
	}else{
		$selfCareAdditional = '';
	}

	if(!empty($_POST['socialAdditional'])) {
		$socialID = 10;
		$socialAdditional = $_POST['socialAdditional'];

		$addQuery = $conn->prepare("INSERT INTO client_additional (client_id, additional_id, details) VALUES (:addClientID, :addID, :addDetails)");

		$addQuery ->bindParam(':addClientID', $client_id);
		$addQuery ->bindParam(':addID', $socialID);
		$addQuery ->bindParam(':addDetails', $socialAdditional);

		$addQuery ->execute();
	}else{
		$socialAdditional = '';
	}



	header("location: client.php");



?>