Project Overview

Connecting to MySql using PHP

class Model {protected$connection ="";protected$servername="localhost";protected$username="root";protected$password="";// your mysql database passwordprotected$dbname="";// database name// connecting with databasefunction__construct() {mysqli_report(MYSQLI_REPORT_STRICT);try {$this->connection =newmysqli($this->servername,$this->username,$this->password,$this->dbname);        }catch(Exception$e) {echo"Connection to database is failed".$e->getMessage();exit;        }    }}

Calling Model components from Controller

require_once('Models/Model.php');session_start();class Controllerextends Model {function__construct() {parent::__construct();$baseDir =basename(__FILE__);$location =substr($_SERVER['PHP_SELF'],strpos($_SERVER['PHP_SELF'],$baseDir) +strlen($baseDir));if($location) {switch($location) {// cases ..                }            }    }}