<?php

/**
 * This file is part of untitled.
 * Copyright © 2017 Dominik Víšek <visekdo@gmail.com>
 */
class ConnectionPDO
{
	const HOST = '82.117.143.139';
	const DB_NAME = 'INTERFACE_BVR_ESH';
	const USERNAME = 'eshop';
	const PASSWORD = 'Forgac2016';

	private static $connection;

	public static function connect()
	{
		if (!isset(self::$connection)) {
			try {
				$connection_string = "SERVER={" . self::HOST . "};DATABASE={" . self::DB_NAME . "}";
				self::$connection = new \PDO('sqlsrv:' . $connection_string, self::USERNAME, self::PASSWORD);
			} catch (\PDOException $e) {
				echo $e->getMessage();
			}
		}
	}

	public static function findOne($query, $params = [])
	{
		$return = self::$connection->prepare($query);
		$return->execute($params);
		return $return->fetch();
	}

	public static function find($query, $params = [])
	{
		$return = self::$connection->prepare($query);
		$return->execute($params);
		return $return->fetchAll();
	}

	public static function findCount($query, $params = [])
	{
		$return = self::$connection->prepare($query);
		$return->execute($params);
		return $return->rowCount();
	}

	public static function insertData($query, $params = [])
	{
		self::$connection->prepare($query)->execute($params);
	}

}