Créer un système de Connexion / Inscription en PHP

4Spartan8

<blockquote class="ipsQuote" data-ipsquote="" data-ipsquote-contentapp="forums" data-ipsquote-contentclass="forums_Topic" data-ipsquote-contentcommentid="17973" data-ipsquote-contentid="437" data-ipsquote-contenttype="forums" data-ipsquote-timestamp="1492538259" data-ipsquote-userid="1674" data-ipsquote-username="zougui">
<div class="ipsQuote_citation">
Le 18/04/2017 à 19:57, zougui a dit :
</div>
<div class="ipsQuote_contents">

bonjour,


pour moi cela ne marche pas meme avec le copier coller et en modifiant les identifiants pour se connecter a la base de donner quand je met le login et le mot de passe sa refresh la page mais sa ne fait rien et dans la base de donner il n'y ya ni dans login ni mot de passe d'ajouter




</div>
</blockquote>

Bonjour ! Je suis surpris que 3 ans après les messages sur ce tutoriel soient encore d'actualités, ça fait plaisir 

Malheureusement celui-ci est complètement dépassé et ne permet pas de créer un système correctement sécurisé puisque les fonctions de PHP ont évolué depuis pas mal de temps !


Tu peux toujours envoyer le code et activer les erreurs pour voir d'ou le problème peut venir, une fois cela fait n'hésite pas à les partager ici pour qu'on puisse jeter un coup d'oeil ! Bonne chance pour la suite

zougui

les erreurs sont déjà activées... le code


accueil.php

<pre class="ipsCode prettyprint lang-php prettyprinted">
<!DOCTYPE html>

<HTML>

</span><span class="tag">&lt;head&gt;</span><span class="pln">

	</span><span class="tag">&lt;meta</span><span class="pln"> </span><span class="atn">content</span><span class="pun">=</span><span class="atv">"prototype crystalcraft"</span><span class="tag">&gt;</span><span class="pln">
	</span><span class="tag">&lt;meta</span><span class="pln"> </span><span class="atn">charset</span><span class="pun">=</span><span class="atv">"utf-8"</span><span class="pln"> </span><span class="tag">/&gt;</span><span class="pln">
	</span><span class="tag">&lt;link</span><span class="pln"> </span><span class="atn">rel</span><span class="pun">=</span><span class="atv">"shortcut icon"</span><span class="pln"> </span><span class="atn">href</span><span class="pun">=</span><span class="atv">"img/icon 1.png"</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"image/x-icon"</span><span class="tag">/&gt;</span><span class="pln">
	</span><span class="tag">&lt;link</span><span class="pln"> </span><span class="atn">rel</span><span class="pun">=</span><span class="atv">"apple-touch-icon"</span><span class="pln"> </span><span class="atn">href</span><span class="pun">=</span><span class="atv">"img/icon 1.png"</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"image/x-icon"</span><span class="tag">/&gt;</span><span class="pln">
	</span><span class="tag">&lt;link</span><span class="pln"> </span><span class="atn">rel</span><span class="pun">=</span><span class="atv">"stylesheet"</span><span class="pln"> </span><span class="atn">href</span><span class="pun">=</span><span class="atv">"prototype_1.css"</span><span class="tag">/&gt;</span><span class="pln">

	</span><span class="tag">&lt;title&gt;</span><span class="pln">
		accueil
	</span><span class="tag">&lt;/title&gt;</span><span class="pln">

</span><span class="tag">&lt;/head&gt;</span><span class="pln">

</span><span class="tag">&lt;body&gt;</span><span class="pln">

	</span><span class="pun">&lt;?</span><span class="pln">php 
	$header </span><span class="pun">=</span><span class="pln"> file_get_contents</span><span class="pun">(</span><span class="str">'header.html'</span><span class="pun">);</span><span class="pln">
	echo $header</span><span class="pun">;</span><span class="pln">
 </span><span class="pun">?&gt;</span><span class="pln">

 </span><span class="tag">&lt;section&gt;</span><span class="pln">
 	</span><span class="tag">&lt;form</span><span class="pln"> </span><span class="atn">method</span><span class="pun">=</span><span class="atv">"post"</span><span class="pln"> </span><span class="atn">action</span><span class="pun">=</span><span class="atv">"inscription.php"</span><span class="tag">&gt;</span><span class="pln">
		</span><span class="tag">&lt;legend&gt;</span><span class="pln">connexion au panel</span><span class="tag">&lt;/legend&gt;</span><span class="pln">
		</span><span class="tag">&lt;div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"form-group"</span><span class="tag">&gt;</span><span class="pln">
			</span><span class="tag">&lt;label</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-lg-2 control-label"</span><span class="tag">&gt;</span><span class="pln">login</span><span class="tag">&lt;/label&gt;</span><span class="pln">
			</span><span class="tag">&lt;div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-lg10"</span><span class="tag">&gt;</span><span class="pln">
				</span><span class="tag">&lt;input</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"text"</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"form-control"</span><span class="pln"> </span><span class="atn">name</span><span class="pun">=</span><span class="atv">"login"</span><span class="pln"> </span><span class="atn">placeholder</span><span class="pun">=</span><span class="atv">"login"</span><span class="tag">&gt;</span><span class="pln">
			</span><span class="tag">&lt;/div&gt;</span><span class="pln">
		</span><span class="tag">&lt;/div&gt;&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;</span><span class="pln">

		</span><span class="tag">&lt;div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"form-group"</span><span class="tag">&gt;</span><span class="pln">
			</span><span class="tag">&lt;label</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-lg-2 control-label"</span><span class="tag">&gt;</span><span class="pln">mot de passe</span><span class="tag">&lt;/label&gt;</span><span class="pln">
			</span><span class="tag">&lt;div</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"col-lg-10"</span><span class="tag">&gt;</span><span class="pln">
				</span><span class="tag">&lt;input</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"password"</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"form-control"</span><span class="pln"> </span><span class="atn">name</span><span class="pun">=</span><span class="atv">"password"</span><span class="pln"> </span><span class="atn">placeholder</span><span class="pun">=</span><span class="atv">"mot de passe"</span><span class="tag">&gt;</span><span class="pln">
			</span><span class="tag">&lt;/div&gt;</span><span class="pln">
		</span><span class="tag">&lt;/div&gt;</span><span class="pln">

	</span><span class="tag">&lt;br/&gt;&lt;br/&gt;&lt;center&gt;&lt;button</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"submit"</span><span class="pln"> </span><span class="atn">name</span><span class="pun">=</span><span class="atv">"submit"</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"btn btn-primary"</span><span class="tag">&gt;</span><span class="pln">connexion</span><span class="tag">&lt;/button&gt;&lt;/center&gt;</span><span class="pln">

	</span><span class="tag">&lt;/form&gt;</span><span class="pln">
	</span><span class="tag">&lt;/form&gt;</span><span class="pln">
 </span><span class="tag">&lt;/section&gt;</span><span class="pln">

 </span><span class="tag">&lt;div</span><span class="pln"> </span><span class="atn">id</span><span class="pun">=</span><span class="atv">"horloge"</span><span class="tag">&gt;</span><span class="pln"> </span><span class="tag">&lt;/div&gt;</span><span class="pln">


 </span><span class="pun">&lt;?</span><span class="pln">php 
	$header </span><span class="pun">=</span><span class="pln"> file_get_contents</span><span class="pun">(</span><span class="str">'footer.html'</span><span class="pun">);</span><span class="pln">
	echo $header</span><span class="pun">;</span><span class="pln">
 </span><span class="pun">?&gt;</span><span class="pln">
	
</span><span class="tag">&lt;/body&gt;</span><span class="pln">

</HTML></pre>

inscription.php

<pre class="ipsCode prettyprint lang-php prettyprinted">
 <?php
//Connexion à la BDD
try
{

$pdo_options</span><span class="pun">[</span><span class="pln">PDO</span><span class="pun">::</span><span class="pln">ATTR_ERRMODE</span><span class="pun">]</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> PDO</span><span class="pun">::</span><span class="pln">ERRMODE_EXCEPTION</span><span class="pun">;</span><span class="pln">
$bdd </span><span class="pun">=</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> PDO</span><span class="pun">(</span><span class="str">'mysql:host=**;dbname=**;charset=utf8'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'**'</span><span class="pun">,</span><span class="pln"> </span><span class="str">'**'</span><span class="pun">,</span><span class="pln">$pdo_options</span><span class="pun">);</span><span class="pln">

}

catch(Exception $e)
{
die('Erreur :'.$e->getMessage());
}

</span><span class="kwd">if</span><span class="pun">(</span><span class="pln">ISSET</span><span class="pun">(</span><span class="pln">$_POST</span><span class="pun">[</span><span class="str">'submit'</span><span class="pun">]))</span><span class="pln">

{

//On créer les variables
$login = $_POST['login'];
$password = $_POST['password'];
$password = hash("sha256", $password);

$req = $bdd->prepare('INSERT INTO MEMBRE(login, password) VALUES ($login, $password)');

if(!empty($login)) {

}else{
?>

mot de passe vide !

<?php
}

if(empty($login) && empty($password))
{

}else{

session_start();
$_SESSION['login'] = $_POST['login'];
header('Location: accueil.php');

}

?> </pre>

une des erreurs venais de cette ligne

<pre class="ipsCode prettyprint lang-php prettyprinted">
 req->execute(array("login" => $login, "password" => $password)); </pre>

mais ce n'était pas la seul

4Spartan8

<blockquote class="ipsQuote" data-ipsquote="" data-ipsquote-contentapp="forums" data-ipsquote-contentclass="forums_Topic" data-ipsquote-contentcommentid="17976" data-ipsquote-contentid="437" data-ipsquote-contenttype="forums" data-ipsquote-timestamp="1492694458" data-ipsquote-userid="1674" data-ipsquote-username="zougui">
<div class="ipsQuote_citation">
Il y a 2 heures, zougui a dit :
</div>
<div class="ipsQuote_contents">

...

</div>
</blockquote>

D'accord, écoute je vais te renvoyer un code propre dans quelques minutes, tu l'essayera et me dira si ça marche (j'éditerai mon message).


J'ai une autre question, pourquoi faire ça ? :

<pre class="ipsCode prettyprint lang-php prettyprinted">
 <?php
$header = file_get_contents('footer.html');
echo $header;
?></pre>

Si tu veux inclure le code d'une autre page ici tu n'a qu'à faire un include :

<pre class="ipsCode prettyprint lang-php prettyprinted">
<?php
include('tapage.html');
?></pre>

zougui

ok merci, pour le 
<pre class="ipsCode"><?php $header = file_get_contents('footer.html'); echo $header;?>
</pre>

4Spartan8

Alors, voilà la page accueil.php :

<pre class="ipsCode prettyprint lang-html prettyprinted">

<html lang="FR">
<head>
<meta charset="UTF-8"/>
<title>Accueil</title>
</head>

</span><span class="com">&lt;!-- FORMULAIRE HTML BASIQUE --&gt;</span><span class="pln">
</span><span class="tag">&lt;form</span><span class="pln"> </span><span class="atn">method</span><span class="pun">=</span><span class="atv">"post"</span><span class="pln"> </span><span class="atn">action</span><span class="pun">=</span><span class="atv">"inscription.php"</span><span class="tag">&gt;</span><span class="pln">
	</span><span class="tag">&lt;p&gt;</span><span class="pln">Pseudo : </span><span class="tag">&lt;input</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"text"</span><span class="pln"> </span><span class="atn">name</span><span class="pun">=</span><span class="atv">"login"</span><span class="pln"> </span><span class="atn">placeholder</span><span class="pun">=</span><span class="atv">"Identifiant"</span><span class="tag">/&gt;&lt;/p&gt;</span><span class="pln">
	</span><span class="tag">&lt;p&gt;</span><span class="pln">Mot de passe : </span><span class="tag">&lt;input</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"password"</span><span class="pln"> </span><span class="atn">name</span><span class="pun">=</span><span class="atv">"password"</span><span class="pln"> </span><span class="atn">placeholder</span><span class="pun">=</span><span class="atv">"Mot de passe"</span><span class="tag">/&gt;&lt;/p&gt;</span><span class="pln">
	</span><span class="tag">&lt;input</span><span class="pln"> </span><span class="atn">type</span><span class="pun">=</span><span class="atv">"submit"</span><span class="pln"> </span><span class="atn">name</span><span class="pun">=</span><span class="atv">"submit"</span><span class="pln"> </span><span class="atn">value</span><span class="pun">=</span><span class="atv">"Connexion"</span><span class="tag">/&gt;</span><span class="pln">
	
</span><span class="tag">&lt;/form&gt;</span><span class="pln">

</body>
</html></pre>

Et voilà la page inscription.php :

<pre class="ipsCode prettyprint lang-php prettyprinted">
<?php

/* CONNEXION A LA BASE DE DONNEE /
try
{
$bdd = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'root', '**');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (Exception $e)
{
die('Erreur : ' . $e->getMessage());
}

/* ON CREER NOS VARIABLES */
$login = htmlspecialchars($_POST['login']);
$password = htmlspecialchars($_POST['password']); //Variable qui ne nous servira qu'une seule fois
$password_hash = sha1($password); //On créer une nouvelle variable qui comprend le mot de passe entré mais hashé en SHA1

if(isset($_POST['submit'])){ //Si on a soumi le formulaire

</span><span class="com">//Ici on va lister les erreurs dans un tableau, pour chaque nouvelle erreur on créer une case dans le tableau</span><span class="pln">
</span><span class="com">//On part de 0 donc -&gt; $error[0] PUIS ENSUITE $error[1] etc ..</span><span class="pln">

</span><span class="kwd">if</span><span class="pun">(</span><span class="pln">empty</span><span class="pun">(</span><span class="pln">$login</span><span class="pun">)){</span><span class="pln">
	$error</span><span class="pun">[</span><span class="lit">0</span><span class="pun">]</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">'Login vide'</span><span class="pun">;</span><span class="pln"> </span><span class="com">//La première entrée du tableau sera = au message 'Login vide'</span><span class="pln">
</span><span class="pun">}</span><span class="pln">

</span><span class="kwd">if</span><span class="pun">(</span><span class="pln">empty</span><span class="pun">(</span><span class="pln">$password</span><span class="pun">)){</span><span class="pln">
	$error</span><span class="pun">[</span><span class="lit">1</span><span class="pun">]</span><span class="pln"> </span><span class="pun">=</span><span class="pln"> </span><span class="str">'Password vide'</span><span class="pun">;</span><span class="pln"> </span><span class="com">//Pareil que plus haut</span><span class="pln">
</span><span class="pun">}</span><span class="pln">


</span><span class="kwd">if</span><span class="pun">(</span><span class="pln">count</span><span class="pun">(</span><span class="pln">$error</span><span class="pun">)</span><span class="pln"> </span><span class="pun">==</span><span class="pln"> </span><span class="lit">0</span><span class="pun">){</span><span class="pln"> </span><span class="com">//Cette fonction compte le nombre d'entrée dans le tableau (attention $error[0] compte comme une entrée. Ici on dit que si le nombre d'entrée dans le tableau est égale à 0 alors on peut faire l'insertion car aucune erreur</span><span class="pln">
	$req </span><span class="pun">=</span><span class="pln"> $bdd</span><span class="pun">-&gt;</span><span class="pln">prepare</span><span class="pun">(</span><span class="str">'INSERT INTO members(login, password) VALUES(:login, :password)'</span><span class="pun">);</span><span class="pln">
	$req</span><span class="pun">-&gt;</span><span class="pln">execute</span><span class="pun">(</span><span class="pln">array</span><span class="pun">(</span><span class="pln">
			</span><span class="str">'login'</span><span class="pln"> </span><span class="pun">=&gt;</span><span class="pln"> $login</span><span class="pun">,</span><span class="pln">
			</span><span class="str">'password'</span><span class="pln"> </span><span class="pun">=&gt;</span><span class="pln"> $password_hash</span><span class="pun">));</span><span class="pln">
	echo </span><span class="str">'Inscription validée !'</span><span class="pun">;</span><span class="pln"> </span><span class="com">//On affiche un message quand l'utilisateur est inscrit correctement</span><span class="pln">
</span><span class="pun">}</span><span class="kwd">else</span><span class="pun">{</span><span class="pln"> </span><span class="com">//Par contre si le nombre d'entrée est supérieur à zéro alors on fait une boucle et on affiche les erreurs avec la variable $list</span><span class="pln">
	</span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$error </span><span class="kwd">as</span><span class="pln"> $list</span><span class="pun">){</span><span class="pln">
		echo $list </span><span class="pun">.</span><span class="pln"> </span><span class="str">'&lt;br/&gt;'</span><span class="pun">;</span><span class="pln">
	</span><span class="pun">}</span><span class="pln">
</span><span class="pun">}</span><span class="pln">

}
?></pre>

Le code de la page d'inscription est assez compliqué, si tu as des questions n'hésite pas, une fois que tu as essayé donne moi un retour 

Je n'ai pas inclue le code pour la connexion par contre !

zougui

ok merci c'est rare de nos jours les gens aussi sympas je te dirais des nouvelles une fois que se seras importer dans mon site j'ai 500 fichiers en cours donc faut patienter tinquiète je vais essayer de me bébrouiller pour la connexion,


EDIT


ok c'est cool merci maintenant je vais améliorer sa avec une confirmation du mot de passe, mais une question a quoi servent les placeholders ?

<pre class="ipsCode prettyprint lang-html">
Mot de passe : <input type="password" name="password" placeholder="Mot de passe"/></pre>

4Spartan8

<blockquote class="ipsQuote" data-ipsquote="" data-ipsquote-contentapp="forums" data-ipsquote-contentclass="forums_Topic" data-ipsquote-contentcommentid="17980" data-ipsquote-contentid="437" data-ipsquote-contenttype="forums" data-ipsquote-timestamp="1492706378" data-ipsquote-userid="1674" data-ipsquote-username="zougui">
<div class="ipsQuote_citation">
il y a 47 minutes, zougui a dit :
</div>
<div class="ipsQuote_contents">

ok merci c'est rare de nos jours les gens aussi sympas je te dirais des nouvelles une fois que se seras importer dans mon site j'ai 500 fichiers en cours donc faut patienter tinquiète je vais essayer de me bébrouiller pour la connexion,


EDIT


ok c'est cool merci maintenant je vais améliorer sa avec une confirmation du mot de passe, mais une question a quoi servent les placeholders ?

<pre class="ipsCode prettyprint lang-html prettyprinted">

Mot de passe : <input type="password" name="password" placeholder="Mot de passe"/></pre>
</div>
</blockquote>

Pas de soucis, c'est normal ! 

Les placeholder servent à afficher un message dans le fond de ton input, regarde ton formulaire sur ta page HTML, tu devrais voir écris "Mot de passe". Bien sur ils ne sont pas indispensables, tu peux très bien les enlever !

RedRaven

Petit probleme tout bete, je suis débutant et je ne sais pas du tout ou et dans quel circonstance placer ce morceaux de code


Merci d'avance

<pre class="ipsCode prettyprint prettyprinted" style="font-family:monospace, monospace;font-size:14px;background:rgb(250,250,250);clear:both;padding:2px;border:1px solid rgb(136,136,136);color:rgb(39,42,52);font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;word-spacing:0px;">
CREATE TABLE membre (
id int(11) NOT NULL auto_increment,
login varchar(8) NOT NULL,
password varchar(8) NOT NULL,
PRIMARY KEY (id),
KEY ID_2 (id)
);</pre>

Soulalex

Tu exécutes ce bout de code sur ton serveur SQL.

Robinvtn

Bonjour! Quant à moi tout fonctionne, sauf la page de connexion, soit la page de connexion ne fonctionne pas (pour moi) soit le code sur les pages spécificiques pour rediriger les utilisateurs si ils ne sont pas connecté ne fonctionne pas, je sais pas quel est le problème .. Quelqu'un pourrait m'aider ?

NodeBB

Créer un système de Connexion / Inscription en PHP