<?php
ini_set('display_errors', 1);

class Users {
	protected $host ;
	protected $charset;
	protected $db;
	protected $user;
	protected $pass;

	public function __construct() {
		$this->host = 'localhost';
		$this->charset = 'utf8';
		$this->db = 'dz8';
		$this->user = 'root';
		$this->pass = '';
	}

	public function baseConfig(){

		$dsn="mysql:host=$this->host;dbname=$this->db;";
		$opt = array (
			PDO::ATTR_ERRMODE	=> PDO::ERRMODE_EXCEPTION,
			PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
		);

		$this->pdo = new PDO($dsn, $this->user, $this->pass);
	}

	public function update($id, $name, $surname, $age) {
		$stmt = $this->pdo->prepare('UPDATE users SET name = :name, surname = :surname, age = :age WHERE id= :id');
		$result	= $stmt->execute(array('id' => $id, 'name' => $name, 'surname' => $surname, 'age' => $age));

		return $result;
	}

	public function add($name, $surname, $age) {
		$stmt = $this->pdo->prepare('INSERT INTO users SET name = :name, surname = :surname, age = :age');
		$result	= $stmt->execute(array('name' => $name, 'surname' => $surname, 'age' => $age));

		return $result;
	}

	public function delete($id) {
		$stmt = $this->pdo->prepare('DELETE FROM users WHERE id = :id');
	   	$result = $stmt->execute(['id'=>$id]);

	   	return $result;
	}

	public function selectOne($id) {

		$stmt = $this->pdo->prepare('SELECT * FROM users WHERE id= :id');
		$stmt->execute(array('id' => $id));
		$users = $stmt->fetch();

		return $users;
	}

	public function selectBySurname($surname) {

		$stmt = $this->pdo->prepare('SELECT * FROM users WHERE surname= :surname');
		$stmt->execute(array('surname' => $surname));

		$users = $stmt->fetchAll();

		return $users;
	}

	public function selectAll() {

		$stmt = $this->pdo->prepare('SELECT * FROM users');
		$stmt->execute(array());

		$users = $stmt->fetchAll();

		return $users;
	}
}

$users 	= new Users();
$users->baseConfig();

$surnameItems	= $users->selectBySurname('Петренко');
$allItems = $users->selectAll();