+ + + +
+ + prepare('SELECT postID FROM blog_posts_seo WHERE postDate >= :from AND postDate <= :to'); + $stmt->execute(array( + ':from' => $from, + ':to' => $to + )); + + //pass number of records to + $pages->set_total($stmt->rowCount()); + + $stmt = $db->prepare('SELECT postID, postTitle, postSlug, postAuthor, postDesc, postDate FROM blog_posts_seo WHERE postDate >= :from AND postDate <= :to ORDER BY postID DESC '.$pages->get_limit()); + $stmt->execute(array( + ':from' => $from, + ':to' => $to + )); + + echo '

Archives : '.$month.'-'.$year.'

'; + + while($row = $stmt->fetch()){ + echo '

'; + echo ''.html($row['postTitle']).''; + echo '
Posté le '.date_fr('l j F Y à H:i:s', strtotime(html($row['postDate']))).' par '; + echo html($row['postAuthor']).' dans '; + + $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[] = "".html($cat['catTitle']).""; + } + echo implode(", ", $links); + echo '

'; + } + echo '

'; + + echo $pages->page_links("a-$month-$year&"); + + } catch(PDOException $e) { + echo $e->getMessage(); + } + ?> +