[Demande] Se Connecter sur le site !
Bonjour à tous voila , je poste encore pour apprendre.
J'ai crée un formulaire d'enregistrement .
Maintenant j'aimerai me logguer :
Toutes mes page public commence : <?php session_start(); ?>
SQL
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| CREATE TABLE `Enregistrer` (
`ID` bigint(50) unsigned NOT NULL auto_increment COMMENT 'Identifier',
`Login` varchar(32) NOT NULL default '',
`Password` varchar(40) NOT NULL default '',
`Niveau` tinyint(5) unsigned NOT NULL default '1',
`Email` VARCHAR (50) not null,
`Joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
`Nom` varchar(32) NOT NULL default '',
`Pseudo` varchar(40) NOT NULL default 'Pseudos',
`Steamid` varchar(32) NOT NULL default 'Privee',
`Skype` varchar(32) NOT NULL default 'Privee',
`Micro` varchar(32) NOT NULL default 'Non',
`Autre` varchar(255) NOT NULL default 'Pseudos',
PRIMARY KEY (`id`),
KEY `idx_Niveau` (`Niveau`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Gestion Compte'; |
inscription.php
Code:
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
| <?php include ('./includes/vierge.php'); ?>
<div id="Corps">
<div class="element_Corps">
<FORM Method="POST" Action="inscription2.php">
Login : <br />
<INPUT type="text" size=20 name="login"> <br />
Password : <br />
<INPUT type="password" size=20 name="Password"> <br />
Email : <br />
<INPUT type="text" size=20 name="Email"> <br />
Nom : <br />
<INPUT type="text" size=20 name="Nom"> <br />
Pseudo : <br />
<INPUT type="text" size=20 name="Pseudo"> <br />
Steamid : <br />
<INPUT type="text" size=20 name="Steamid"> <br />
Skype : <br />
<INPUT type="text" size=20 name="Skype"> <br />
Micro : <br />
<INPUT type="text" size=20 name="Micro"> <br />
Autre : <br />
<INPUT type="text" size=20 name="Autre"> <br />
<INPUT type=submit value=Envoyer> <br />
</div> |
Inscription2.php :
Code:
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
|
<?php
include ('config.php');
?>
<div id="corps">
<?php
function asinject($hstack) {
$chars = array();
$chars[] = '"';
$chars[] = "'";
$chars[] = ";";
$chars[] = "\\";
$chars[] = "//";
$chars[] = "#";
$chars[] = "--";
$chars[] = "/*";
$injectcount = 0;
foreach($chars as $char) {
if(strpos($hstack, $char) != false) {
$injectcount++;
}
}
if($injectcount != 0) {
return true;
} else {
return false;
}
}
if(asinject($_POST['Password']) or asinject($_POST['nom'])) {
// rajouter un or pour tous les champs
die('mauvais caractère');
}
// reste du code ici
$Login = $_POST["login"];
$Password = md5($_POST["Password"]);
$Niveau = $_POST["Niveau"];
$Email = $_POST["Email"];
$Joindate = $_POST["Joindate"];
$Nom = $_POST["Nom"];
$Pseudo = $_POST["Pseudo"];
$Steamid = $_POST["Steamid"];
$Skype = $_POST["Skype"];
$Micro = $_POST["Micro"];
$Autre = $_POST["Autre"];
$requete ="INSERT INTO Enregistrer (Login,Password,Niveau,Email,Joindate,Nom,Pseudo,steamid,Skype,Micro,Autre) VALUES('$Login',MD5('$Password'),'Niveau','$Email','$Joindate','$Nom','$Pseudo','$steamid','$Skype','$Micro','$Autre')";
mysql_query($requete);
?> |
---------------------------------
Droite.php :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| <div id="Droite">
<div class="element_Droite">
<img src="images/Hdroite.jpg"> <br />
Login : <br />
<input type="text" name="login"> <br />
Password : <br />
<input type="password" name="password"> <br />
<form method="post" action="verifLogin.php">
<input type="submit" name="submit" value="login"><br />
<a href="./inscription.php">Inscription</a> <br />
</div>
<img src="images/Bgauche.jpg"> |