function getAll() { global $bdd; $condition = ''; if (!empty($this->titre)) { $condition .= ''; } if (Securite::isInt($this->type)) { $condition .= 'AND id_type = :type'; } if (Securite::isInt($this->categorie)) { $condition .= 'AND id_categorie = :cat'; } // -- Récupération -- $requete = $bdd->prepare("SELECT * FROM medias WHERE id_media IN (SELECT id_media FROM exemplaires WHERE num_exemplaire != ''" . getFree() . ") " . $condition); if (!empty($this->titre)) { $requete->bindParam(':titre', $this->titre, PDO::PARAM_INT); } if (Securite::isInt($this->type)) { $requete->bindParam(':type', $this->type, PDO::PARAM_INT); } if (Securite::isInt($this->categorie)) { $requete->bindParam(':cat', $this->categorie, PDO::PARAM_INT); } $requete->execute(); return $requete->fetchAll(PDO::FETCH_ASSOC); }
// Vérif existence -- $retour = $model->getById($_GET[$page['keyAction']]); if (!empty($retour)) { $page['id_ext'] = $_GET[$page['keyAction']]; $valide = true; } } if (!$valide) { $page['keyAction'] = false; } } // Vérification base -- $requireExt = array('keywords', 'auteurs', 'editeurs', 'roles'); if (in_array($ext, $requireExt)) { $valide = false; if (isset($_GET['id']) && Securite::isInt($_GET['id'])) { // Vérif existence -- if ($model->parentExists($_GET['id'])) { $page['id'] = $_GET['id']; $page['url'] .= "&id=" . $page['id']; $valide = true; } } $requireExt = array('lier', 'delier'); if (in_array($page['keyAction'], $requireExt) && !$valide) { $page['keyAction'] = false; } } // -- Gestion des exceptions -- if ($ext == 'types') { $page['exception'] = 'type';
else { unset($list[$element['id']]); } } */ // -- Vidange -- for ($i = 1; $i < 4; $i++) { if (isset($_SESSION['el' . $i])) { unset($_SESSION['el' . $i]); } } print_r($_POST); $inc = count($page['empruntsFixes']); // -- Remplissage -- for ($i = 1; $i < 4; $i++) { if (isset($_POST['Id' . $i]) && Securite::isInt($_POST['Id' . $i])) { $id = intval($_POST['Id' . $i]); $last = 1; //ModelMedia::getLastFreeMediaId($id); if ($last != 0 && $inc < 4) { $_SESSION['el' . $i] = $id; $inc++; } else { echo 'Impossible'; } } else { echo 'Gnan !'; } } header('Location: ?user=emprunt'); }