1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
public function /*array(ArticleDTO)*/ getAllTitleArticle()
{
try
{
$pdo = ConnexionPDO::getInstance();
$sql = "SELECT * FROM article";
$st = $pdo->getDBH()->prepare($sql);
$st->execute();
/*ArticleDTO*/ $articleDTO = new ArticleDTO();
$array = new ArrayObject();//array();//ArrayObject();
while($resultat->$st->fetch())
{
$articleDTO->setIdArticle($resultat['id']);
$articleDTO->setTitre($resultat['titre']);
$articleDTO->setTimestamp($resultat['date']);
//$articleDTO->setContenu($resultat['contenu']);
$array->append($articleDTO);
}
}
catch (Exception $e){ echo 'Exception reçue : ', $e->getMessage(), "\n"; }
CloseConnBD::closeConnection($pdo->getDBH());
return $array;
} |
Partager