root / models / nouveau_model.php @ 232b0a2c
Historique | Voir | Annoter | Télécharger (2,28 ko)
| 1 | 232b0a2c | Eric Seigne | <?php
|
|---|---|---|---|
| 2 | |||
| 3 | function insereMur($mur) { |
||
| 4 | global $db; |
||
| 5 | |||
| 6 | $sql = "INSERT INTO mur (nom,slug,descriptif,date_creation,date_acces,mdp_admin,mel_admin, mdp_acces, id_theme) "; |
||
| 7 | $sql.= "VALUES (:nom,:slug,:desc,CURDATE(),CURDATE(),:admin,:mel,:acces,:theme)"; |
||
| 8 | |||
| 9 | //$query->bindParam(':titre', $brique->getTitre());
|
||
| 10 | |||
| 11 | try {
|
||
| 12 | $query = $db->prepare($sql); |
||
| 13 | $query->bindParam(':nom', $mur->getNom()); |
||
| 14 | $query->bindParam(':slug', $mur->getSlug()); |
||
| 15 | $query->bindParam(':desc', $mur->getDescriptif()); |
||
| 16 | $query->bindParam(':admin', $mur->getMdpAdmin()); |
||
| 17 | $query->bindParam(':mel', $mur->getMelAdmin()); |
||
| 18 | $query->bindParam(':acces', $mur->getMdpAcces()); |
||
| 19 | $query->bindParam(':theme', $mur->getTheme()); |
||
| 20 | if (!$query->execute()) { |
||
| 21 | throw new MyException("Erreur dans l'insertion du mur"); |
||
| 22 | } |
||
| 23 | } catch (MyException $e) { |
||
| 24 | $e->errorMessage();
|
||
| 25 | } |
||
| 26 | |||
| 27 | |||
| 28 | /*
|
||
| 29 | $sql = "INSERT INTO mur ";
|
||
| 30 | $sql.= "(nom, slug, descriptif, date_creation, date_acces, mdp_admin, ";
|
||
| 31 | $sql.= "mel_admin, mdp_acces, id_theme) VALUES";
|
||
| 32 | $sql.= "(";
|
||
| 33 | $sql.= "'".$m->getNom()."','".$m->getSlug()."','".$m->getDescriptif()."',";
|
||
| 34 | $sql.= "CURDATE(), CURDATE(),";
|
||
| 35 | $sql.= "'".$m->getMdpAdmin()."','".$m->getMelAdmin()."',";
|
||
| 36 | $sql.= "'".$m->getMdpAcces()."','".$m->getTheme()."'";
|
||
| 37 | $sql.= ")";
|
||
| 38 | |||
| 39 | try {
|
||
| 40 | if(!$query=$db->query($sql)) {
|
||
| 41 | throw new MyException("Erreur dans INSERT");
|
||
| 42 | }
|
||
| 43 | } catch (MyException $e) {
|
||
| 44 | $e->errorMessage();
|
||
| 45 | }
|
||
| 46 | */
|
||
| 47 | return $db->lastInsertId(); |
||
| 48 | } |
||
| 49 | /**
|
||
| 50 | * Renvoie l'ensemble des thèmes de la BDD
|
||
| 51 | * @return [Array] [Tableau d'objets Theme]
|
||
| 52 | */
|
||
| 53 | function getAllThemes() { |
||
| 54 | global $db; |
||
| 55 | |||
| 56 | $sql = "SELECT * FROM theme ORDER BY nom"; |
||
| 57 | |||
| 58 | try {
|
||
| 59 | if(!$query = $db->query($sql)) { |
||
| 60 | throw new MyException("Erreur"); |
||
| 61 | } else {
|
||
| 62 | return $query->fetchAll(PDO::FETCH_CLASS, "Theme"); |
||
| 63 | } |
||
| 64 | } catch (MyException $e) { |
||
| 65 | $e->errorMessage();
|
||
| 66 | } |
||
| 67 | } |
||
| 68 | |||
| 69 | /**
|
||
| 70 | * Recherche un mur par son nom
|
||
| 71 | * @param [String] $nom [nom du mur]
|
||
| 72 | * @return [Array] [Tableau contenant le nom du mur ou vide]
|
||
| 73 | */
|
||
| 74 | function nomMurExiste($nom) { |
||
| 75 | global $db; |
||
| 76 | |||
| 77 | $sql = "SELECT nom FROM mur WHERE nom='$nom'"; |
||
| 78 | |||
| 79 | try {
|
||
| 80 | if(!$query = $db->query($sql)) { |
||
| 81 | throw new MyException("Erreur"); |
||
| 82 | } else {
|
||
| 83 | return $query->fetch(PDO::FETCH_COLUMN); |
||
| 84 | } |
||
| 85 | } catch (MyException $e) { |
||
| 86 | $e->errorMessage();
|
||
| 87 | } |
||
| 88 | } |