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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
|
<?php
include("admin/connexion.php");
if(isset ($_POST['submit']))
{
$username=$_POST['username'];
$password=$_POST['password'];
$mail=$_POST['mail'];
$nom=$_POST['nom'];
$prenom=$_POST['prenom'];
$adresse=$_POST['adresse'];
$tel=$_POST['tel'];
$sqlstr="SELECT * FROM inscription WHERE username='$username'";
$result = mysql_query($sqlstr) or die ("Erreur de requête sur la table de base de données");
$nb=mysql_num_rows($result);
if($nb==0)
{
$sqlstr="INSERT INTO inscription (username,password,mail,nom,prenom,adresse,tel,etat) VALUES
('$username','$password','$mail','$nom','$prenom','$adresse','$tel','1')";
echo $sqlstr;
mysql_query($sqlstr) or die ("Erreur ".mysql_errno()." : " . mysql_error());
echo 'Veuillez consultrer votre boite de reception pour les informations d\'authentification';
}
}
?>
<link href="site/css/styles.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="js/jquery.validate.min.js"></script>
<script type="text/javascript">
/**
* Basic jQuery Validation Form Demo Code
* Copyright Sam Deering 2012
* Licence: http://www.jquery4u.com/license/
*/
(function($,W,D)
{
var JQUERY4U = {};
JQUERY4U.UTIL =
{
setupFormValidation: function()
{
$("#register-form").validate({
rules: {
// les champs de encaissement bureau de poste
username:"required",
password:"required",
password1:"required",
nom:"required",
prenom:"required",
mail:"required",
adresse:"required",
tel:"required"
},
messages: {
username:"Veuillez renseigner ce champ",
password:"Veuillez renseigner ce champ",
password1:"Veuillez renseigner ce champ",
nom:"Veuillez renseigner ce champ",
prenom:"Veuillez renseigner ce champ",
mail:"Veuillez renseigner ce champ",
adresse:"Veuillez renseigner ce champ",
tel:"Veuillez renseigner ce champ"
}
});
}
}
//when the dom has loaded setup form validation rules
$(D).ready(function($) {
JQUERY4U.UTIL.setupFormValidation();
});
})(jQuery, window, document);
</script>
<form action="" method="post" name="critere" id="register-form" novalidate>
<div id="container-content"><!--------------------------container content----------------------------->
<div id="content"><!------------------------------------------content--------------------------------->
<h2>Inscription</h2>
<br/>
<p> Nom d'utilisateur: <input type="text" name="username" id="username"/></p><br/>
<p> Mot de passe: <input type="password" name="password" id="password"/></p><br/>
<p> Confirmer mot de passe: <input type="password" name="password1" id="password1"/></p><br/>
<p> Adresse mail: <input type="mail" name="mail" id="mail"/></p><br/>
<p> Nom: <input type="text" name="nom" id="mail"/></p><br/>
<p> Prénom: <input type="text" name="prenom" id="prenom"/></p><br/>
<p> Adresse: <input type="text" name="adresse" id="adresse"/></p><br/>
<p> Tél: <input type="text" name="tel" id="tel"/></p><br/>
<p> <input type="submit" name="submit" value="Inscription" class="button" style="color:red;" /></p><br/>
</div><!------------------------------------------end content--------------------------------->
</div> <!-----------------------------------end container content----------------------------->
</form> |