+++ /dev/null
-<?php
-
- require_once('protected/required.php');
-
- class PdoTemplateManager extends AbstractPdoManager {
-
- public function createTemplate($template) {
-
- $query = $this -> pdo -> prepare(
- 'INSERT INTO templates (
- valeur1,
- valeur2,
- valeur3,
- valeur4,
- valeur5
- ) VALUES (
- :valeur1,
- :valeur2,
- :valeur3,
- :valeur4,
- :valeur5
- );'
- );
- $query -> bindValue(':valeur1', $template -> getValeur1());
- $query -> bindValue(':valeur2', $template -> getValeur2());
- $query -> bindValue(':valeur3', $template -> getValeur3());
- $query -> bindValue(':valeur4', $template -> getValeur4());
- $query -> bindValue(':valeur5', $template -> getValeur5());
- $query -> execute();
- }
-
- public function updateTemplate($template) {
-
- $query = $this -> pdo -> prepare(
- 'UPDATE templates
- SET valeur1 = :valeur1,
- valeur2 = :valeur2,
- valeur3 = :valeur3,
- valeur4 = :valeur4,
- valeur5 = :valeur5
- WHERE id = :id'
- );
- $query -> bindValue(':id', $template -> getId());
- $query -> bindValue(':valeur1', $template -> getValeur1());
- $query -> bindValue(':valeur2', $template -> getValeur2());
- $query -> bindValue(':valeur3', $template -> getValeur3());
- $query -> bindValue(':valeur4', $template -> getValeur4());
- $query -> bindValue(':valeur5', $template -> getValeur5());
- $query -> execute();
- }
-
- public function getTemplate($id) {
-
- $query = $this -> pdo -> prepare('SELECT * FROM templates WHERE id = :id');
- $query -> bindValue(':id', $id);
- $query -> execute();
-
- $result = $query -> fetch(PDO::FETCH_ASSOC);
- $template = new Template($result['id'], $result['valeur1'], $result['valeur2'], $result['valeur3'], $result['valeur4'], $result['valeur5']);
-
- $query->closeCursor();
-
- return $template;
- }
-
- public function getTemplates() {
-
- $query = $this -> pdo -> prepare('SELECT * FROM templates');
- $query -> execute();
-
- $results = $query -> fetchAll(PDO::FETCH_ASSOC);
- $templates = array();
- foreach ($results as $result) {
- $templates[] = new Template($result['id'], $result['valeur1'], $result['valeur2'], $result['valeur3'], $result['valeur4'], $result['valeur5']);
- }
-
- $query->closeCursor();
-
- return $templates;
- }
-
- public function removeTemplate($template) {
-
- $query = $this -> pdo -> prepare('DELETE FROM templates WHERE id = :id');
- $query -> bindValue('id', $template -> getId());
- $query -> execute();
- }
-
- }
-
-?>