Using PDO with MVC
Posted
by
mister martin
on Programmers
See other posts from Programmers
or by mister martin
Published on 2012-12-09T15:16:26Z
Indexed on
2012/12/09
17:17 UTC
Read the original article
Hit count: 284
I asked this question at stackoverflow and received no response (closed as duplicate with no answer). I'm experimenting with OOP and I have the following basic MVC layout:
class Model {
// do database stuff
}
class View {
public function load($filename, $data = array()) {
if(!empty($data)) {
extract($data);
}
require_once('views/header.php');
require_once("views/$filename");
require_once('views/footer.php');
}
}
class Controller {
public $model;
public $view;
function __construct() {
$this->model = new Model();
$this->view = new View();
// determine what page we're on
$page = isset($_GET['view']) ? $_GET['view'] : 'home';
$this->display($page);
}
public function display($page) {
switch($page) {
case 'home':
$this->view->load('home.php');
break;
}
}
}
These classes are brought together in my setup file:
// start session
session_start();
require_once('Model.php');
require_once('View.php');
require_once('Controller.php');
new Controller();
Now where do I place my database connection code and how do I pass the connection onto the model?
try {
$db = new PDO('mysql:host='.DB_HOST.';dbname='.DB_DATABASE.'', DB_USERNAME, DB_PASSWORD);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $err) {
die($err->getMessage());
}
I've read about Dependency Injection, factories and miscellaneous other design patterns talking about keeping SQL out of the model, but it's all over my head using abstract examples. Can someone please just show me a straight-forward practical example?
© Programmers or respective owner