-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathModel.php
More file actions
103 lines (87 loc) · 2.92 KB
/
Model.php
File metadata and controls
103 lines (87 loc) · 2.92 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<?php
require_once "user_creds.php";
abstract class Model
{
/** @var PDO|null Connection to the database */
protected static $dbc = null;
/** @var array Database values for a single record. Array keys should be column names in the DB */
protected $attributes = array();
/**
* Constructor
*
* An instance of a class derived from Model represents a single record in the database.
*
* $param array $attributes Optional array of database values to initialize the model record with
*/
public function __construct(array $attributes = array())
{
self::dbConnect();
$this->attributes = $attributes;
// @TODO: Initialize the $attributes property with the passed value
}
/**
* Connect to the DB
*
* This method should be called at the beginning of any function that needs to communicate with the database
*/
protected static function dbConnect()
{
if (!self::$dbc) {
// @TODO: Connect to database
self::$dbc = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASS);
// Tell PDO to throw exceptions on error
self::$dbc->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
}
/**
* Get a value from attributes based on its name
*
* @param string $name key for attributes array
*
* @return mixed|null value from the attributes array or null if it is undefined
*/
public function __get($name)
{
// @TODO: Return the value from attributes for $name if it exists, else return null
if (array_key_exists($name, $this->attributes)) {
return $this->attributes[$name];
}
return null;
}
/**
* Set a new value for a key in attributes
*
* @param string $name key for attributes array
* @param mixed $value value to be saved in attributes array
*/
public function __set($name, $value)
{
// @TODO: Store name/value pair in attributes array
$this->attributes[$name] = $value;
}
/** Store the object in the database */
public function save()
{
// @TODO: Ensure there are values in the attributes array before attempting to save
if(empty($this->attributes)){
return;
} else if (isset($this->attributes['id'])){
$this->update();
} else{
$this->insert();
}
// @TODO: Call the proper database method: if the `id` is set this is an update, else it is a insert
}
/**
* Insert new entry into database
*
* NOTE: Because this method is abstract, any child class MUST have it defined.
*/
protected abstract function insert();
/**
* Update existing entry in database
*
* NOTE: Because this method is abstract, any child class MUST have it defined.
*/
protected abstract function update();
}