j'ai vu des sujet sur MD5 . mais j'arrive pas a l'utiliser.
ma table :
--
-- Structure de la table `members`
--
CREATE TABLE IF NOT EXISTS `members` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`username` varchar(65) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(65) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
INSERT INTO `members` (`id`, `username`, `password`) VALUES
(1, 'msi79', 'cool75sool')
);
inscription.php
<?php
$date = date("d-m-Y");
$heure = date("H:i");
echo 'Nous sommes le '.$date.' et il est '.$heure;
?>
<?php
if (isset($_POST["valider"])) {
/*IMPORTANT*/
include("connection.php");
/*faut securiser*/
foreach($_POST as $k => $v){
$v=mysql_real_escape_string(strip_tags($v));
$_POST[$k]=$v;
}
/*faut securiser*/
foreach($_GET as $k => $v){
$v=mysql_real_escape_string(strip_tags($v));
$_POST[$k]=$v;
}
$username=trim($_POST["username"]);
$password=trim($_POST["password"]);
// on regarde si l'url existe déjà
// on regarde si l'url existe déjà
$sql = "SELECT username FROM members WHERE username='$username'";
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
// on compte le nombre de résultats
$res = mysql_num_rows($req);
if($res!=0) // l'url existe déjà, on affiche un message d'erreur
{
$msg = 'Désolé, mais ce nom existe déjà dans notre base.';
echo '<script>alert(\' '.$msg.' \');</script>' ;
}
else // L'url n'existe pas, on insère les informations du formulaire dans la table
{
$sql = "INSERT INTO members(id,username,password) VALUES('','".$username."','".$password."')";
// on insère les informations du formulaire dans la table
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$msg = 'Les informations sur l inscription ont été ajoutées dans la base de données.</br>';
///echo '<font color="red">'.$msg.'</font>';
echo '<script>alert(\' '.$msg.' \');</script>';
session_start();
$_SESSION['username'] = $_POST['username'];
header('Location: login_success.php');
exit();
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans titre</title>
<style type="text/css">
<!--
.Style1 { color: #FFFFFF;
font-weight: bold;
}
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<p> </p>
<p> </p>
<p> </p>
<table width="524" border="0" align="center" bgcolor="#FF00FF">
<tr>
<td colspan="2"><div align="center" class="Style1">
<h1>Inscription à l'espace membre :</h1>
</div></td>
</tr>
<tr>
<td width="228"><span class="Style1">Login : </span></td>
<td width="286"><input type="text" name="username" value="" /></td>
</tr>
<tr>
<td><span class="Style1">Mot de passe : </span></td>
<td><input type="password" name="password" value="" /></td>
</tr>
<tr>
<td colspan="2"><table width="83" border="0" align="center">
<tr>
<td width="77"><input type="submit" name="valider" value="Inscription" /></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html><style type="text/css">
<!--
.Style8 {
color: #FF00FF;
font-style: italic;
}
.Style11 {color: #FFFFFF; font-style: italic; }
-->
</style>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#0A5B79">
<tr>
<td colspan="3"><table width="512" border="0" align="center">
<tr>
<td width="395"><h1 align="center" class="Style8">Identifiez-vouz !! </h1></td>
<td width="101"><img src="images/logo3.jpg" alt="dfghj" width="100" height="70" /></td>
</tr>
</table></td>
</tr>
<tr>
<td width="69"><span class="Style11">Username</span></td>
<td width="7"><span class="Style11">:</span></td>
<td width="422"><input name="myusername" type="text" id="myusername" ></td>
</tr>
<tr>
<td><span class="Style11">Password</span></td>
<td><span class="Style11">:</span></td>
<td><input name="mypassword" type="text" id="mypassword" ></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input name="Submit" type="submit" value="Login">
<table width="78" border="0" align="right">
<tr>
<td><a href="inscription2.php" class="Style11">Inscription!!</a></td>
</tr>
</table></td>
</tr>
</table>
</td>
</form>
</tr>
</table><?php
session_start();
session_unset();
session_destroy();
header('Location: index.php');
exit();
?>
