fefe

<?php

class DBController {
	private $conn = "";
	private $host = "localhost";
	private $user = "root";
	private $password = "Efr;
	private $database = "pufrfr

	function __construct() {
		$conn = $this->connectDB();
		if(!empty($conn)) {
			$this->conn = $conn;
		}
	}

	function connectDB() {
		$conn = mysqli_connect($this->host,$this->user,$this->password,$this->database);
		return $conn;
	}

	function runSelectQuery($query) {
		$result = mysqli_query($this->conn,$query);
		while($row=@mysqli_fetch_assoc($result)) {
			$resultset[] = $row;
		}
		if(!empty($resultset))
			return $resultset;
	}
	function runSelectQuerys($query) {
		$result = mysqli_query($this->conn,$query);
		while($row=@mysqli_fetch_assoc($result)) {
			$resultset[] = $row;
		}
		if(!empty($resultset))
			return $resultset[0];
	}
	function executeInsert($query) {
		//echo $query;die;
        $result = mysqli_query($this->conn,$query);
        $insert_id = mysqli_insert_id($this->conn);
		return $insert_id;

    }
	function executeUpdate($query) {
        $result = mysqli_query($this->conn,$query);
        return $result;

    }

	function executeQuery($sql) {
		$result = mysqli_query($this->conn,$sql);
		return $result;

    }

	function numRows($query) {
		$result  = mysqli_query($this->conn,$query);
		$rowcount = mysqli_num_rows($result);
		return $rowcount;
	}
}
?>