fogamir
Messages postés4Date d'inscriptionmardi 13 décembre 2011StatutMembreDernière intervention25 mai 2012
-
20 mai 2012 à 14:57
fogamir
Messages postés4Date d'inscriptionmardi 13 décembre 2011StatutMembreDernière intervention25 mai 2012
-
25 mai 2012 à 09:09
Bonjour voila j essaye de m'inscrire sur mon site mais sa ne va pas je sais pas si sa viens lors de la connection a la base de donnée ou alors mon code.
Voila je vous met mon code de A à Z.
Peut on m'aider s'il vous plait?
Merci d'avance :)
L'inscription.
<?PHP
$erreur= 1;
$pseudoe="n";
$nomv="noir";
$prenomv="noir";
$passv="noir";
$pseudov="noir";
$emailv="noir";
$nom="";
$prenom="";
$pseudo="";
$email="";
if (isset($_POST['envoyer']))
{ $erreur=0;
// si le nom est vide ou plus petit que 4
if (strlen(trim($_POST['nom']))<2) { $erreur++; $nomv="rouge"; } else $nom=$_POST['nom'];
// si le prénom est vide ou plus petit que 2
if (strlen(trim($_POST['prenom']))<2) { $erreur++; $prenomv="rouge"; } else $prenom=$_POST['prenom'];
// si pseudo vide et pas assez long
if (strlen(trim($_POST['pseudo']))>1)
{ // si pseudo déjà existant
include('forconnect.php');
$sql="select id from inscription where pseudo='".$_POST['pseudo']."'";
// $result=mysql_query($sql);
// if (mysql_num_rows($result)>0) { $erreur++; $pseudov="rouge"; $pseudoe="o"; } else $pseudo=$_POST['pseudo'];
} else {$erreur++; $pseudov="rouge"; }
// si mail vide
if (strlen(trim($_POST['email']))<5) {$erreur++; $emailv="rouge"; }
// si mail ne repecte pas la syntaxe
if(!preg_match("/^[_a-zA-Z0-9-]+(.[_a-zA-Z0-9-]+)*@([a-zA-Z0-9-]+.)+[a-zA-Z]{2,4}$/",$_POST['email'])){
$erreur++;
$emailv="rouge";
$errors[]='email format';
}else{
$email=$_POST['email'];
}
// si mot de passe vide
if (strlen(trim($_POST['pass']))==0) {$erreur++; $passv="rouge"; }
// si mot de passe pas assez long
if (strlen(trim($_POST['pass']))<6) {$erreur++; $passv="rouge"; }
// si mot de passe 1 différent de mot de passe 2
if ($_POST['pass']!=$_POST['passv']) { $erreur++; $passv="rouge"; }
}
$titre=("Inscription");
include"header.php";
if ($erreur>0)
{
?>
<form method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
">* Nom,
" />,
----
" >* Prénom,
" />,
----
">* Pseudo<?php if ($pseudoe=="o") echo " (Déjà utilisé)"; ?>,
" />,
----
">* Adresse e-mail,
" />,
----
">* Mot de passe (6 caractères),
<li id="weak" class="nrm">Faible</li><li id="medium" class="nrm">Moyen</li><li id="strong" class="nrm">Fort</li>,
----
">* Mot de passe (Confirmation),
,
----
* Date de naissance,
<select name="jours">
<?php
for ($i=1; $i<32; $i++)
{ echo '<option value="'.$i.'"';
if (isset($_POST['jours']))
{ if ($_POST['jours']==$i) echo 'selected="selected"';
}
echo '>'.$i.'</option>';
}
echo '</select>
<select name="mois">';
$mois=array('', 'Janvier','Février', 'Mars', 'Avril', 'Mai', 'Juin', 'Juillet', 'Août', 'Septembre', 'Octobre', 'Novembre', 'Décembre');
for ($i=1; $i<13; $i++)
{ echo '<option value="'.$i.'"';
if (isset($_POST['mois']))
{ if ($_POST['mois']==$i) echo 'selected="selected"';
}
echo '>'.$mois[$i].'</option>';
}
echo '</select>
<select name="annee">';
for ($i=1994; $i>1920; $i--)
{ echo '<option value="'.$i.'"';
if (isset($_POST['annee']))
{ if ($_POST['annee']==$i) echo 'selected="selected"';
}
echo '>'.$i.'</option>';
}
echo '</select>,
----
* Sexe,
Homme
Femme';
} else {
echo ' checked="checked" value="H" />Homme
Femme';
} ?>,
----
* Pays,
<select name="pays" >
<?php
$listepays=array("","Afghanistan","Afrique_Centrale","Afrique_du_sud","Albanie","Algerie","Allemagne","Andorre","Angola","Anguilla","Arabie_Saoudite",
"Argentine","Armenie","Australie","Autriche","Azerbaidjan","Bahamas","Bangladesh","Barbade","Bahrein","Belgique","Belize","Benin","Bermudes","Bielorussie",
"Bolivie","Botswana","Bhoutan","Boznie_Herzegovine","Bresil","Brunei","Bulgarie","Burkina_Faso","Burundi","Caiman","Cambodge","Cameroun","Canada","Canaries",
"Cap_vert","Chili","Chine","Chypre","Colombie","Comores","Congo","Congo_democratique","Cook","Coree_du_Nord","Coree_du_Sud","Costa_Rica","Cote_d_Ivoire","Croatie",
"Cuba","Danemark","Djibouti","Dominique","Egypte","Emirats_Arabes_Unis","Equateur","Erythree","Espagne","Estonie","Etats_Unis","Ethiopie","Falkland","Feroe","Fidji",
"Finlande","France","Gabon","Gambie","Georgie","Ghana","Gibraltar","Grece","Grenade","Groenland","Guadeloupe","Guam","Guatemala","Guernesey","Guinee","Guinee_Bissau",
"Guinee equatoriale","Guyana","Guyane_Francaise ","Haiti","Hawaii","Honduras","Hong_Kong","Hongrie","Inde","Indonesie","Iran","Iraq","Irlande","Islande","Israel","Italie",
"Jamaique","Jan Mayen","Japon","Jersey","Jordanie","Kazakhstan","Kenya","Kirghizstan","Kiribati","Koweit","Laos","Lesotho","Lettonie","Liban","Liberia","Liechtenstein",
"Lituanie","Luxembourg","Lybie","Macao","Macedoine","Madagascar","Madère","Malaisie","Malawi","Maldives","Mali","Malte","Man","Mariannes du Nord","Maroc","Marshall",
"Martinique","Maurice","Mauritanie","Mayotte","Mexique","Micronesie","Midway","Moldavie","Monaco","Mongolie","Montserrat","Mozambique","Namibie","Nauru","Nepal","Nicaragua",
"Niger","Nigeria","Niue","Norfolk","Norvege","Nouvelle_Caledonie","Nouvelle_Zelande","Oman","Ouganda","Ouzbekistan","Pakistan","Palau","Palestine","Panama",
"Papouasie_Nouvelle_Guinee","Paraguay","Pays_Bas","Perou","Philippines","Pologne","Polynesie","Porto_Rico","Portugal","Qatar","Republique_Dominicaine","Republique_Tcheque",
"Reunion","Roumanie","Royaume_Uni","Russie","Rwanda","Sahara Occidental","Sainte_Lucie","Saint_Marin","Salomon","Salvador","Samoa_Occidentales","Samoa_Americaine",
"Sao_Tome_et_Principe","Senegal","Seychelles","Sierra Leone","Singapour","Slovaquie","Slovenie","Somalie","Soudan","Sri_Lanka","Suede","Suisse","Surinam","Swaziland",
"Syrie","Tadjikistan","Taiwan","Tonga","Tanzanie","Tchad","Thailande","Tibet","Timor_Oriental","Togo","Trinite_Tobago","Tristan da cunha","Tunisie","Turkmenistan",
"Turquie","Ukraine","Uruguay","Vanuatu","Vatican","Venezuela","Vierges_Americaines","Vierges_Britanniques","Vietnam","Wake","Wallis et Futuma","Yemen","Yougoslavie",
"Zambie","Zimbabwe");
for ($i=1; $i<229; $i++)
{ echo '<option value="'.$listepays[$i].'"';
if (isset($_POST['pays'])) { if ($_POST['pays']==$listepays[$i]) echo ' selected="selected"'; } else if ($listepays[$i]=="Belgique") echo ' selected="selected"';
echo '>';
$temp=str_replace('_',' ',$listepays[$i]);
echo $temp.'</option>';
}
?>
</select>,
----
,
</form>
* champs obligatoires
<?PHP
} else {
// requête sql pour ajouter un nouveau membre
$sql="insert into inscription values('', '".$nom."', '".$prenom."', '".$pseudo."', '".$email."', '".md5($email)."', '".$_POST['annee']."-".$_POST['mois']."-".$_POST['jours']."', '".$_POST['sexe']."', '".$_POST['pays']."')";
// if (mysql_query($sql)) echo "enregistrement réussi"; else echo "Problème lors de l'écriture des données";
}
include"footer.php";
?>
Pour se connecter a la base de donnée.
<?php
//
$user ="amir"; // L UTILISATEUR LORS DE LA CONNECTION
$pass= "**********"; // LE MOT DE PASSE
$ip="hebergeur"; // HOST DE CONNECTION
$bdd= "qualif"; // NOM DE LA BASE DE DONNEE
?>
