public static function ListerBase() { $db = getConnexionDB(); $requete = "SELECT * FROM arme where debase = 1 order by nom asc"; $tableau = array(); $stmt = $db->prepare($requete); $stmt->execute(); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $temp = new arme($rs['ID'], $rs['NOM'], $rs['NOM_COURT'], $rs['PRIX'], $rs['PI'], $rs['RUP'], $rs['AT'], $rs['PRD'], $rs['COU'], $rs['INT'], $rs['CHA'], $rs['AD'], $rs['FOR'], $rs['SPECIAL'], $rs['JET'], $rs['qualite'], $rs['type'], $rs['deuxmains'], $rs['debase']); $ajouter = true; foreach ($tableau as $arme) { if (Arme::ArmesEgales($arme, $temp)) { $ajouter = false; } } if ($ajouter) { $tableau[] = $temp; } } return $tableau; }
public static function ListerOfficiel() { $db = DatabaseManager::getDb(); $requete = "SELECT * FROM " . PREFIX_DB . "arme where arme_officiel = 1 order by arme_PRIX asc, arme_NOM asc"; $tableau = array(); $stmt = $db->prepare($requete); $stmt->execute(); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $temp = new arme($rs); $ajouter = true; foreach ($tableau as $arme) { if (Arme::ArmesEgales($arme, $temp)) { $ajouter = false; } } if ($ajouter) { $tableau[] = $temp; } } return $tableau; }