/**
* Récupère les articles.
*
* @return Collection
*
* @throws ErrorSQLException
* @throws CollectionException
*/
public static function getArticles()
{
$lesArticles = new Collection();
try {
$conn = MConnexion::getBdd();
$reqPrepare = $conn->query('SELECT * FROM article');
$reqPrepare = $reqPrepare->fetchAll();
foreach ($reqPrepare as $unArticle) {
$article = new Article();
$article->setNumArt($unArticle['numArt'])->setDesignation($unArticle['designation'])->setDescription($unArticle['description'])->setPu($unArticle['pu'])->setQteStock($unArticle['qteStock'])->setUrl($unArticle['url']);
$lesArticles->ajouter($article);
}
$conn = null;
return $lesArticles;
} catch (PDOException $ex) {
throw new ErrorSQLException('Aucun article trouvé.');
}
}
