<?php
	include("php/connexion_inc.php");
	include("php/form_date.php");
?>
<!DOCTYPE html>
<html lang="fr">
	<head>
		<meta charset="utf-8" />
		<meta name="description" content="" />
		<meta name="author" content="Édouard Lumet" />
		<meta name="viewport" content="width=799" />
		<link rel="stylesheet" href="css/reset.css" />
		<link rel="stylesheet" href="css/style.css" />
		<link rel="stylesheet" href="css/categorie.css" />
		<title>TheRedUnicorn | News</title>
	</head>

	<body>
	<div id="contBody">
		<header>
			<?php include("php/header.php"); ?>
		</header>

		<main>
			<h2>- News, actualités et mises à jour -
			<h3>Restez connecté et informé à propos de TheRedUnicorn</h3>
			<?php
			$sql_articles="SELECT * FROM Article ORDER BY dateCrea DESC";
			$ret_articles=$connexion->query($sql_articles);
			$res_articles=$ret_articles->fetchAll(PDO::FETCH_ASSOC);
			echo "<ul>";
			foreach($res_articles as $valeur) {
				echo "<li><article>";
				echo "<h4><a href=\"php/article.php?id=". $valeur["id"] ."\">". $valeur["nom"] ."</a></h4>";
				echo "<p class=\"description\">". $valeur["description"] ."</p>";
				echo "<p class=\"date\">Dernière modification le ". format_timestamp($valeur["dateModif"]) ."</p>";
				echo "</article></li>";
			}
			echo "</ul>";
			?>
		</main>

		<footer>
			<?php include("html/footer.html"); ?>
		</footer>
	</div>
	</body>
</html>
