1 files changed, 96 insertions, 0 deletions
diff --git a/Html/archives.php b/Html/archives.php
new file mode 100644
index 0000000..0347087
--- /dev/null
+++ b/Html/archives.php
@@ -0,0 +1,96 @@
+<?php
+require_once('includes/config.php');
+
+$pagetitle= 'Archives';
+
+include_once('includes/header.php');
+?>
+<body>
+<div id="container">
+		
+		<?php
+		include_once('includes/header-logo.php');
+		include_once('includes/nav.php');
+		?>
+		
+    	<div id="body">
+		<div id="content">
+
+		<?php
+		include_once('includes/ariane.php');
+		?>
+
+		<br />
+
+		                        <?php
+                                try {
+
+                                        //collect month and year data
+                                        $month = html($_GET['month']);
+                                        $year = html($_GET['year']);
+
+                                        //set from and to dates
+                                        $from = date('Y-m-01 00:00:00', strtotime("$year-$month"));
+                                        $to = date('Y-m-31 23:59:59', strtotime("$year-$month"));
+
+
+                                        $pages = new Paginator('10','p');
+
+                                        $stmt = $db->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 '<h2>Archives : '.$month.'-'.$year.'</h2><br />';
+
+                                        while($row = $stmt->fetch()){
+							echo '<fieldset>';
+                                                        echo '<span style="font-weight: bold; font-size: 12pt;"><a style="text-decoration: none;" href="'.html($row['postSlug']).'">'.html($row['postTitle']).'</a></span>';
+                                                        echo '<br /><span style="font-size: 10pt;">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[] = "<a href='c-".html($cat['catSlug'])."'>".html($cat['catTitle'])."</a>";
+                                                                }
+                                                                echo implode(", ", $links);
+							echo '</span></fieldset>';
+                                        }
+					echo '<br /><br />';
+
+                                        echo $pages->page_links("a-$month-$year&");
+
+                                } catch(PDOException $e) {
+                                    echo $e->getMessage();
+                                }
+                        ?>
+				        </div>
+        
+	<?php include_once('sidebar.php'); ?>
+        
+    	<div class="clear"></div>
+    </div>
+</div>
+
+<div id="footer">
+	<?php include_once('includes/footer.php'); ?>
+</div>
+
+</body>
+</html>