voila mon page d'inscription : qui contient un login et motpass
****inscrit .html
<!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>inscrit</title>
</head>
<body>
<form name="F2" action="insc.php" method="post">
<table width="385" align="center">
<tr>
<td>login</td>
<td><input type="text" name="log" /></td>
</tr>
<tr>
<td>Mot de passe</td>
<td><input type="password" name="pass1" /></td>
</tr>
<tr>
<td>Confirmer votre Mot de passe</td>
<td><input type="password" name="pass2" /></td>
</tr>
<td align="center" colspan="2"><input type="submit" value="connecter" name="ok" /></td>
</tr>
</table>
</form>
</body>
</html>
*** insc.php
<?php
// récupération des variables
$log = $_POST['log'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];
require("connexion.php");
if (!empty($log) && !empty($pass1) && !empty($pass2))
{
if ( $pass1 != $pass2)
{ echo'<script language="javascript">
alert("check up your password")</script>';
/*echo"<script language=\"javascript\">";
echo"alert('your password please')";
echo"</script>"; */
header('location: inscrit.html'); // redirection
exit;
}
else
{
$sql = "INSERT INTO utilisateur(id, login, motpass) VALUES('','$log','$pass1')";
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
//echo' c bien ';
/* echo'<script language="javascript">
alert("good :p")</script>';*/
header('location: acceuil.html');
exit;
}
}
else
{//echo ' Remplire les champs ';
echo'<script language="javascript">
alert("check up your information please")</script>';
header('location: inscrit.html'); // redirection
exit;
}
?>
connexion.php
<?php
$con=mysql_connect("localhost","root","");
if ($con==false)
die ("impossible de connecter au serveur");
$b=mysql_select_db("bdpfe");
if ($b==false)
die ("aucune base est selectionner");
?>
et index.html // les membre déja créer un compte !!
<!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>index</title>
</head>
<body>
<form name="F1" action="connecter.php" method="post">
<table width="347" height="274" align="center">
<tr>
<td width="99" height="43">Login</td>
<td width="237"><h1>
<input type="text" name="log" />
</h1></td>
</tr>
<tr>
<td height="43">Pass Word</td>
<td> <input type="password" name="pass" /></td>
</tr>
<tr>
<td height="42" colspan="2" align="center"><a href="inscrit.html"> Create an account </a></td>
<tr>
<td height="134" colspan="2" align="center">
<input type="submit" value="Log In" name="ok" />
</a> </td>
</tr>
</table>
</form>
</body>
là j'ai créer une base donné avec les champs: id(auto increment, login(varchar 20),motpass(varchar 20) !!!
et apres il une page ajouter des info
<?php
require("ajout_info.php");
?>
<!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>edit_profil</title>
</head>
<body>
<center><strong><h2><font color="#FF0000">Do you want add information?</font></h2></strong></center>
<div align="center">
<form action="Test.html" method="post">
<p>Nom:
<input type="text" name="nom" />
</p>
<p> </p>
<div align="center">
<p>Prénom:
<input type="text" name="prenom" />
</p>
<p>
</p>
</div>
<center>
<p>Age:
<input type="text" name="age" />
</p>
</center>
<center>
<p>Sex:
<input type="radio" name="sex" value="M" />Male
<input type ="radio" name="sex" value="F"/>Femele<br/>
</p>
</center>
<input name="edit" type="submit" value="edit" />
</form>
<form action="Test.html" method="post">
<input name="edit" type="submit" value="skip" />
</form>
</body>
</html>
et ajout_info.php
<?php
require("connexion.php");
$n=$_POST['nom'];
$pr=$_POST['prenom'];
$age=$_POST['age'];
$sex=$_POST['sex'];
$today=date("d"."m"."y");
if ( !empty($n) && !empty($pr) && !empty($age))
{
$sql="INSERT INTO info (id,nom,prenom,age,sex,dateInscription) VALUES ('','$n','$pr','$age','$sex','$today')";
$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$data = mysql_fetch_array($req);
mysql_close();
}
?>
ici j'ai créer une nouvelle table (nom, prenom, age, sex, dateInscription)
alors comment écrir la requête sql pour que je puisse afficher les info ajouter pour chaque login s'il a voulu modifier son profil ????