commonconfig.inc.php

<?php
    
    define('DATABASE_HOST', 'localhost');           // Database host
    define('DATABASE_NAME', 'amcapp');           // Name of the database to be used
    define('DATABASE_USERNAME', 'amcapp');       // User name for access to database
    define('DATABASE_PASSWORD', 'SH@ranya9836');   // Password for access to database
    
    define('DB_PREFIX', '');		        // Unique prefix of all tables in the database

    define('PASSWORDS_ENCRYPTION_TYPE',  '');  // AES|MD5
    define('PASSWORDS_ENCRYPTION',  '');              // true|false
    define('PASSWORDS_ENCRYPT_KEY', '');
    
	
	$connection=mysqli_connect('localhost','amcapp','SH@ranya9836','amcapp');
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_select_db($connection,'amcapp');

class DBController
{

    private $host = "localhost";

    private $user = "amcapp";

    private $password = "SH@ranya9836";

    private $database = "amcapp";

    private $conn;

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

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

    function runQuery($query, $param_type, $param_value_array)
    {
        $sql = $this->conn->prepare($query);
        $this->bindQueryParams($sql, $param_type, $param_value_array);
        $sql->execute();
        $result = $sql->get_result();
        
        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $resultset[] = $row;
            }
        }
        
        if (! empty($resultset)) {
            return $resultset;
        }
    }

    function bindQueryParams($sql, $param_type, $param_value_array)
    {
        $param_value_reference[] = & $param_type;
        for ($i = 0; $i < count($param_value_array); $i ++) {
            $param_value_reference[] = & $param_value_array[$i];
        }
        call_user_func_array(array(
            $sql,
            'bind_param'
        ), $param_value_reference);
    }

    function insert($query, $param_type, $param_value_array)
    {
        $sql = $this->conn->prepare($query);
        $this->bindQueryParams($sql, $param_type, $param_value_array);
        $sql->execute();
    }
}