Forum : Pagination réorganisation

Bonjour

J'ai un soucis de syntaxe dans mon code pourtant je n'aie pas l'impression d'avoir un soucis...

Sur mon navigateur j'ai cette erreur :

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' . 4' at line 1

Je suis a 13:57 de la vidéo :
https://grafikart.fr/tutoriels/tp-pagination-refactor-php-1170#autoplay

Mon fichier src/PaginatedQuery.php

<?php namespace App; use \PDO; class PaginatedQuery { private $query; private $queryCount; private $classMapping; private $pdo; private $perPage; public function __construct(string $query, string $queryCount, string $classMapping, ?\PDO $pdo = null, int $perPage = 12) { $this->query = $query; $this->queryCount = $queryCount; $this->classMapping = $classMapping; $this->pdo = $pdo ?: Connection::getPDO(); $this->perPage = $perPage; } public function getItems(): array { $currentPage = URL::getPositiveInt('page', 1); $count = (int)$this->pdo ->query( $this->queryCount) ->fetch(PDO::FETCH_NUM)[0]; $pages = ceil($count / $this->perPage); if ($currentPage > $pages) { throw new Exception('Cette page existe pas'); } $offset = $this->perPage * ($currentPage - 1); return $this->pdo->query( $this->query . " LIMIT {$this->perPage} OFFSET $offset ") ->fetchAll(PDO::FETCH_CLASS, $this->classMapping); } }

Mon fichier views/category/show.php

<?php use App\Connection; use App\Model\{Category, Post}; use App\PaginatedQuery; $id = (int)$params['id']; $slug = $params['slug']; $pdo = Connection::getPDO(); $query = $pdo->prepare(('SELECT * FROM category WHERE id = :id')); $query->execute(['id' => $id]); $query->setFetchMode(PDO::FETCH_CLASS, Category::class); /** @var Category|false */ $category = $query->fetch(); //dd($post); // si aucun article est trouver if ($category === false) { throw new Exception('Aucune catgéforie ne correspont à cet ID'); } // Permet de rediriger l'url vers le bon slug if ($category->getSlug() !== $slug) { $url = $router->url('category', ['slug' => $category->getSlug(), 'id' => $id]); http_response_code(301); header('Location ' . $url); } $title = "Catégorie {$category->getName()}"; $paginatedQuery = new PaginatedQuery( "SELECT p.* FROM post p JOIN post_category pc ON pc.post_id = p.id; WHERE pc.category_id = {$category->getID()} ORDER BY created_at DESC ;", "SELECT COUNT(category_id) FROM post_category WHERE category_id = ' . {$category->getID()}", Post::class ); /** @var Post[] */ $posts = $paginatedQuery->getItems(); dd($posts); $link = $router->url('category', ['id' => $category->getID(), 'slug' => $category->getSlug()]); ?> <h1> <?= $title; ?> </h1> <div class="row"> <?php foreach ($posts as $post) : ?> <div class="col-md-3"> <?php require dirname (__DIR__) . '/post/card.php' ?> </div> <?php endforeach ?> </div> <div class="d-flex justify-content-between my-4"> <?php if ($currentPage > 1) : ?> <?php $link = $router->url('home'); $l = $link; if ($currentPage > 2 ) $l = $link . '?page=' . ($currentPage - 1); ?> <a href="<?= $l ?>" class="btn btn-primary">« Page précédente </a> <?php endif ?> <?php if ($currentPage < $pages ): ?> <a href="<?= $link ?>?page=<?= $currentPage + 1 ?>" class="btn btn-primary"> Page suivante </a> <?php endif ?> </div>

L'image de l'erreur sur mon navigateur :

https://www.zupimages.net/viewer.php?id=23/15/sfjh.png

Pagination réorganisation

10 réponses