public function retour_active() { $requete = $this->_db->prepare('select * from type_article where active=:active order by nom'); $requete->execute(array(':active' => self::$active)); $results = $requete->fetchAll(); $tabobject = array(); if (empty($results)) { /** Si pas de resultats alors retourne faux */ return false; } else { foreach ($results as $result) { $macategorie = new CategorieArticle(); $macategorie->setId($result['id'])->setNom($result['nom'])->setActive($result['active']); array_push($tabobject, $macategorie); // Push l'objet $article dans le tableau $tabobject } return $tabobject; } }
<?php /** * Created by PhpStorm. * User: Florent * Date: 22/04/2015 * Time: 11:57 */ require_once '../Database/pdo.php'; require_once '../Entity/CategorieArticle.php'; require_once '../EntityManager/CategorieArticleManager.php'; $active = 1; $inactive = 0; if ($_POST['active'] == 1) { $categorie = new CategorieArticle(); $categorie->setActive($inactive)->setId($_POST['id']); $managercategoriearticle = new CategorieArticleManager($bdd); $managercategoriearticle->activation_desactivation($categorie); header('Location:../Main/categoriearticle.php'); } elseif ($_POST['active'] == 0) { $categorie = new CategorieArticle(); $categorie->setActive($active)->setId($_POST['id']); $managercategoriearticle = new CategorieArticleManager($bdd); $managercategoriearticle->activation_desactivation($categorie); header('Location:../Main/categoriearticle.php'); } else { header('Location:../Main/categoriearticle.php'); }
public function activation_desactivation(CategorieArticle $categorie) { $requete = $this->_db->prepare('update type_article set active=:active where id=:id'); $requete->execute(array(':active' => $categorie->getActive(), ':id' => $categorie->getId())); }
<?php /** * Created by PhpStorm. * User: Florent * Date: 17/04/2015 * Time: 10:48 */ require_once '../Navbar/navbar.php'; require_once '../Database/pdo.php'; require_once '../Entity/CategorieArticle.php'; require_once '../EntityManager/CategorieArticleManager.php'; $active = 1; $macategorie = new CategorieArticle(); $macategorie->setNom($_POST['nom'])->setActive($active); $monmanagercategorie = new CategorieArticleManager($bdd); $monmanagercategorie->insertion($macategorie); header('Location:../Main/categoriearticle.php');
<?php /** * Created by PhpStorm. * User: Florent * Date: 17/04/2015 * Time: 10:48 */ require_once '../Navbar/navbar.php'; require_once '../Database/pdo.php'; require_once '../Entity/CategorieArticle.php'; require_once '../EntityManager/CategorieArticleManager.php'; $macategorie = new CategorieArticle(); $macategorie->setId($_POST['id'])->setNom($_POST['nom']); $monmanagercategorie = new CategorieArticleManager($bdd); $monmanagercategorie->modification($macategorie); header('Location:../Main/categoriearticle.php');