public static function LastNews() { $db = DatabaseManager::getDb(); $requete = "SELECT * FROM news order by date_news DESC"; $tableau = array(); foreach ($db->query($requete) as $row) { $tableau[] = new News($row['ID_NEWS'], $row['DATE_NEWS'], $row['TITRE'], $row['TEXTE']); } return $tableau; }
public static function ListerPourPaladin() { $db = DatabaseManager::getDb(); $requete = "SELECT * FROM " . PREFIX_DB . "dieu where DIEU_PALADIN = 1"; $tableau = array(); $stmt = $db->prepare($requete); $stmt->execute(); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $tableau[] = new dieu($rs); } return $tableau; }
<?php include __DIR__ . "/config/config.php"; include __DIR__ . "/model/autoloader.class.php"; $db = DatabaseManager::getDb(); $requete = "select * \n from " . PREFIX_DB . "lien_aventurier_arme\n join " . PREFIX_DB . "arme on " . PREFIX_DB . "arme.ARME_ID = " . PREFIX_DB . "lien_aventurier_arme.ID_ARME LIMIT 10, 9999"; $stmt = $db->prepare($requete); $stmt->execute(); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $arme = new Arme($rs); $arme->ARME_AVENTURIER_ID = $rs["ID_AVENTURIER"]; $arme->ajouter(); }
public function determineCompetences() { if ($this->METIER != "" && $this->ORIGINE != "") { if ($this->METIER->ID == 99) { $this->COMPETENCESLIEES = $this->METIER->COMPETENCESLIEES; } else { $this->COMPETENCESLIEES = fusionneCompetencesSansDoublons($this->METIER->COMPETENCESLIEES, $this->ORIGINE->COMPETENCESLIEES); } } if (empty($this->ID)) { return; } $db = DatabaseManager::getDb(); $requete = "SELECT * FROM lien_aventurier_competence WHERE ID_AVENTURIER = " . $this->ID; $stmt = $db->prepare($requete); $stmt->execute(); $this->COMPETENCESCHOISIES = array(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $comp = new Competence(); $this->COMPETENCESCHOISIES[] = $comp; } $this->competences = fusionneCompetencesSansDoublons($this->COMPETENCESCHOISIES, $this->COMPETENCESLIEES); }
public function loadFromDB($id) { $db = DatabaseManager::getDb(); $requete = "SELECT * FROM " . PREFIX_DB . "magie WHERE MAGIE_ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->LoadFromArray($ligne); }
function getConnexionDB() { return DatabaseManager::getDb(); }
public function loadFromDB($id) { $db = DatabaseManager::getDb(); $requete = "SELECT * FROM metier WHERE METIER_ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->METIER_ID = $ligne['METIER_ID']; $this->METIER_NOM = $ligne['METIER_NOM']; $this->METIER_EV = $ligne['METIER_EV']; $this->METIER_EA = $ligne['METIER_EA']; $this->METIER_AT = $ligne['METIER_AT']; $this->METIER_PRD = $ligne['METIER_PRD']; $this->METIER_FOMIN = $ligne['METIER_FOMIN']; $this->METIER_FOMAX = $ligne['METIER_FOMAX']; $this->METIER_ADMIN = $ligne['METIER_ADMIN']; $this->METIER_ADMAX = $ligne['METIER_ADMAX']; $this->METIER_INTMIN = $ligne['METIER_INTMIN']; $this->METIER_INTMAX = $ligne['METIER_INTMAX']; $this->METIER_CHAMIN = $ligne['METIER_CHAMIN']; $this->METIER_CHAMAX = $ligne['METIER_CHAMAX']; $this->METIER_COUMIN = $ligne['METIER_COUMIN']; $this->METIER_COUMAX = $ligne['METIER_COUMAX']; $this->METIER_RESTRICTION = $ligne['METIER_RESTRICTION']; $this->METIER_BONUS = $ligne['METIER_BONUS']; $this->METIER_PRMAX = $ligne['METIER_PRMAX']; $db = DatabaseManager::getDb(); $requete = "SELECT ID_COMPETENCE FROM lien_metier_competence_native WHERE ID_METIER = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $competence = new Competence($ligne["ID_COMPETENCE"]); $this->METIER_COMPETENCESLIEES[] = $competence; } $requete = "SELECT ID_COMPETENCE FROM lien_metier_competence_choix WHERE ID_METIER = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); while ($ligne = $stmt->fetch(PDO::FETCH_ASSOC)) { $competence = new Competence($ligne["ID_COMPETENCE"]); $this->METIER_COMPETENCESACHOISIR[] = $competence; } }
public function get_data_from_db($id) { $db = DatabaseManager::getDb(); $requete = "SELECT * FROM " . PREFIX_DB . "arme WHERE ARME_ID = " . $id; $stmt = $db->prepare($requete); $stmt->execute(); $ligne = $stmt->fetch(PDO::FETCH_ASSOC); $this->loadFromArray($ligne); }