<?php

namespace vs_lib\system;

	class Connection
	{
		private static $SERVER= "localhost";
		private static $DATA_BASE_NAME= "visualdata";
		private static $DATA_BASE_USER= "root";
		private static $DATA_BASE_PASS= "";

		private static $PDO;

		public static function PDO()
		{
			if(self::$PDO!=null)
				return self::$PDO;

			$dsn = 'mysql:host='+self::$SERVER+';dbname='+self::$DATA_BASE_NAME;
			$user = self::$DATA_BASE_USER;
			$password = self::$DATA_BASE_PASS;

			try {

				$db = new PDO($dsn, $user, $password);
				self::$PDO = $db;

				return $db;
			} catch (PDOException $e) {
				echo 'Connection failed: ' . $e->getMessage();
			}
		}

		//Where queryleri için kullanılacak
		public static function Where($whereQuery)
		{
			$db = Connection::PDO();

			if($data = $db->query($whereQuery))
			{
				return $data;
			}
			else
			{
				$error = $db->errorInfo();
				echo 'Error : ' . $error[2];
			}
		}

	}

?>