1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161
| <?php include('includes/sql.php');
if (isset($_SESSION['id'])) {
session_destroy();
header ('Location:index.php');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>YgoShare | Connexion / Inscription</title>
<meta charset="utf-8">
<meta name = "format-detection" content = "telephone=no" />
<link rel="stylesheet" href="http://yui.yahooapis.com/pure/0.6.0/pure-min.css">
<link rel="icon" href="images/favicon.ico">
<link rel="shortcut icon" href="images/favicon.ico" />
<link rel="stylesheet" href="css/contact-form.css">
<link rel="stylesheet" href="css/style.css">
<script src="js/jquery.js"></script>
<script src="js/jquery-migrate-1.1.1.js"></script>
<script src="js/jquery.easing.1.3.js"></script>
<script src="js/script.js"></script>
<script src="js/superfish.js"></script>
<script src="js/jquery.equalheights.js"></script>
<script src="js/jquery.mobilemenu.js"></script>
<script src="js/tmStickUp.js"></script>
<script src="js/TMForm.js"></script>
<script src="js/modal.js"></script>
<script src="js/jquery.ui.totop.js"></script>
<script>
$(window).load(function(){
$().UItoTop({ easingType: 'easeOutQuart' });
});
</script>
<!--[if lt IE 8]>
<div style=' clear: both; text-align:center; position: relative;'>
<a href="http://windows.microsoft.com/en-US/internet-explorer/products/ie/home?ocid=ie6_countdown_bannercode">
<img src="http://storage.ie6countdown.com/assets/100/images/banners/warning_bar_0000_us.jpg" border="0" height="42" width="820" alt="You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today." />
</a>
</div>
<![endif]-->
<!--[if lt IE 9]>
<script src="js/html5shiv.js"></script>
<link rel="stylesheet" media="screen" href="css/ie.css">
<![endif]-->
</head>
<body>
<div class="main">
<?php include('includes/header.php'); ?>
<!--=====================
Content
======================-->
<section id="content"><div class="ic">Page de connexion o/.</div>
<div class="container">
<div class="row">
<?php
if(isset($_POST['login'])) {
$pseudo = htmlspecialchars(stripcslashes($_POST['pseudo']));
$pass = md5(htmlspecialchars(stripcslashes($_POST['pass'])));
$query = $sql->prepare("SELECT * FROM users WHERE pseudo LIKE :pseudo AND pass LIKE :pass");
$query->execute(array(
':pass' => $pass,
':pseudo' => $pseudo
));
$rows = $query->rowCount();
if($rows == 1) {
while($req = $query->fetch()) {
$_SESSION['pseudo'] = $req['pseudo'];
$_SESSION['id'] = $req['id'];
$_SESSION['login'] = 0;
echo "<script type='text/javascript'>document.location.replace('index.php');</script>";
}
} else { echo "Ce couple pseudo/mot de passe n'est pas valable.";}
} elseif(isset($_POST['register'])) {
if ($_POST['pseudo'] != "") {
$pseudo = htmlspecialchars(stripcslashes($_POST['pseudo']));
if($_POST['pass'] != "") {
$pass = md5(htmlspecialchars(stripcslashes($_POST['pass'])));
if(filter_var($_POST['mail'], FILTER_VALIDATE_EMAIL)) {
$mail = htmlspecialchars(stripcslashes($_POST['mail']));
$query = $sql->prepare("SELECT * FROM users WHERE pseudo LIKE :pseudo OR mail LIKE :mail");
$query->execute(array(
":pseudo" => $pseudo,
":mail" => $mail
));
$rows = $query->rowCount();
$query3 = $sql->query("SELECT * FROM users");
while($req2 = $query3->fetch()) {
$id = $req2['id'];
$id++;
}
if($rows == 0) {
$date = date('Y-m-d');
$tquery = "INSERT INTO users (id, pseudo, pass, mail, rang, avatar, join) VALUES('', :pseudo, :pass, :mail, :rang, :avatar, :join)";
$query2 = $sql->prepare($tquery);
$array = array(
":pseudo" => $pseudo,
":pass" => $pass,
":mail" => $mail,
":rang" => "Membre",
":avatar" => "https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/256x256/User1.png",
":join" => $date
);
$query2->execute($array);
echo "<pre>";
print_r($array);
echo "</pre>";
$rows2 = $query2->rowCount();
echo "$rows2 ligne insérée.";
echo "<br />Enregistrement réussi ! Vous pouvez vous connecter <b><a href='login.php'>en cliquant ici.</a></b>";
} else {echo "<br />L'adresse email ou le pseudonyme est déjà utilisé, désolé ^^'";}
} else {echo "<br />Veuillez entrer une email valable !<br />";}
} else {echo "<br />Veuillez entrer un mot de passe !<br />";}
} else {echo "<br />Veuillez entrer un pseudonyme !<br />";}
} else {
?>
<div class="grid_5">
<h4>Se connecter</h4>
<!-- Formulaires -->
<form method="post" class="pure-form">
<input type="text" name="pseudo" placeholder="Pseudonyme" value="" style="margin-right:15px;" />
<input type="password" name="pass" placeholder="Mot de passe" value="" style="margin-right:15px;" />
<button type="submit" class="pure-button pure-button-primary" style="margin-top:15px;display:block;margin-left:25%" name="login">Se connecter</button>
</form>
</div>
<div class="grid_6 preffix_1">
<h4>S'inscrire</h4>
<form method="post" class="pure-form pure-form-aligned">
<div class="pure-control-group">
<label for="name">Pseudonyme</label>
<input id="name" type="text" placeholder="Pseudonyme" name="pseudo">
</div>
<div class="pure-control-group">
<label for="name">Mot de passe</label>
<input id="name" type="password" placeholder="Mot de passe" name="pass">
</div>
<div class="pure-control-group">
<label for="name">Adresse mail</label>
<input id="name" type="text" placeholder="Email" name="mail">
</div>
<div class="pure-controls">
<button type="submit" class="pure-button pure-button-primary" name="register">S'inscrire !</button>
</div>
</form>
</div>
<?php } ?>
</div>
</div>
</section>
<?php include('includes/footer.php'); ?>
<a href="#" id="toTop" class="fa fa-chevron-up"></a>
</div>
</body>
</html> |
Partager