<?php
 
mb_internal_encoding('utf-8');
error_reporting(-1);
 
class Student
{
	public $firstName;
	public $lastName;
	public $sex;
	public $section;
	public $email;
	public $year;
	public $exams;
	public $isLocal;
 
	public function __construct(Array $student) {
		$this->firstName = $student['firstName'];
		$this->lastName = $student['lastname'];
		$this->sex = $student['sex'];
		$this->section = $student['section'];
		$this->email = $student['email'];
		$this->year = $student['year'];
		$this->exams = $student['exams'];
		$this->isLocal = $student['isLocal'];
	}
 
	/* Тут еще будет функция для проверки полей на валидность и возвращать юзеру данны где ошибка */
}
 
class StudentMapper 
{
	protected $db;
 
	public function __construct(PDO $db){
		$this->db = $db;
	}
 
	public function saveStudent(Student $student){
		$STH = $this->db->prepare("INSERT into students (firstName, lastName, sex, section, email, year, exams, isLocal) values (?, ?, ?, ?, ?, ?, ?, ?);");
		$STH = $STH->execute($student);
	}
}
 
$person = new Student($_POST);
$SAT = new PDO('mysql:host=localhost;dbname=sat', 'root', '');
$table = new StudentMapper($SAT);
$table->saveStudent($person);
 
?>

PD9waHAKCm1iX2ludGVybmFsX2VuY29kaW5nKCd1dGYtOCcpOwplcnJvcl9yZXBvcnRpbmcoLTEpOwoKY2xhc3MgU3R1ZGVudAp7CglwdWJsaWMgJGZpcnN0TmFtZTsKCXB1YmxpYyAkbGFzdE5hbWU7CglwdWJsaWMgJHNleDsKCXB1YmxpYyAkc2VjdGlvbjsKCXB1YmxpYyAkZW1haWw7CglwdWJsaWMgJHllYXI7CglwdWJsaWMgJGV4YW1zOwoJcHVibGljICRpc0xvY2FsOwoKCXB1YmxpYyBmdW5jdGlvbiBfX2NvbnN0cnVjdChBcnJheSAkc3R1ZGVudCkgewoJCSR0aGlzLT5maXJzdE5hbWUgPSAkc3R1ZGVudFsnZmlyc3ROYW1lJ107CgkJJHRoaXMtPmxhc3ROYW1lID0gJHN0dWRlbnRbJ2xhc3RuYW1lJ107CgkJJHRoaXMtPnNleCA9ICRzdHVkZW50WydzZXgnXTsKCQkkdGhpcy0+c2VjdGlvbiA9ICRzdHVkZW50WydzZWN0aW9uJ107CgkJJHRoaXMtPmVtYWlsID0gJHN0dWRlbnRbJ2VtYWlsJ107CgkJJHRoaXMtPnllYXIgPSAkc3R1ZGVudFsneWVhciddOwoJCSR0aGlzLT5leGFtcyA9ICRzdHVkZW50WydleGFtcyddOwoJCSR0aGlzLT5pc0xvY2FsID0gJHN0dWRlbnRbJ2lzTG9jYWwnXTsKCX0KCgkvKiDQotGD0YIg0LXRidC1INCx0YPQtNC10YIg0YTRg9C90LrRhtC40Y8g0LTQu9GPINC/0YDQvtCy0LXRgNC60Lgg0L/QvtC70LXQuSDQvdCwINCy0LDQu9C40LTQvdC+0YHRgtGMINC4INCy0L7Qt9Cy0YDQsNGJ0LDRgtGMINGO0LfQtdGA0YMg0LTQsNC90L3RiyDQs9C00LUg0L7RiNC40LHQutCwICovCn0KCmNsYXNzIFN0dWRlbnRNYXBwZXIgCnsKCXByb3RlY3RlZCAkZGI7CgoJcHVibGljIGZ1bmN0aW9uIF9fY29uc3RydWN0KFBETyAkZGIpewoJCSR0aGlzLT5kYiA9ICRkYjsKCX0KCglwdWJsaWMgZnVuY3Rpb24gc2F2ZVN0dWRlbnQoU3R1ZGVudCAkc3R1ZGVudCl7CgkJJFNUSCA9ICR0aGlzLT5kYi0+cHJlcGFyZSgiSU5TRVJUIGludG8gc3R1ZGVudHMgKGZpcnN0TmFtZSwgbGFzdE5hbWUsIHNleCwgc2VjdGlvbiwgZW1haWwsIHllYXIsIGV4YW1zLCBpc0xvY2FsKSB2YWx1ZXMgKD8sID8sID8sID8sID8sID8sID8sID8pOyIpOwoJCSRTVEggPSAkU1RILT5leGVjdXRlKCRzdHVkZW50KTsKCX0KfQoKJHBlcnNvbiA9IG5ldyBTdHVkZW50KCRfUE9TVCk7CiRTQVQgPSBuZXcgUERPKCdteXNxbDpob3N0PWxvY2FsaG9zdDtkYm5hbWU9c2F0JywgJ3Jvb3QnLCAnJyk7CiR0YWJsZSA9IG5ldyBTdHVkZW50TWFwcGVyKCRTQVQpOwokdGFibGUtPnNhdmVTdHVkZW50KCRwZXJzb24pOwoKPz4=