connection.php

<?php

class createConnection 				//create a class for make connection
{
    protected static $host;
    protected static $username;
    protected static $password;
    protected static $database;
    protected static $port ;

    var $myconn;

   
    public function __construct() {
        $this->host=$_ENV['DB_HOST'] ;
        $this->username=$_ENV['DB_USER'];    			// specify the sever details for mysql
        $this->password=$_ENV['DB_PASSWORD'];
        $this->database=$_ENV['DB_DATABASE'];
        $this->port = $_ENV['DB_PORT'];
    }

    function connectToDatabase() 		// create a function for connect database
    {
        $conn= mysqli_connect($this->host,$this->username,$this->password, $this->database, $this->port);

        if(!$conn)// testing the connection
        {
            die ("Cannot connect to the database");
        }

        else
        {

            $this->myconn = $conn;

						//            echo "Connection established";

        }

        return $this->myconn;

    }

    function selectDatabase() 			// selecting the database.
    {
        mysqli_select_db($this->myconn, $this->database);  	//use php inbuild functions for select database

        if(mysqli_error($this->myconn)) 			// if error occured display the error message
        {

            echo "Cannot find the database ".$this->database;

        }
						//         echo "Database selected..";       
    }

    function closeConnection() 			// close the connection
    {
        mysqli_close($this->myconn);

						//        echo "Connection closed";
    }

}

?>