Untitled

<!DOCTYPE html>
<?php include("./includes/mysql.php"); ?>
<html lang="fr">
	<head><meta charset="utf-8" />
	<SCRIPT LANGUAGE="JavaScript">
</script>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">

        <title>Jordan - MAIL LISTE</title>


        <link href="css/bootstrap.min.css" rel="stylesheet">
        <link href="css/font-awesome.min.css" rel="stylesheet">
        <link href="css/owl.carousel.css" rel="stylesheet">
        <link href="css/magnific-popup.css" rel="stylesheet">
        <link href="css/animate.min.css" rel="stylesheet">
        <link href="css/style.css" rel="stylesheet">
        <link href="css/responsive.css" rel="stylesheet">


	</head>
    <body>

		<div class="demo_panel_box">
			<div class="color_panel_box">
				<div class="spiner_button slide_in_out"><i class="fa fa-cog fa-spin"></i></div>
				<span class="red_color"></span>
				<span class="blue_color"></span>
				<span class="yellow_color"></span>
				<span class="purple_color"></span>
				<span class="pink_color"></span>
				<span class="green_color"></span>
			</div>
		</div>

        <div id="preloader">
            <div id="status">&nbsp;</div>
		</div>


        <div id="home" class="intro-section">


            <header class="navbar custom-navbar">
                <div class="container">
                    <div class="row">
                        <div class="col-md-3 col-sm-3 col-xs-12">
                            <div class="logo">
								<div class="navbar-header">
                                    <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                                        <span class="sr-only">Toggle navigation</span>
                                        <span class="icon-bar"></span>
                                        <span class="icon-bar"></span>
                                        <span class="icon-bar"></span>
									</button>
								</div>
                                <a href="#home">JordanFolio</a> <!--== logo ==-->
							</div>
						</div>

                        <div class="col-md-9 col-sm-9 col-xs-12">
							<nav class="main-menu">
								<div class="navbar-collapse collapse">
									<ul class="nav navbar-nav"> <!--== manin menu ==-->
										<li class="smooth-scroll"><a class="theme-color" href="../index.php">Accueil</a></li>
										<li class="smooth-scroll"><a class="theme-color" href="index.php">Admin</a></li>
										<li class="active smooth-scroll"><a class="theme-color" href="mail.php">Mails</a></li>
										<li class="smooth-scroll"><a class="theme-color" href="pics.php">Add Pics</a></li>
										<li class="smooth-scroll"><a class="theme-color" href="add.php">Add Galerie</a></li>
									</ul>
								</div>
							</nav>
						</div>
                    </div>
				</div>
			</header>
				<body>
			<section id="Admin" class="section-padding">
				<div class="container">
					<div class="row">
						<div class="col-md-8">
							<div class="section-title">
								<h2><span class="theme-color">Boite de Réception</span> Administraion</h2>
							</div>
						</div>
					</div>
				</div>
			</section>
				<section id="Messages Reçus" class="section-padding">
					<div class="container">
						<div class="row">
							<div class="col-md-8">
									<table cellspacing="4" cellpadding="3px" rules="rows"
									style="border:solid 1px black; border-collapse:3px; font-family:verdana; font-size:11px;">
									<CAPTION>liste des Messages :</CAPTION>
									<tr style="background-color:#B2C89F; text-align:center; border-top:solid 2px black;">
									<th style="width:250px"; height="20"><center> E-MAIL :</center></th>
									<th style="width:100px"; height="20"><center> Motifs :</center></th>
									<th style="width:300px;"><center> Message : </center></th>
									<th style="width:100px"; height="20"><center> Date de réception :</center></th>
									</tr>
							</div>
						</div>
					</div>
				</section>

			<section id="portfolio" class="section-padding">
					<div class="container">
						<div class="row">
							<div class="col-md-12">
								<?php
									try
									{
										$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
										$bdd = new PDO('mysql:host=localhost;dbname=DBNAMEHERE', 'NAME', 'MDP', $pdo_options);

									    // On recupere tout le contenu de la table Client
										$reponse = $bdd->query('SELECT id, email, msg_subject, message, date_reception FROM contact');

										// On affiche le resultat
										while ($donnees = $reponse->fetch())
											{
												//On affiche l'id et le nom du client en cours
												echo "</tr>";
												echo "<td style='background-color:#E9EFE3; height:40px; padding-left:10px; color:red;'><center> $donnees[email] </br></center></td>";
												echo "<td style='background-color:#D9A9A9; height:40px; padding-left:10px;'><center> $donnees[msg_subject] </br></center></td>";
												echo "<td style='height:40px; padding-left:10px;'> $donnees[message] </br></td>";
												echo "<td style='background-color:#D9A9A9; height:40px; padding-left:10px;'><center> $donnees[date_reception] </br></td>";
												echo "</tr>";


											}
									$reponse->closeCursor();
									}
									catch(Exception $e)
										{
										die('Erreur : '.$e->getMessage());
										}
							?>
								</div>
							</div>
				</div>
			</section>


        <script src="js/jquery-2.1.4.min.js"></script>
        <script src="js/plugins.js"></script>
        <script src="js/magnific-popup-options.js"></script>
        <script src="js/validator.min.js"></script>
        <script src="js/particles.min.js"></script>
        <script src="js/app.js"></script>
        <script src="js/wow.min.js"></script>
        <script src="js/main.js"></script>
    </body>
</html>