Accueil du forum » PHP » Espace-Membre : pb connexion
<center><b>CONNEXION</b></center>
<?php
if(isset($pseudo) && !empty($pseudo) && isset($mdp) && !empty($mdp))
{
$pseudo=addslashes(htmlspecialchars($_POST[pseudo]));
$mdp=addslashes(htmlspecialchars($_POST[mdp]));
connecter();
$query="SELECT * FROM `membres` WHERE `pseudo` LIKE '$pseudo' and `mdp` LIKE '$mdp'";
$result=@mysql_query($query);
$num=@mysql_num_rows($result);
$row=@mysql_fetch_row($result);
if($num==0)
{
echo "<br><br><center><font color='#990000'>Erreur ce pseudo (et/ou mot de passe) est incorrect!</font></center><br>";
}
else
{
//connexion Ètablie
$mail = $row[3];
$meme = $row;
//-----------------VERSION 1.1-----------------
$_SESSION['pseudo']=$pseudo;
$_SESSION['mail']=$mail;
$_SESSION['meme']=$meme;
//---------------------------------------------
//session_register("pseudo"); VERSION 1.0 nÈcessitÈ d'avoir register_global=on
//session_register("mail");
//session_register("meme");
echo "Connexion Ètablie...";
echo "<script language='javascript'>document.location='espace_membre.php?page=3'</script>";
}
}
?>
<form action="espace_membre.php?page=1" method="post">
<table align="center" class="texte">
<tr><td>Pseudo: </td><tD><input type="text" name="pseudo"></tD></tr>
<tr><td>Mot de passe: </td><tD><input type="password" name="mdp"></tD></tr>
<tr><tD colspan="2" align="center"><input type="submit" value="Envoyer"></tD></tr>
</table>
</form>
<div align="center"><a href="espace_membre.php?page=6"><font size="1">Mot de Passe oubliÈ ?</font></a></div>
<div align="center"><a href="espace_membre.php?page=2"><font size="1">S'inscrire</font></a></div>
________________
toutsi83
________________
Anything that can go wrong will go wrong (Murphy)
Statut: Modérateur
<?php
if(!isset($_SESSION['pseudo']))
{ /// VERSION 1.0 : if(!session_is_registered("pseudo"))-> nÈcessitÈ REGISTER_GLOBALS ‡ ON
echo "<script language='javascript'>document.location='espace_membre.php?page=1'</script>";
}
else
{
if(isset($_POST['email']) && !empty($_POST['email']) && isset($_POST['mdp']) && !empty($_POST['mdp']))
{
connecter();
$mdp=addslashes(htmlspecialchars($_POST['mdp']));
$email=addslashes(htmlspecialchars($_POST['email']));
$url_site=addslashes(htmlspecialchars($_POST['url_site']));
$age=addslashes(htmlspecialchars($_POST['age']));
$sexe=addslashes(htmlspecialchars($_POST['sexe']));
$infos_comp=addslashes(htmlspecialchars($_POST['infos_comp']));
$query="UPDATE `membres` set `mdp`='$mdp',`mail`='$email',`url_site`='$url_site',`age`='$age',`sexe`='$sexe',`infos_comp`='$infos_comp' WHERE `pseudo` LIKE '$pseudo'";
$result=@mysql_query($query);
if(!empty($avatar))
{
$ext = ".jpg";
$nom_image=($meme[0].$ext);
$chemin = "images/".$nom_image;
move_uploaded_file($HTTP_POST_FILES["avatar"]["tmp_name"],$chemin);
}
echo "<script language='javascript'>document.location='espace_membre.php?page=3'</script>";
}else
{
connecter();
$query="SELECT * FROM `membres` WHERE `pseudo` LIKE '$pseudo'";
$result=@mysql_query($query);
$row=@mysql_fetch_row($result);
if($row){
echo "<center><b>Infos perso:</b></center>";
echo "<p>";
echo "<form action='espace_membre.php?page=5' method='post' enctype=multipart/form-data><table align='center' class='texte'>";
echo "<tr><td>Pseudo: </td><td><input type='text' name='pseudo' value='.stripslashes($_SESSION['pseudo']).' disabled></td></tr>";
echo "<tr><td>Mot de passe: </td><td><input type='password' name='mdp' value='.stripslashes($row[2]).'></td></tr>";
echo "<tr><td>Adresse e-mail: </td><td><input type='text' name='email' value='.stripslashes($row[3]).'></td></tr>";
echo "<tr><td>Url de votre site: </td><tD><input type='text' name='url_site' value='.stripslashes($row[4]).'></tD></tr>";
echo "<tr><td><tr><td>Age: </td><td>";
echo "<select name='age'><option value='- selected'>'.stripslashes($row[5]).'</option>";
for($i=0;$i<100;$i++) echo "<option value='$i'>$i</option>";
echo "</select> ans</td></tr>";
echo "<tr><td>Sexe: </td><td> ";
echo "<input type='radio' name='sexe' value='f'>F ";
echo "<input type='radio' name='sexe' value='m'>M";
echo "</tD></tr>";
echo "<tr><td valign='top'>Informations complÈmentaires: </td><td>";
echo "<textarea name='infos_comp' rows='4' cols='20'>".stripslashes($row[7])."</textarea>";
echo "</td></tr>";
echo "<tr><td>Avatar (extension .jpeg seulement)*: </td><td>";
echo "<input type='file' name='avatar'>";
echo "</td></tr>";
echo "<tr><td colspan='2' align='center'><input type='submit' value='Modifier'></td></tr>";
echo "<tr><td colspan='2' align='center'><a href='espace_membre.php?page=3'><font size='1'>retour</font></a></td></tr>";
echo "</table></form>";
echo "<center><font size='1'>Les changements seront pris en compte lors de votre prochaine connection</font></center>";
echo "</p>";
}
else{
echo "<script language='javascript'>document.location='espace_membre.php?page=3'</script>";
}
}
}
?>
<?php
if(!isset($_SESSION['pseudo']))
{
echo "<script language='javascript'>document.location='espace_membre.php?page=1'</script>";
}
else
{
?>
Bienvenue <b><? echo stripslashes($_SESSION['pseudo']);?></b>
<br>
<br>
Mon identifiant de membre est : <?php echo stripslashes($_SESSION['meme'][0]); ?><br>
Mon adresse e-mail: <?php echo stripslashes($_SESSION['mail']); ?><br>
Mon site web: <?php echo stripslashes($_SESSION['meme'][4]); ?><br>
Mon ‚ge: <?php echo stripslashes($_SESSION['meme'][5]); ?><br>
Mon sexe: <?php echo stripslashes($_SESSION['meme'][6]); ?><br>
Infos complÈtaires: <?php echo stripslashes($_SESSION['meme'][7]); ?><br>
Mon avatar:<br> <?php echo "<img src='images/".($_SESSION['meme'][0]).".jpg />'"; ?><br>
<br>
<br>
<a href="espace_membre.php?page=5">Modifier mes informations</a><br>
<a href="espace_membre.php?page=4">Se dÈconnecter</a>
<?
}
?>
<?php
//////FONCTIONS//////
function connecter()
{
//////////A MODIFIER/////////////////////////////////////
$host="localhost";//nom de l'hÙte
$user="root";//nom d'utilisateur
$password="root";//mot de passe de connection ‡ la base de donnÈes
$bdd="espace_membre";//nom de votre base de donnÈes
/////////////////////////////////////////////////////////
$connect=@mysql_connect($host,$user,$password);
if(!$connect)
{
echo "Erreur de connection ‡ la base de donnÈes";
exit;
}
$select=@mysql_select_db($bdd);
if(!$select)
{
echo "Erreur de connection ‡ la base de donnÈes";
exit;
}
}
?>
________________
toutsi83
connecter();
$query="SELECT * FROM `membres` WHERE `pseudo` LIKE '$pseudo'";
$result=@mysql_query($query);
$row=@mysql_fetch_row($result);
________________
Anything that can go wrong will go wrong (Murphy)
Statut: Modérateur
________________
toutsi83
________________
Anything that can go wrong will go wrong (Murphy)
Statut: Modérateur
________________
Fondateur de Net-Pratique,
Ancien webmaster.
Statut: Administrateur/Webmaster
________________
Anything that can go wrong will go wrong (Murphy)
Statut: Modérateur
<!-- Session_start --><div align="left">Bonjour <span class="pseudo"><?php echo stripslashes($_SESSION['pseudo']); ?></span> ! Vous pouvez modifier vos infos !</div><!-- Fin Session_start -->
= affichage sous certaines conditions, avec le else <form> = page vide.
________________
toutsi83
________________
Anything that can go wrong will go wrong (Murphy)
Statut: Modérateur
________________
root
- Les conditions générales d'utilisation du site