function getArticles() { $conn = MConnexion::getBdd(); $resultats = $conn->query('SELECT * FROM article'); $resultats->setFetchMode(PDO::FETCH_OBJ); return $resultats->fetchAll(); }
function getLogin($email, $pwd) { $conn = MConnexion::getBdd(); $resultats = $conn->prepare('SELECT * FROM client WHERE mailClt = ? AND mdpClt = ?'); $resultats->execute([$email, sha1($pwd)]); $resultats->setFetchMode(PDO::FETCH_OBJ); return $resultats->fetch(); }
function getArticle($id) { $conn = MConnexion::getBdd(); $resultats = $conn->prepare('SELECT * FROM article WHERE numArt = ?'); $resultats->execute([$id]); $resultats->setFetchMode(PDO::FETCH_OBJ); return $resultats->fetch(); }
function getVols() { $conn = MConnexion::getBdd(); $resultats = $conn->query('SELECT * FROM vol WHERE DATE_ADD(CURDATE(), INTERVAL -1 DAY) < dateVol ORDER BY dateVol'); $resultats->setFetchMode(PDO::FETCH_OBJ); return $resultats->fetchAll(); }