<?php
$idco = $_GET['idco'];
include "fonctions.php";
majConnexion($bdd, $idco);
?>
<!DOCTYPE html>
<!--[if lt IE 8 ]><html class="ie ie7" lang="en"> <![endif]-->
<!--[if IE 8 ]><html class="ie ie8" lang="en"> <![endif]-->
<!--[if (gte IE 8)|!(IE)]><!--><html lang="fr"> <!--<![endif]-->
<head>
<!--- Basic Page Needs
================================================== -->
<meta charset="utf-8">
<title>Lions Club</title>
<meta name="description" content="">
<meta name="author" content="">
<!-- Mobile Specific Metas
================================================== -->
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<!-- CSS
================================================== -->
<link rel="stylesheet" href="css/base.css">
<link rel="stylesheet" href="css/layout.css">
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
function testConnexion($bdd, $mail, $mdp)
{
try {
$stmt = $bdd->prepare("SELECT Member_ID FROM Member WHERE (Member_EMail='{$mail}' AND Member_Password ='******');", array(PDO::ATTR_CURSOR, PDO::CURSOR_SCROLL));
$stmt->execute(array());
$res = $stmt->fetchAll();
/* Si il n'y a pas de résultat, message d'erreur */
if (count($res) == 0) {
/* On réaffiche la page avec un message d'erreur */
echo '<!DOCTYPE html>
<!--[if lt IE 8 ]><html class="ie ie7" lang="en"> <![endif]-->
<!--[if IE 8 ]><html class="ie ie8" lang="en"> <![endif]-->
<!--[if (gte IE 8)|!(IE)]><!--><html lang="fr"> <!--<![endif]-->
<head>
<!--- Basic Page Needs
================================================== -->
<meta charset="utf-8">
<title>Lions Club</title>
<meta name="description" content="">
<meta name="author" content="">
<!-- Mobile Specific Metas
================================================== -->
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<!-- CSS
================================================== -->
<link rel="stylesheet" href="css/base.css">
<link rel="stylesheet" href="css/layout.css">
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<!-- Favicons
================================================== -->
<link rel="shortcut icon" href="logo.png" >
</head>
<body data-spy="scroll" data-target="#nav-wrap">
<!-- Header
================================================== -->';
afficheHeader();
echo '<!-- Header End -->
<!-- Inscription Section
================================================== -->
<div class="row">
<div class="col g-7" style="top: 80px">
<div class="row section-head">
<div class="col full" >
<h2 style="color : #11ABB0;"> S\'inscrire</h2>
</div>
</div>
<!-- form -->
<form name="contactForm" id="contactForm" method="post" action="verif1.php">
<fieldset >
<div>
<label for="contactEmail">Adresse email <span class="required">*</span></label>
<input name="email" type="mail" id="mail" size="35" value="" style = "padding: 18px 18px; margin : 0 0 24px 0; color : #738182; background : #CFD4D5; border : 0" />
</div>
<div>
<label for="contactSubject">Mot de passe<span class="required">*</span></label>
<input name="mdp" type="password" id="mdp" size="35" value="" />
</div>
<div>
<label for="contactSubject">Confirmation du mot de passe<span class="required">*</span></label>
<input name="cmdp" type="password" id="cmdp" size="35" value="" />
</div>
<div>
<input type="submit" name="v1" value="Valider">
</div>
</fieldset>
</form>
<!-- Form End -->
</div>
<aside class="col g-5" style="top: 80px">
<div class="row section-head">
<div class="col full" >
<h2 style="color : #11ABB0;"> Se connecter</h2>
</div>
</div>
<h7 style="color : #FF0000;"> ERREUR ! MAIL OU MOT DE PASSE INCORRECT</h7>
<!-- form -->
<form name="contactForm" id="contactForm" method="post" action="verifConnexion.php" >
<fieldset >
<div>
<label for="mail">Adresse e-mail <span class="required">*</span></label>
<input name="mail" type="mail" id="mail" size="35" value="" style = "padding: 18px 18px; margin : 0 0 24px 0; color : #738182; background : #CFD4D5; border : 0" />
</div>
<div>
<label for="mdp">Mot de passe<span class="required">*</span></label>
<input name="mdp" type="password" id="mdp" size="35" value="" />
</div>
<div>
<a href="perteMdp1.php" title="perte de mot de passe">Si vous avez perdu votre mot de passe, cliquez ici</a>
</div>
<br>
<div>
<button name="v1" id="v1" class="submit">Valider</button>
</div>
</fieldset>
</form>
<!-- Form End -->
<!-- contact-warning -->
<div id="message-warning"></div>
<!-- contact-success -->
<div id="message-success">
<i class="icon-ok" ></i><br />
</div>
</aside>
</div>
</section> <!-- Contact Section End-->
<!-- footer
================================================== -->
<br>';
afficheFooter();
echo '
<!-- Footer End-->
<!-- Java Script
================================================== -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script>window.jQuery || document.write(\'<script src="js/jquery-1.10.2.min.js"><\\/script>\')</script>
<script type="text/javascript" src="js/jquery-migrate-1.2.1.min.js"></script>
<script src="js/scrollspy.js"></script>
<script src="js/jquery.flexslider.js"></script>
<script src="js/jquery.reveal.js"></script>
<script src="http://maps.google.com/maps/api/js?sensor=true" type="text/javascript"></script>
<script src="js/gmaps.js"></script>
<script src="js/init.js"></script>
<script src="js/smoothscrolling.js"></script>
</body>
</html>';
} else {
/* Si il y a un résultat, connexion + mise à jour de la date de dernière connexion */
foreach ($res as $ligne) {
$memberID = $ligne["Member_ID"];
/* On regarde si sa connexion est encore active */
$cpt = testConnexionMembre($bdd, $memberID);
// S'il n'y a pas de connexion, on en crée une
if ($cpt == 0) {
//Création de l'id de connexion
$chaine = "";
$c = "abcdefghijklmnpqrstuvwxy";
srand((double) microtime() * 1000000);
for ($i = 0; $i < 70; $i++) {
$chaine .= $c[rand() % strlen($c)];
}
list($annee, $mois, $day, $heure, $min, $sec) = dateAuj($bdd);
$idco = $chaine . $day . $mois . $annee . $heure . $min . $sec;
//Ajout d'une nouvelle connexion
insertConnexion($bdd, $memberID, $idco);
} else {
// Si une connexion est déjà active, on l'update
$idco = getIdco($bdd, $memberID);
majConnexion($bdd, $idco);
}
}
/* On affiche un message pour dire que la connexion est OK */
echo '<!DOCTYPE html>
<!--[if lt IE 8 ]><html class="ie ie7" lang="en"> <![endif]-->
<!--[if IE 8 ]><html class="ie ie8" lang="en"> <![endif]-->
<!--[if (gte IE 8)|!(IE)]><!--><html lang="fr"> <!--<![endif]-->
<head>
<!--- Basic Page Needs
================================================== -->
<meta charset="utf-8">
<title>Lions Club</title>
<meta name="description" content="">
<meta name="author" content="">
<!-- Mobile Specific Metas
================================================== -->
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<!-- CSS
================================================== -->
<link rel="stylesheet" href="css/base.css">
<link rel="stylesheet" href="css/layout.css">
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
<!-- Favicons
================================================== -->
<link rel="shortcut icon" href="logo.png" >
</head>
<body data-spy="scroll" data-target="#nav-wrap">
<!-- Header
================================================== -->';
echo ' <header class="mobile">';
echo '<div class="row"';
echo ' <div class="col full">
<div class="logo">';
print " <a href=\"http://localhost/lion/Lion/php/homeC.php?idco={$idco}\" style=\"top : 4px\"><img alt=\"\" src=\"images/logo.png\" style=\"height: 50px; width: 55px; top: 4px\"></a>";
echo '</div>
<nav id="nav-wrap" >
<a class="mobile-btn" href="#nav-wrap" title="Show navigation">Show navigation</a>
<a class="mobile-btn" href="#" title="Hide navigation">Hide navigation</a>
<ul id="nav" class="nav" style = "margin-left :76px">';
print " <li ><a href=\"http://localhost/lion/Lion/php/homeC.php?idco={$idco}\">Home</a></li>";
print " <li ><a href=\"http://localhost/lion/Lion/php/agendaC.php?idco={$idco}\">Agenda</a></li>";
print " <li ><a href=\"http://localhost/lion/Lion/php/infoC.php?idco={$idco}\">Info</a></li>";
print " <li ><a href=\"http://localhost/lion/Lion/php/contactC.php?idco={$idco}\">Contact</a></li>";
print " <li><a href=\"http://localhost/lion/Lion/php/panier.php?idco={$idco}\" > Panier</a></li>";
print " <li><a href=\"http://localhost/lion/Lion/php/moncompte.php?idco={$idco}\" > Mon compte</a></li>";
print " <li><a href=\"http://localhost/lion/Lion/php/deconnexion.php?idco={$idco}\" > Se déconnecter</a></li>";
echo ' </ul>
</nav>
</div>
</div>
</header>';
echo '<!-- Header End -->
<!-- Message Section
================================================== -->
<div class="row section-head">
<div class="col full">
<br></br>
<br></br>
<span><h2 style = "color :#70F861; margin : 65px; text-align : center"> Connexion réussie <br></br>
<center><FONT size="3.5pt " style = "color :#F0FFFF ;font-weight:normal">Vous pouvez désormais vous inscrire à des activités dans l\'onglet "Agenda" </center></FONT></h2><span>
<br></br>
<br></br>
<br></br>
</div>
<!-- Message Section End-->
<!-- footer
================================================== -->
';
afficheFooter();
echo '
<!-- Footer End-->
<!-- Java Script
================================================== -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script>window.jQuery || document.write(\'<script src="js/jquery-1.10.2.min.js"><\\/script>\')</script>
<script type="text/javascript" src="js/jquery-migrate-1.2.1.min.js"></script>
<script src="js/scrollspy.js"></script>
<script src="js/jquery.flexslider.js"></script>
<script src="js/jquery.reveal.js"></script>
<script src="http://maps.google.com/maps/api/js?sensor=true" type="text/javascript"></script>
<script src="js/gmaps.js"></script>
<script src="js/init.js"></script>
<script src="js/smoothscrolling.js"></script>
</body>
</html>';
}
} catch (PDOException $e) {
echo 'Connexion échouée : ' . $e->getMessage();
}
}
