MyProject/app/core/db.php

<?php

class db
{
    private $credinternals = [
        'dbhost' => 'localhost',
        'dbname' => 'myproject',
        'dbuser' => 'root',
        'dbpass' => ''
    ];

    public  $conn;

    public function __construct(){


        $this->conn = mysqli_connect(
            $this->credinternals['dbhost'],
            $this->credinternals['dbuser'],
            $this->credinternals['dbpass'],
            $this->credinternals['dbname']
        );

        if(!$this->conn) die('DB connect error!');

    }

    public function query($q){
        $data = mysqli_query($this->conn, $q);
        if(is_bool($data)) {
            return $data;
        } else {
            return $data->fetch_assoc();
        }

    }

    public function escape($str){
        return "'" . mysqli_real_escape_string($this->conn, $str) . "'";
    }

}