myPDO

mypdo-example.php

<?php

	class myPDO {
		
		var $driver = 'mysql';
		var $host = 'localhost';
		var $dbname = 'database';
		var $username = 'username';
		var $password = 'password';
		var $charset = 'utf8';
		var $stmt = '';
		var $result = '';
		
		function conn($driver = '', $host = '', $dbname = '', $username = '', $password = '', $charset = '') {
			if(!empty($driver)){
				$this->driver = $driver;
			}
			if(!empty($host)){
				$this->host = $host;
			}
			if(!empty($dbname)){
				$this->dbname = $dbname;
			}
			if(!empty($username)){
				$this->username = $username;
			}
			if(!empty($password)){
				$this->password = $password;
			}
			if(!empty($charset)){
				$this->charset = $charset;
			}
			
			return new pdo("$this->driver:host=$this->host;dbname=$this->dbname;charset=$this->charset;", $this->username, $this->password);
		}
		
		function sql($sql='') {
			$this->stmt = $this->conn()->prepare($sql);
		}

		function result($input=[], $fetch_style = PDO::FETCH_ASSOC) {
			$this->stmt->execute($input);
			return $this->stmt->fetchAll($fetch_style);
		}

		function row($input=[], $fetch_style = PDO::FETCH_ASSOC) {
			$this->stmt->execute($input);
			return $this->stmt->fetch($fetch_style);
		}

	}