Slide 42
Slide 42 text
class ArticleMapper extends Mapper
{
protected function insert(array $data)
{
$stmt = $this->dbh->prepare('INSERT INTO ... ');
$stmt->bindValue(':title', $data['title'], PDO::PARAM_STR);
$stmt->bindValue(':body', $data['body'], PDO::PARAM_STR);
$stmt->execute();
return 1 === (int) $stmt->rowCount();
}
protected function update($pk, array $data)
{
$stmt = $this->dbh->prepare('UPDATE ... WHERE id = :id ');
$stmt->bindValue(':title', $data['title'], PDO::PARAM_STR);
$stmt->bindValue(':body', $data['body'], PDO::PARAM_STR);
$stmt->bindValue(':id', $pk, PDO::PARAM_INT);
$stmt->execute();
return 1 === (int) $stmt->rowCount();
}
}