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 static function getAllArticless($currentPage) {
//connexion a la base de données
try {
$bdd = new PDO('mysql:host=xxxxxx;dbname=xxxxxxx', 'root', 'SQLadmin');
} catch (Exception $e) {
die('Erreur : ' . $e->getMessage());
}
//N
$nombresElmParPage = 2;
//S
$startPage = ($currentPage - 1) * $nombresElmParPage;
//requete qui me permet de faire ma pagination
$queryArticles = $bdd->prepare("SELECT id FROM `articles` LIMIT :startPage, :nombresElmParPage");
$queryArticles->execute(array(
'startPage' => $startPage,
'nombresElmParPage' => $nombresElmParPage,
));
//recupère les données
$articles = $queryArticles->fetchAll();
$arrayArticles = array();
foreach ($articles as $article) {
$objectArticle = new Article($article['id']);
$arrayArticles[] = $objectArticle;
}
//retourne mon tableau
return $arrayArticles;
} |
Partager