<?php
 
mb_internal_encoding('utf-8');
error_reporting(-1);
 
$student = array();
$example = array('firstName', 'lastName', 'sex', 'section', 'email', 'year', 'exams', 'isLocal');
 
foreach ($example as $field) {
	$student[] = $_POST[$field];
}
 
try {
	$DHB = new PDO('mysql:host = localhost;dbname = sat', 'root', '');
	$STH = $DHB->prepare("SELECT email FROM students WHERE email = ?");
	$STH->bindparam(1, $email);
	$email = $_POST['email'];
	print_r($DHB);
 
	if ($STH->execute()) {
		throw new PDOExpenition("Email is invalid.\n");
	} else {
		 $STH = $DHB->prepare("INSERT into students (firstName, lastName, sex, section, email, year, exams, isLocal) values ($student[0], $student[1],
		 $student[2], $student[3], $student[4], $student[5], $student[6], $student[7])");
		$STH->execute();
	}
}
catch (PDOExpenition $e) {
	echo "error";
}
?>

PD9waHAKCm1iX2ludGVybmFsX2VuY29kaW5nKCd1dGYtOCcpOwplcnJvcl9yZXBvcnRpbmcoLTEpOwoKJHN0dWRlbnQgPSBhcnJheSgpOwokZXhhbXBsZSA9IGFycmF5KCdmaXJzdE5hbWUnLCAnbGFzdE5hbWUnLCAnc2V4JywgJ3NlY3Rpb24nLCAnZW1haWwnLCAneWVhcicsICdleGFtcycsICdpc0xvY2FsJyk7Cgpmb3JlYWNoICgkZXhhbXBsZSBhcyAkZmllbGQpIHsKCSRzdHVkZW50W10gPSAkX1BPU1RbJGZpZWxkXTsKfQoKdHJ5IHsKCSRESEIgPSBuZXcgUERPKCdteXNxbDpob3N0ID0gbG9jYWxob3N0O2RibmFtZSA9IHNhdCcsICdyb290JywgJycpOwoJJFNUSCA9ICRESEItPnByZXBhcmUoIlNFTEVDVCBlbWFpbCBGUk9NIHN0dWRlbnRzIFdIRVJFIGVtYWlsID0gPyIpOwoJJFNUSC0+YmluZHBhcmFtKDEsICRlbWFpbCk7CgkkZW1haWwgPSAkX1BPU1RbJ2VtYWlsJ107CglwcmludF9yKCRESEIpOwoKCWlmICgkU1RILT5leGVjdXRlKCkpIHsKCQl0aHJvdyBuZXcgUERPRXhwZW5pdGlvbigiRW1haWwgaXMgaW52YWxpZC5cbiIpOwoJfSBlbHNlIHsKCQkgJFNUSCA9ICRESEItPnByZXBhcmUoIklOU0VSVCBpbnRvIHN0dWRlbnRzIChmaXJzdE5hbWUsIGxhc3ROYW1lLCBzZXgsIHNlY3Rpb24sIGVtYWlsLCB5ZWFyLCBleGFtcywgaXNMb2NhbCkgdmFsdWVzICgkc3R1ZGVudFswXSwgJHN0dWRlbnRbMV0sCgkJICRzdHVkZW50WzJdLCAkc3R1ZGVudFszXSwgJHN0dWRlbnRbNF0sICRzdHVkZW50WzVdLCAkc3R1ZGVudFs2XSwgJHN0dWRlbnRbN10pIik7CgkJJFNUSC0+ZXhlY3V0ZSgpOwoJfQp9CmNhdGNoIChQRE9FeHBlbml0aW9uICRlKSB7CgllY2hvICJlcnJvciI7Cn0KPz4=