daldantas/contacts.php

## contacts.php
<?php
//  DATABASE GENERATOR
    // CREATE DATABASE db;
    // USE db;
    // CREATE TABLE contacts (
    //   id int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    //   name varchar(255) NOT NULL,
    //   email varchar(255) NOT NULL,
    //   phone varchar(15) NOT NULL);
    // INSERT INTO contacts (name, email, phone) VALUES
    // ('Contact 1', 'contact1@email.com', '(01) 99999-9999'),
    // ('Contact 2', 'contact2@email.com', '(02) 88888-8888');

//  MODELS
    class Model
    {
    	private $host 	= "localhost";
    	private $user	= "root";
    	private $pass 	= "";
    	private $db	= "db";
    	private $mysqli;
    	protected function execute($q)
    	{
    		$this->mysqli = new mysqli($this->host, $this->user, $this->pass, $this->db);
    		return $this->mysqli->query($q);
    		$this->mysqli->close();
    	}
    }
    class Contact extends Model
    {
      private $q;
      private $name;
      private $email;
      private $phone;
      protected function selectAll()
      {
      	$this->q = "SELECT * FROM contacts";
      	return $this->execute($this->q);
      }
    }

// CONTROLLER
    class Contacts extends Contact
    {
      private $data;
      public function getAll()
      {
      	$this->data = $this->selectAll();
      	return $this->data;
      }

    }

// TO VIEW
    $contacts = new Contacts;
    $data['contacts'] = $contacts->getAll();
    foreach ( $data as $key => $value ){ $$key = $value; }
    ?>

<!-- VIEW -->
<!DOCTYPE html>
<html lang="pt-br">
<head>
  <meta charset="utf-8">
	<title>Contacts</title>
</head>
<body>
<h1>Contact List</h1>
 <table cellpadding="10" style="text-align: left">
  <tr>
    <th>Id</th>
    <th>Name</th>
    <th>Email</th>
    <th>Phone</th>
  </tr>

  <?php foreach ($contacts as $cont => $c): ?>
		  <tr>
		    <td><?=$c['id']?></td>
		    <td><?=$c['name']?></td>
		    <td><?=$c['email']?></td>
		    <td><?=$c['phone']?></td>
		  </tr>
  <?php endforeach ?>

</table>
</body>
</html>
	<?php
	// DATABASE GENERATOR
	// CREATE DATABASE db;
	// USE db;
	// CREATE TABLE contacts (
	// id int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	// name varchar(255) NOT NULL,
	// email varchar(255) NOT NULL,
	// phone varchar(15) NOT NULL);
	// INSERT INTO contacts (name, email, phone) VALUES
	// ('Contact 1', 'contact1@email.com', '(01) 99999-9999'),
	// ('Contact 2', 'contact2@email.com', '(02) 88888-8888');

	// MODELS
	class Model
	{
	private $host = "localhost";
	private $user = "root";
	private $pass = "";
	private $db = "db";
	private $mysqli;
	protected function execute($q)
	{
	$this->mysqli = new mysqli($this->host, $this->user, $this->pass, $this->db);
	return $this->mysqli->query($q);
	$this->mysqli->close();
	}
	}
	class Contact extends Model
	{
	private $q;
	private $name;
	private $email;
	private $phone;
	protected function selectAll()
	{
	$this->q = "SELECT * FROM contacts";
	return $this->execute($this->q);
	}
	}

	// CONTROLLER
	class Contacts extends Contact
	{
	private $data;
	public function getAll()
	{
	$this->data = $this->selectAll();
	return $this->data;
	}

	}

	// TO VIEW
	$contacts = new Contacts;
	$data['contacts'] = $contacts->getAll();
	foreach ( $data as $key => $value ){ $$key = $value; }
	?>

	<!-- VIEW -->
	<!DOCTYPE html>
	<html lang="pt-br">
	<head>
	<meta charset="utf-8">
	<title>Contacts</title>
	</head>
	<body>
	<h1>Contact List</h1>
	<table cellpadding="10" style="text-align: left">
	<tr>
	<th>Id</th>
	<th>Name</th>
	<th>Email</th>
	<th>Phone</th>
	</tr>

	<?php foreach ($contacts as $cont => $c): ?>
	<tr>
	<td><?=$c['id']?></td>
	<td><?=$c['name']?></td>
	<td><?=$c['email']?></td>
	<td><?=$c['phone']?></td>
	</tr>
	<?php endforeach ?>

	</table>
	</body>
	</html>