Les derniers torrents
query('SELECT postHash FROM blog_posts_seo');
// On passe le nb d'enregistrements à $pages
$pages->set_total($stmt->rowCount());
$stmt = $db->query('SELECT postID,postHash,postTitle,postAuthor,postSlug,postDesc,postDate,postImage,postViews FROM blog_posts_seo ORDER BY postDate DESC '.$pages->get_limit());
while($row = $stmt->fetch()) {
echo '
';
echo '';
echo '
'.html($row['postTitle']).' ';
sscanf($row['postDate'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde);
echo '
';
echo ''.html($row['postAuthor']).' ';
$stmt2 = $db->prepare('
SELECT catTitle, catSlug FROM blog_cats, blog_post_cats
WHERE blog_cats.catID = blog_post_cats.catID AND blog_post_cats.postID = :postID');
$stmt2->bindValue(':postID', $row['postID'], PDO::PARAM_INT);
$stmt2->execute();
$catRow = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$links = array();
foreach ($catRow as $cat) {
$links[] = $cat['catTitle'];
}
echo ' '.html($chaine).' ';
echo '# ';
echo ' ';
echo '
';
echo '
'.nl2br(bbcode(html($chaine))).'
';
echo '
';
echo ' ';
}
}
catch(PDOException $e) {
echo $e->getMessage();
}
echo '
';
echo $pages->page_links();
echo '
';
?>