+++ /dev/null
-<?php
-
- require_once('protected/required.php');
-
- class PdoUsagerManager extends AbstractPdoManager implements UsagerManager {
-
- public function createUsager($usager) {
-
- $query = $this -> pdo -> prepare(
- 'INSERT INTO usagers (nom, reference) VALUES (:nom, :reference)'
- );
- $query -> bindValue(':nom', $usager -> getNom());
- $query -> bindValue(':reference', $usager -> getReference());
- $query -> execute();
- $query -> closeCursor();
-
- }
-
- public function updateUsager($usager) {
-
- $query = $this -> pdo -> prepare(
- 'UPDATE usagers SET nom = :nom, reference = :reference WHERE id = :id'
- );
- $query -> bindValue(':id', $usager -> getId());
- $query -> bindValue(':nom', $usager -> getNom());
- $query -> bindValue(':reference', $usager -> getReference());
- $query -> execute();
-
- }
-
- public function getUsager($id) {
-
- $query = $this -> pdo -> prepare('SELECT * FROM usagers WHERE id = :id');
- $query -> bindValue(':id', $id);
- $query -> execute();
-
- $result = $query -> fetch(PDO::FETCH_ASSOC);
- $usager = new Usager($result['id'], $result['nom'], $result['reference']);
-
- $query->closeCursor();
-
- return $usager;
- }
-
- public function getUsagers() {
-
- $query = $this -> pdo -> prepare('SELECT * FROM usagers');
- $query -> execute();
-
- $results = $query -> fetchAll(PDO::FETCH_ASSOC);
- $usagers = array();
- foreach ($results as $result) {
- $usagers[] = new Usager($result['id'], $result['nom'], $result['reference']);
- }
-
- $query->closeCursor();
-
- return $usagers;
- }
-
- public function getUsagerByReference($reference) {
-
- $query = $this -> pdo -> prepare('SELECT * FROM usagers WHERE reference = :reference');
- $query -> bindValue(':reference', $reference);
- $query -> execute();
-
- $result = $query -> fetch(PDO::FETCH_ASSOC);
- $usager = new Usager($result['id'], $result['nom'], $result['reference']);
-
- $query->closeCursor();
-
- return $usager;
- }
-
- public function removeUsager($usager) {
-
- $query = $this -> pdo -> prepare('DELETE FROM usager WHERE id = :id');
- $query -> bindValue('id', $usager -> getId());
- $query -> execute();
-
- }
-
- }
-
-?>