class Account {
		private $db;
		private $db_id;
		public $id_number, $first_name, $middle_name, $last_name, $age, $password, $picture;

		public function __construct($db) {
			$this->db = $db;
		}

		public function createAccount($id_number = '', $first_name = '', $middle_name = '', $last_name = '', $age = '', $password = '', $picture = '') {
			$result = $this->db->query("select a_id from accounts where a_id_number = ?", $id_number)->fetchArray();
			print_r($result);

			if (!isset($result['a_id'])) {
				$result = $this->db->query('insert into accounts (a_id_number, a_first_name, a_middle_name, a_last_name, a_age, a_password, a_picture) values (?, ?, ?, ?, ?, ?, ?)', $id_number, $first_name, $middle_name, $last_name, $age, $password, $picture);
				$this->loadAccount($this->db->getId());
			} else {
				$this->loadAccount($result['a_id']);
			}
		}

		public function loadAccount($id) {
			$this->db_id = $id;

			$result = $this->db->query("select * from accounts where a_id = ?", array($id))->fetchArray();

			foreach ($result as $var=>$value) {
				$field_name = substr($var, 2, 1000);
				$this->{$field_name} = $value;
			}
		}


		public function __destruct() {
			//echo "This object class is being destroyed -- " . __CLASS__ . "\n";
		}

		public function setProperty($field, $value) {
			$this->{$field} = $value;

			$this->db->query("update accounts set a_".$field." = UNHEX('".bin2hex($value)."') where a_id = '".$this->db_id."'");
		}
	}