1 2 3 4 5 6 7 8 9 10 11 12 13 14
| $sql = "SELECT id As Id , idrubrique As idRubrique , titre As Titre , texte_court As Texte , date_poste As Date
FROM billets ";
$sql .= " WHERE idrubrique = :idrubrique ";
$sql .= " ORDER BY :OrderBy ";
$sql .= " :OrderTri ";
$sql .= " LIMIT :LimitStart , :LimitEnd";
$Stat = parent::$pConnection->prepare($sql);
$Stat->bindValue(':idrubrique', $this->pRubrique->Id );
$Stat->bindValue(':OrderBy', $OrderCol );
$Stat->bindValue(':OrderTri', $OrderTri );
$Stat->bindValue(':LimitStart', $LimitStart, PDO::PARAM_INT );
$Stat->bindValue(':LimitEnd', $LimitEnd, PDO::PARAM_INT ); |