DatabaseProcess.php

<?php

class DatabaseProcess {
	private $servername;
	private $username;
	private $password;
	private $dbname;
	private $conn;
	private $isAlreadyInitialized;

	public function __construct() {
		$this->servername = "localhost";
		$this->username = "revw4882_Rinda";
		$this->password = "d4xCtsNmjLZ65PG";
		$this->dbname = "revw4882_Rinda_Introduction-to-Data-and-Information-Management";
		$this->isAlreadyInitialized = false;
	}

	public function initializeDatabaseForApplication() {
		if(!$this->isAlreadyInitialized) {
			$this->createConnectionIfNeeded();
			$this->isAlreadyInitialized = true;
		}
	}

	function createConnectionIfNeeded() {
		if(!$this->conn) {
        	$this->conn = new mysqli($this->servername, $this->username, $this->password, $this->dbname);
            // Check connection
            if ($this->conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
                echo "Connection DB Error, " . $conn->connect_error;
                echo "<BR><BR>";
            } else {
                echo "Connection DB successfully";
                echo "<BR><BR>";
            }
        }
	}

	public function fetchBarang() {
		$resultQuery = mysqli_query($this->conn, "SELECT * FROM Barang");
		$resultTable = "";
		while ($resultData = mysqli_fetch_array($resultQuery, MYSQLI_ASSOC)) {
			$resultTable .= "<TR><TD>".$resultData['IdBarang']."</TD><TD>".$resultData['NamaBarang']."</TD><TD>".$resultData['Keterangan']."</TD><TD>".$resultData['Satuan']."</TD><TD>".$resultData['IdPengguna']."</TD><TD><button type=\"button\">EDIT</button> <button type=\"button\">HAPUS</button></TD></TR>";
		}

		print($resultTable);

		return $resultTable;
	}

	public function insertBarang($id, $name, $keterangan, $satuan) {
		$resultQuery = mysqli_query($this->conn, "INSERT INTO Barang VALUES ($id, $name, $keterangan, $satuan, 1)");
		
		if ($this->conn->query($resultQuery) === TRUE) {
		 	header("Refresh:0");
		} else {
		 	//echo "Error: " . $sql . "<br>" . $conn->error;
		}
	}

	public function closeConnection() {
		$this->conn->close();
	}
}

?>