//On verifie si lemail est valide if(preg_match("#^[a-z0-9._-]{1,}@[a-z0-9._-]{2,}\.[a-z]{2,4}$#",$_POST['Email'])) $atom = '[-a-z0-9!#$%&\'*+\\/=?^_`{|}~]'; // caractères autorisés avant l'arobase $domain = '([a-z0-9]([-a-z0-9]*[a-z0-9]+)?)'; // caractères autorisés après l'arobase (nom de domaine)
mysql_query($sql) or die('Erreur SQL !'.$sql.' '.mysql_error());
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionmysql_query($sql) or die('Erreur SQL !'.$sql.' '.mysql_error());
if(preg_match("#^[a-z0-9._-]{1,}@[a-z0-9._-]{2,}\.[a-z]{2,4}$#",$_POST['Email']))
$atom = '[-a-z0-9!#$%&\'*+\\/=?^_`{|}~]'; // caractères autorisés avant l'arobase $domain = '([a-z0-9]([-a-z0-9]*[a-z0-9]+)?)'; // caractères autorisés après l'arobase (nom de domaine) $regex = '/^' . $atom . '+' . // Une ou plusieurs fois les caractères autorisés avant l'arobase '(\.' . $atom . '+)*' . // Suivis par zéro point ou plus // séparés par des caractères autorisés avant l'arobase '@' . // Suivis d'un arobase '(' . $domain . '{1,63}\.)+' . // Suivis par 1 à 63 caractères autorisés pour le nom de domaine // séparés par des points $domain . '{2,63}$/i'; // Suivi de 2 à 63 caractères autorisés pour le nom de domaine // test de l'adresse e-mail if (preg_match($regex, $email)) { echo "L'adresse e-mail $email est valide"; } else { echo "L'adresse e-mail $email n'est pas valide"; }
isset($_POST['login']) && !empty($_POST['login'])
if ($_POST['pass'] != $_POST['pass_confirm']) {
// on teste si le visiteur a soumis le formulaire if (isset($_POST['inscription']) && $_POST['inscription'] == 'Inscription') { // on teste l'existence de nos variables. On teste également si elles ne sont pas vides if (!empty($_POST['login']) && !empty($_POST['pass']) && !empty($_POST['pass_confirm']) && !empty($_POST['email']) && !empty($_POST['auction']) && !empty($_POST['dream'])) { // on teste les deux mots de passe if ($_POST['pass'] == $_POST['pass_confirm']) { //On verifie si lemail est valide if(preg_match('#^(([a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+\.?)*[a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+)@(([a-z0-9-_]+\.?)*[a-z0-9-_]+)\.[a-z]{2,}$#i',$_POST['email'])){ // on recherche si ce login est déjà utilisé par un autre membre $sql = 'SELECT count(*) FROM member WHERE login="'.mysql_escape_string($_POST['login']).'"'; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); $data = mysql_fetch_array($req); if ($data[0] == 0) { $sql = 'INSERT INTO member VALUES("", "'.mysql_escape_string($_POST['login']).'", "'.mysql_escape_string(md5($_POST['pass'])).'", "'.mysql_escape_string($_POST['type']).'", "'.mysql_escape_string($_POST['name']).'", "'.mysql_escape_string($_POST['firstname']).'", "'.mysql_escape_string($_POST['birth_day']).'", "'.mysql_escape_string($_POST['birth_month']).'", "'.mysql_escape_string($_POST['birth_year']).'", "'.mysql_escape_string($_POST['address1']).'", "'.mysql_escape_string($_POST['address2']).'", "'.mysql_escape_string($_POST['job']).'", "'.mysql_escape_string($_POST['code_postal']).'", "'.mysql_escape_string($_POST['city']).'", "'.mysql_escape_string($_POST['state']).'", "'.mysql_escape_string($_POST['country']).'", "'.mysql_escape_string($_POST['email']).'", "'.mysql_escape_string($_POST['phone']).'", "'.mysql_escape_string($_POST['auction']).'", "'.mysql_escape_string($_POST['dream']).'", "'.mysql_escape_string($_POST['mobile']).'", "'.mysql_escape_string($_POST['skype']).'", "'.mysql_escape_string($_POST['msn']).'", "'.mysql_escape_string($_POST['newsletter']).'", "'.mysql_escape_string($_POST['ext']).'", "'.mysql_escape_string($_POST['karus']).'", "'.mysql_escape_string($_POST['sponsor']).'", "'.mysql_escape_string($_POST['comment']).'")'; mysql_query($sql) or die('Erreur SQL !'.$sql.' '.mysql_error()); session_start(); $_SESSION['login'] = $_POST['login']; header('Location: member.php'); exit(); } else { $erreur = 'Member login already has it.'; } } else { $erreur = 'Error in the e-mail address.'; } } else { $erreur = 'The two passwords are different.'; } } else { $erreur = 'At least one field is empty'; } }
<?php session_start(); /*ici le session_start(); toujours en haut du fichier*/ /*petit filtre pas du luxe */ foreach($_POST as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_POST[$k]=$v } foreach($_GET as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_GET[$k]=$v } foreach($_REQUEST as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_REQUEST[$k]=$v } /*fin filtre*/ function conn(){ mysql_connect('localhost','root',''); mysql_select_db('mydb'); } function checkmail($mail){ if(preg_match('#^(([a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+\.?)*[a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+)@(([a-z0-9-_]+\.?)*[a-z0-9-_]+)\.[a-z]{2,}$#i',$_POST['email'])){ return true; }else{ return false; } } function ismembre($login){ conn(); $log=mysql_real_escape_string($login); // on recherche si ce login est déjà utilisé par un autre membre $sql = "SELECT id FROM member WHERE login='".$log."' limit 1"; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); if(mysql_fetch_row($req)===1){ return true; }else{ return false; } mysql_close(); } /*les tests*/ $err =null; /*au depart*/ // on teste l'existence de nos variables. On teste également si elles ne sont pas vides if(isset($_POST['login']) && !empty($_POST['login'])) { } else {$err.=' err login';} if(isset($_POST['pass']) && !empty($_POST['pass'])) { } else {$err.=' err pass';} if(isset($_POST['pass_confirm']) && !empty($_POST['pass_confirm'])) { } else {$err.=' err pass_confirm';} if ($_POST['pass'] === $_POST['pass_confirm']) { } else else {$err.=' pass diff confirm';} if(isset($_POST['email']) && !empty($_POST['email'])) { if(checkmail($mail)===true) { }else{ $err.=' err check syntaxe mail'; } }else {$err.=' err email';} if(isset($_POST['auction']) && !empty($_POST['auction'])) { } else {$err.=' err auction';} if(isset($_POST['dream']) && !empty($_POST['dream']))) { } else {$err.=' err dream';} if(ismembre($mail)===false) { }else{ $err.=' Login utilisé ...'; } // on teste si le visiteur a soumis le formulaire if (empty($err) && isset($_POST['inscription']) && $_POST['inscription'] === 'Inscription') { //on insere et redirige conn(); $sql = 'INSERT INTO member VALUES("", "'.mysql_escape_string($_POST['login']).'", "'.mysql_escape_string(md5($_POST['pass'])).'", "'.mysql_escape_string($_POST['type']).'", "'.mysql_escape_string($_POST['name']).'", "'.mysql_escape_string($_POST['firstname']).'", "'.mysql_escape_string($_POST['birth_day']).'", "'.mysql_escape_string($_POST['birth_month']).'", "'.mysql_escape_string($_POST['birth_year']).'", "'.mysql_escape_string($_POST['address1']).'", "'.mysql_escape_string($_POST['address2']).'", "'.mysql_escape_string($_POST['job']).'", "'.mysql_escape_string($_POST['code_postal']).'", "'.mysql_escape_string($_POST['city']).'", "'.mysql_escape_string($_POST['state']).'", "'.mysql_escape_string($_POST['country']).'", "'.mysql_escape_string($_POST['email']).'", "'.mysql_escape_string($_POST['phone']).'", "'.mysql_escape_string($_POST['auction']).'", "'.mysql_escape_string($_POST['dream']).'", "'.mysql_escape_string($_POST['mobile']).'", "'.mysql_escape_string($_POST['skype']).'", "'.mysql_escape_string($_POST['msn']).'", "'.mysql_escape_string($_POST['newsletter']).'", "'.mysql_escape_string($_POST['ext']).'", "'.mysql_escape_string($_POST['karus']).'", "'.mysql_escape_string($_POST['sponsor']).'", "'.mysql_escape_string($_POST['comment']).'")'; mysql_query($sql) or die('Erreur SQL !'.$sql.' '.mysql_error()); mysql_close(); $_SESSION['login'] = $_POST['login']; header('Location: member.php');exit; }else{ echo $err; } ?>
<?php session_start(); /*ici le session_start(); toujours en haut du fichier*/ echo ''; print_r($_POST); echo ' '; /*petit filtre pas du luxe */ foreach($_POST as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_POST[$k]=$v; } foreach($_GET as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_GET[$k]=$v; } foreach($_REQUEST as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_REQUEST[$k]=$v; } /*fin filtre*/ function conn(){ mysql_connect('localhost','root',''); mysql_select_db('mydb'); } function checkmail($mail){ if(preg_match('#^(([a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+\.?)*[a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+)@(([a-z0-9-_]+\.?)*[a-z0-9-_]+)\.[a-z]{2,}$#i',$_POST['email'])){ return true; }else{ return false; } } function ismembre($login){ conn(); $log=mysql_real_escape_string($login); // on recherche si ce login est déjà utilisé par un autre membre $sql = "SELECT id FROM member WHERE login='".$log."' limit 1"; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); if(mysql_fetch_row($req)===1){ return true; }else{ return false; } mysql_close(); } /*les tests*/ $err =null; /*au depart*/ // on teste l'existence de nos variables. On teste également si elles ne sont pas vides if(isset($_POST['login']) && !empty($_POST['login'])) { } else {$err.=' err login';} if(isset($_POST['pass']) && !empty($_POST['pass'])) { } else {$err.=' err pass';} if(isset($_POST['pass_confirm']) && !empty($_POST['pass_confirm'])) { } else {$err.=' err pass_confirm';} if (isset($_POST['pass'],$_POST['pass_confirm']) && $_POST['pass'] === $_POST['pass_confirm']) { } else {$err.=' pass diff confirm';} if(isset($_POST['email']) && !empty($_POST['email'])) { if(checkmail($mail)===true) { }else{ $err.=' err check syntaxe mail'; } }else {$err.=' err email';} if(isset($_POST['auction']) && !empty($_POST['auction'])) { } else {$err.=' err auction';} if(isset($_POST['dream']) && !empty($_POST['dream'])) { } else {$err.=' err dream';} if(isset($_POST['login']) && strlen($_POST['login'])>2 && ismembre($_POST['login'])===false) { }else{ $err.=' Login utilisé ... ou ma + 2 cars'; } // on teste si le visiteur a soumis le formulaire if (empty($err) && isset($_POST['inscription']) && $_POST['inscription'] === 'Inscription') { //on insere et redirige conn(); $sql = 'INSERT INTO member VALUES("", "'.mysql_escape_string($_POST['login']).'", "'.mysql_escape_string(md5($_POST['pass'])).'", "'.mysql_escape_string($_POST['type']).'", "'.mysql_escape_string($_POST['name']).'", "'.mysql_escape_string($_POST['firstname']).'", "'.mysql_escape_string($_POST['birth_day']).'", "'.mysql_escape_string($_POST['birth_month']).'", "'.mysql_escape_string($_POST['birth_year']).'", "'.mysql_escape_string($_POST['address1']).'", "'.mysql_escape_string($_POST['address2']).'", "'.mysql_escape_string($_POST['job']).'", "'.mysql_escape_string($_POST['code_postal']).'", "'.mysql_escape_string($_POST['city']).'", "'.mysql_escape_string($_POST['state']).'", "'.mysql_escape_string($_POST['country']).'", "'.mysql_escape_string($_POST['email']).'", "'.mysql_escape_string($_POST['phone']).'", "'.mysql_escape_string($_POST['auction']).'", "'.mysql_escape_string($_POST['dream']).'", "'.mysql_escape_string($_POST['mobile']).'", "'.mysql_escape_string($_POST['skype']).'", "'.mysql_escape_string($_POST['msn']).'", "'.mysql_escape_string($_POST['newsletter']).'", "'.mysql_escape_string($_POST['ext']).'", "'.mysql_escape_string($_POST['karus']).'", "'.mysql_escape_string($_POST['sponsor']).'", "'.mysql_escape_string($_POST['comment']).'")'; mysql_query($sql) or die('Erreur SQL !'.$sql.' '.mysql_error()); mysql_close(); $_SESSION['login'] = $_POST['login']; header('Location: member.php');exit; }else{ echo $err; } ?> <html> <script src="/common/edel.js" type="text/javascript"></script> <link href="../common/edel.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 3px; margin-top: 5px; margin-right: 0px; margin-bottom: 0px; background-image: url(images/bg_8.jpg); } A:link {text-decoration: none;} A:visited {text-decoration: none; font-family: Verdana, Arial, Helvetica, sans-serif} A:active {text-decoration: none; color: dbdbdb; font-family: Verdana, Arial, Helvetica, sans-serif} A:hover {text-decoration: underline; color: dbdbdb; font-family: Verdana, Arial, Helvetica, sans-serif} --> </style> <head> <title>Inscription</title> </head> , ---- * * * I N S C R I P T I O N * * * <form action="" method="post"> <table width="600" border="0" cellspacing="15" cellpadding="0"> ----, <table width=\"700\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> ---- <fieldset> <legend align="top" class="bodyWhite11" > <?php echo ("Informations of login") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, </td> , , ---- <?php echo ("Login") ?>*, " tabindex="1">, , ---- <?php echo ("Password") ?>*, ">, <?php if (isset($erreur)) echo ' ',$erreur; ?>, ---- <?php echo ("Password confirm") ?>*, "> </fieldset></td> </tr> </table> <fieldset> <legend align="top" class="bodyWhite11" > <?php echo ("Questions") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, <?php echo (\"Gender\") ?></td> <?php echo ("woman") ?> <?php echo ("men") ?>, , ---- <?php echo ("Name") ?>, , , ---- <?php echo ("Firstname") ?>, , , ---- <?php echo ("Date of birth") ?>, <Select name="birth_day" class="body" tabindex="7"> <option selected value=""><?php echo ("Day") ?></option> <?php $i = 1; // initialisation de la variable de boucle while( $i < 32 ) { ?> <option value="<?php echo $i;?>"><?php echo $i?></option> <?php // affichage $i++; // incrémentation } ?> </select> / <select name="birth_month" class="body" tabindex="8"> <option selected value=""><?php echo ("month") ?></option> <?php $i = 1; // initialisation de la variable de boucle while( $i < 13 ) { ?> <option value="<?php echo $i;?>"><?php echo $i;?></option> <?php // affichage $i++; // incrémentation } ?> </select> / <select name="birth_year" class="body" tabindex="9"> <option selected value=""><?php echo ("year") ?></option> <?php $i = 1909; // initialisation de la variable de boucle while( $i <= Date("Y") ) { ?> <option value=<?php echo $i;?>><?php echo $i;?></option> <?php // affichage $i++; // incrémentation } ?> </select>, , ---- <?php echo ("Profession") ?>, , <?php if (isset($erreur)) echo ' ',$erreur; ?> , ---- <?php echo ("Address 1") ?>, , ---- <?php echo ("Address 2") ?>, , , ---- <?php echo ("Code ZIP/ City ") ?>, , , , ---- <?php echo ("State") ?>, , , ---- <?php echo ("Country") ?>, <select name="country" tabindex="16"> <optgroup label="Europe"> <option value="allemagne">Allemagne</option> <option value="albanie">Albanie</option> <option value="andorre">Andorre</option> <option value="autriche">Autriche</option> <option value="bielorussie">Biélorussie</option> <option value="belgique">Belgique</option> <option value="bosnieHerzegovine">Bosnie-Herzégovine</option> <option value="bulgarie">Bulgarie</option> <option value="croatie">Croatie</option> <option value="danemark">Danemark</option> <option value="espagne">Espagne</option> <option value="estonie">Estonie</option> <option value="finlande">Finlande</option> <option value="france" >France</option> <option value="grece">Grèce</option> <option value="hongrie">Hongrie</option> <option value="irlande">Irlande</option> <option value="islande">Islande</option> <option value="italie">Italie</option> <option value="lettonie">Lettonie</option> <option value="liechtenstein">Liechtenstein</option> <option value="lituanie">Lituanie</option> <option value="luxembourg">Luxembourg</option> <option value="exRepubliqueYougoslave">Ex-République Yougoslave</option> <option value="malte">Malte</option> <option value="moldavie">Moldavie</option> <option value="monaco">Monaco</option> <option value="norvege">Norvège</option> <option value="paysBas">Pays-Bas</option> <option value="pologne">Pologne</option> <option value="portugal">Portugal</option> <option value="roumanie">Roumanie</option> <option value="royaumeUni">Royaume-Uni</option> <option value="russie">Russie</option> <option value="saintMarin">Saint-Marin</option> <option value="serbieEtMontenegro">Serbie-et-Monténégro</option> <option value="slovaquie">Slovaquie</option> <option value="slovenie">Slovénie</option> <option value="suede">Suède</option> <option value="suisse">Suisse</option> <option value="republiqueTcheque">République Tchèque</option> <option value="ukraine">Ukraine</option> <option value="vatican">Vatican</option> </optgroup> <optgroup label="Amérique"> <option value="antiguaEtBarbuda">Antigua-et-Barbuda</option> <option value="argentine">Argentine</option> <option value="bahamas">Bahamas</option> <option value="barbade">Barbade</option> <option value="belize">Belize</option> <option value="bolivie">Bolivie</option> <option value="bresil">Brésil</option> <option value="canada">Canada</option> <option value="chili">Chili</option> <option value="colombie">Colombie</option> <option value="costaRica">Costa Rica</option> <option value="cuba">Cuba</option> <option value="republiqueDominicaine">République Dominicaine</option> <option value="dominique">Dominique</option> <option value="equateur">Équateur</option> <option value="etatsUnis" selected="selected">États Unis</option> <option value="grenade">Grenade</option> <option value="guatemala">Guatemala</option> <option value="guyana">Guyana</option> <option value="haiti">Haîti</option> <option value="honduras">Honduras</option> <option value="jamaique">Jamaîque</option> <option value="mexique">Mexique</option> <option value="nicaragua">Nicaragua</option> <option value="panama">Panama</option> <option value="paraguay">Paraguay</option> <option value="perou">Pérou</option> <option value="saintCristopheEtNieves">Saint-Cristophe-et-Niévès</option> <option value="sainteLucie">Sainte-Lucie</option> <option value="saintVincentEtLesGrenadines">Saint-Vincent-et-les-Grenadines</option> <option value="salvador">Salvador</option> <option value="suriname">Suriname</option> <option value="triniteEtTobago">Trinité-et-Tobago</option> <option value="uruguay">Uruguay</option> <option value="venezuela">Venezuela</option> </optgroup> <optgroup label="Afrique"> <option value="afriqueDuSud">Afrique Du Sud</option> <option value="algerie">Algérie</option> <option value="angola">Angola</option> <option value="benin">Bénin</option> <option value="botswana">Botswana</option> <option value="burkina">Burkina</option> <option value="burundi">Burundi</option> <option value="cameroun">Cameroun</option> <option value="capVert">Cap-Vert</option> <option value="republiqueCentre-Africaine">République Centre-Africaine</option> <option value="comores">Comores</option> <option value="republiqueDuCongo">République Du Congo</option> <option value="congo">Congo</option> <option value="coteIvoire">Côte d'Ivoire</option> <option value="djibouti">Djibouti</option> <option value="egypte">égypte</option> <option value="ethiopie">éthiopie</option> <option value="erythrée">érythrée</option> <option value="gabon">Gabon</option> <option value="gambie">Gambie</option> <option value="ghana">Ghana</option> <option value="guinee">Guinée</option> <option value="guinee-Bisseau">Guinée-Bisseau</option> <option value="kenya">Kenya</option> <option value="lesotho">Lesotho</option> <option value="liberia">Liberia</option> <option value="libye">Libye</option> <option value="madagascar">Madagascar</option> <option value="malawi">Malawi</option> <option value="mali">Mali</option> <option value="maroc">Maroc</option> <option value="maurice">Maurice</option> <option value="mauritanie">Mauritanie</option> <option value="mozambique">Mozambique</option> <option value="namibie">Namibie</option> <option value="niger">Niger</option> <option value="nigeria">Nigeria</option> <option value="ouganda">Ouganda</option> <option value="rwanda">Rwanda</option> <option value="saoTomeEtPrincipe">Sao Tomé-et-Principe</option> <option value="senegal">Séngal</option> <option value="seychelles">Seychelles</option> <option value="sierra">Sierra</option> <option value="somalie">Somalie</option> <option value="soudan">Soudan</option> <option value="swaziland">Swaziland</option> <option value="tanzanie">Tanzanie</option> <option value="tchad">Tchad</option> <option value="togo">Togo</option> <option value="tunisie">Tunisie</option> <option value="zambie">Zambie</option> <option value="zimbabwe">Zimbabwe</option> </optgroup> <optgroup label="Asie"> <option value="afghanistan">Afghanistan</option> <option value="arabieSaoudite">Arabie Saoudite</option> <option value="armenie">Arménie</option> <option value="azerbaidjan">Azerbaîdjan</option> <option value="bahrein">Bahreîn</option> <option value="bangladesh">Bangladesh</option> <option value="bhoutan">Bhoutan</option> <option value="birmanie">Birmanie</option> <option value="brunei">Brunéi</option> <option value="cambodge">Cambodge</option> <option value="chine">Chine</option> <option value="coreeDuSud">Corée Du Sud</option> <option value="coreeDuNord">Corée Du Nord</option> <option value="emiratsArabeUnis">émirats Arabe Unis</option> <option value="georgie">Géorgie</option> <option value="inde">Inde</option> <option value="indonesie">Indonésie</option> <option value="iraq">Iraq</option> <option value="iran">Iran</option> <option value="israel">Israël</option> <option value="japon">Japon</option> <option value="jordanie">Jordanie</option> <option value="kazakhstan">Kazakhstan</option> <option value="kirghistan">Kirghistan</option> <option value="koweit">Koweît</option> <option value="laos">Laos</option> <option value="liban">Liban</option> <option value="malaisie">Malaisie</option> <option value="maldives">Maldives</option> <option value="mongolie">Mongolie</option> <option value="nepal">Népal</option> <option value="oman">Oman</option> <option value="ouzbekistan">Ouzbékistan</option> <option value="pakistan">Pakistan</option> <option value="philippines">Philippines</option> <option value="qatar">Qatar</option> <option value="singapour">Singapour</option> <option value="sriLanka">Sri Lanka</option> <option value="syrie">Syrie</option> <option value="tadjikistan">Tadjikistan</option> <option value="taiwan">Taîwan</option> <option value="thailande">Thaîlande</option> <option value="timorOriental">Timor oriental</option> <option value="turkmenistan">Turkménistan</option> <option value="turquie">Turquie</option> <option value="vietNam">Viêt Nam</option> <option value="yemen">Yemen</option> </optgroup> <optgroup label="Océanie"> <option value="australie">Australie</option> <option value="fidji">Fidji</option> <option value="kiribati">Kiribati</option> <option value="marshall">Marshall</option> <option value="micronesie">Micronésie</option> <option value="nauru">Nauru</option> <option value="nouvelleZelande">Nouvelle-Zélande</option> <option value="palaos">Palaos</option> <option value="papouasieNouvelleGuinee">Papouasie-Nouvelle-Guinée</option> <option value="salomon">Salomon</option> <option value="samoa">Samoa</option> <option value="tonga">Tonga</option> <option value="tuvalu">Tuvalu</option> <option value="vanuatu">Vanuatu</option> </optgroup> </select> </fieldset></td> </tr> </table> <fieldset> <legend align="top" class="bodyWhite11" ><?php echo ("Communications") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, </td> , , ---- <?php echo ("Phone") ?>, , , ---- <?php echo ("Cellphone") ?>, , <?php if (isset($erreur)) echo ' ',$erreur; ?>, ---- <?php echo ("Email") ?>*, " tabindex="20">, ---- <?php echo ("Votre Skype ID") ?>, </fieldset></td> </tr> </table> <fieldset> <legend align="top" class="bodyWhite11" ><?php echo ("Questions") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, </td> , , ---- <?php echo ("Question 1") ?>*, <textarea name="question1" cols="37" rows="3" wrap="VIRTUAL" class="body" tabindex="18"></textarea>, <?php echo ("example, ...") ?>, ---- <?php echo ("Question 2") ?>*, <textarea name="question2" cols="37" rows="3" wrap="VIRTUAL" class="body" tabindex="19"></textarea>, , ---- <?php echo ("Question 3") ?>, <?php echo ("Yes") ?> <?php echo ("NO") ?>, , ---- <?php echo ("Question 4 ") ?>, <?php echo ("Yes") ?> <?php echo ("No") ?>, , ---- <?php echo ("Question 5") ?>, , , ---- <?php echo ("Comment") ?>, <textarea name="comment" cols="37" rows="5" wrap="VIRTUAL" class="body" tabindex="25"></textarea>, </fieldset></td> </tr> </table> </td> </tr> </table></form></td> </tr> </table> </html>
<html> <script src="/common/edel.js" type="text/javascript"></script> <link href="../common/edel.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 3px; margin-top: 5px; margin-right: 0px; margin-bottom: 0px; background-image: url(images/bg_8.jpg); } A:link {text-decoration: none;} A:visited {text-decoration: none; font-family: Verdana, Arial, Helvetica, sans-serif} A:active {text-decoration: none; color: dbdbdb; font-family: Verdana, Arial, Helvetica, sans-serif} A:hover {text-decoration: underline; color: dbdbdb; font-family: Verdana, Arial, Helvetica, sans-serif} --> </style> <head> <center> <title>Inscription</title> </head> , ---- * * * I N S C R I P T I O N * * * <form action="inscription.php" method="post"> <table width="600" border="0" cellspacing="15" cellpadding="0"> ----, <table width=\"700\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> ---- <fieldset> <legend align="top" class="bodyWhite11" > <?php echo ("Informations of login") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, </td> , , ---- <?php echo ("Login") ?>*, " tabindex="1">, , ---- <?php echo ("Password") ?>*, ">, <?php if (isset($erreur)) echo ' ',$erreur; ?>, ---- <?php echo ("Password confirm") ?>*, "> </fieldset></td> </tr> </table> <fieldset> <legend align="top" class="bodyWhite11" > <?php echo ("Questions") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, <?php echo (\"Gender\") ?></td> <?php echo ("woman") ?> <?php echo ("men") ?>, , ---- <?php echo ("Name") ?>, , , ---- <?php echo ("Firstname") ?>, , , ---- <?php echo ("Date of birth") ?>, <Select name="birth_day" class="body" tabindex="7"> <option selected value=""><?php echo ("Day") ?></option> <?php $i = 1; // initialisation de la variable de boucle while( $i < 32 ) { ?> <option value="<?php echo $i;?>"><?php echo $i?></option> <?php // affichage $i++; // incrémentation } ?> </select> / <select name="birth_month" class="body" tabindex="8"> <option selected value=""><?php echo ("month") ?></option> <?php $i = 1; // initialisation de la variable de boucle while( $i < 13 ) { ?> <option value="<?php echo $i;?>"><?php echo $i;?></option> <?php // affichage $i++; // incrémentation } ?> </select> / <select name="birth_year" class="body" tabindex="9"> <option selected value=""><?php echo ("year") ?></option> <?php $i = 1909; // initialisation de la variable de boucle while( $i <= Date("Y") ) { ?> <option value=<?php echo $i;?>><?php echo $i;?></option> <?php // affichage $i++; // incrémentation } ?> </select>, , ---- <?php echo ("Profession") ?>, , <?php if (isset($erreur)) echo ' ',$erreur; ?> , ---- <?php echo ("Address 1") ?>, , ---- <?php echo ("Address 2") ?>, , , ---- <?php echo ("Code ZIP/ City ") ?>, , , , ---- <?php echo ("State") ?>, , , ---- <?php echo ("Country") ?>, <select name="country" tabindex="16"> <optgroup label="Europe"> <option value="allemagne">Allemagne</option> <option value="albanie">Albanie</option> <option value="andorre">Andorre</option> <option value="autriche">Autriche</option> <option value="bielorussie">Biélorussie</option> <option value="belgique">Belgique</option> <option value="bosnieHerzegovine">Bosnie-Herzégovine</option> <option value="bulgarie">Bulgarie</option> <option value="croatie">Croatie</option> <option value="danemark">Danemark</option> <option value="espagne">Espagne</option> <option value="estonie">Estonie</option> <option value="finlande">Finlande</option> <option value="france" >France</option> <option value="grece">Grèce</option> <option value="hongrie">Hongrie</option> <option value="irlande">Irlande</option> <option value="islande">Islande</option> <option value="italie">Italie</option> <option value="lettonie">Lettonie</option> <option value="liechtenstein">Liechtenstein</option> <option value="lituanie">Lituanie</option> <option value="luxembourg">Luxembourg</option> <option value="exRepubliqueYougoslave">Ex-République Yougoslave</option> <option value="malte">Malte</option> <option value="moldavie">Moldavie</option> <option value="monaco">Monaco</option> <option value="norvege">Norvège</option> <option value="paysBas">Pays-Bas</option> <option value="pologne">Pologne</option> <option value="portugal">Portugal</option> <option value="roumanie">Roumanie</option> <option value="royaumeUni">Royaume-Uni</option> <option value="russie">Russie</option> <option value="saintMarin">Saint-Marin</option> <option value="serbieEtMontenegro">Serbie-et-Monténégro</option> <option value="slovaquie">Slovaquie</option> <option value="slovenie">Slovénie</option> <option value="suede">Suède</option> <option value="suisse">Suisse</option> <option value="republiqueTcheque">République Tchèque</option> <option value="ukraine">Ukraine</option> <option value="vatican">Vatican</option> </optgroup> <optgroup label="Amérique"> <option value="antiguaEtBarbuda">Antigua-et-Barbuda</option> <option value="argentine">Argentine</option> <option value="bahamas">Bahamas</option> <option value="barbade">Barbade</option> <option value="belize">Belize</option> <option value="bolivie">Bolivie</option> <option value="bresil">Brésil</option> <option value="canada">Canada</option> <option value="chili">Chili</option> <option value="colombie">Colombie</option> <option value="costaRica">Costa Rica</option> <option value="cuba">Cuba</option> <option value="republiqueDominicaine">République Dominicaine</option> <option value="dominique">Dominique</option> <option value="equateur">Équateur</option> <option value="etatsUnis" selected="selected">États Unis</option> <option value="grenade">Grenade</option> <option value="guatemala">Guatemala</option> <option value="guyana">Guyana</option> <option value="haiti">Haîti</option> <option value="honduras">Honduras</option> <option value="jamaique">Jamaîque</option> <option value="mexique">Mexique</option> <option value="nicaragua">Nicaragua</option> <option value="panama">Panama</option> <option value="paraguay">Paraguay</option> <option value="perou">Pérou</option> <option value="saintCristopheEtNieves">Saint-Cristophe-et-Niévès</option> <option value="sainteLucie">Sainte-Lucie</option> <option value="saintVincentEtLesGrenadines">Saint-Vincent-et-les-Grenadines</option> <option value="salvador">Salvador</option> <option value="suriname">Suriname</option> <option value="triniteEtTobago">Trinité-et-Tobago</option> <option value="uruguay">Uruguay</option> <option value="venezuela">Venezuela</option> </optgroup> <optgroup label="Afrique"> <option value="afriqueDuSud">Afrique Du Sud</option> <option value="algerie">Algérie</option> <option value="angola">Angola</option> <option value="benin">Bénin</option> <option value="botswana">Botswana</option> <option value="burkina">Burkina</option> <option value="burundi">Burundi</option> <option value="cameroun">Cameroun</option> <option value="capVert">Cap-Vert</option> <option value="republiqueCentre-Africaine">République Centre-Africaine</option> <option value="comores">Comores</option> <option value="republiqueDuCongo">République Du Congo</option> <option value="congo">Congo</option> <option value="coteIvoire">Côte d'Ivoire</option> <option value="djibouti">Djibouti</option> <option value="egypte">égypte</option> <option value="ethiopie">éthiopie</option> <option value="erythrée">érythrée</option> <option value="gabon">Gabon</option> <option value="gambie">Gambie</option> <option value="ghana">Ghana</option> <option value="guinee">Guinée</option> <option value="guinee-Bisseau">Guinée-Bisseau</option> <option value="kenya">Kenya</option> <option value="lesotho">Lesotho</option> <option value="liberia">Liberia</option> <option value="libye">Libye</option> <option value="madagascar">Madagascar</option> <option value="malawi">Malawi</option> <option value="mali">Mali</option> <option value="maroc">Maroc</option> <option value="maurice">Maurice</option> <option value="mauritanie">Mauritanie</option> <option value="mozambique">Mozambique</option> <option value="namibie">Namibie</option> <option value="niger">Niger</option> <option value="nigeria">Nigeria</option> <option value="ouganda">Ouganda</option> <option value="rwanda">Rwanda</option> <option value="saoTomeEtPrincipe">Sao Tomé-et-Principe</option> <option value="senegal">Séngal</option> <option value="seychelles">Seychelles</option> <option value="sierra">Sierra</option> <option value="somalie">Somalie</option> <option value="soudan">Soudan</option> <option value="swaziland">Swaziland</option> <option value="tanzanie">Tanzanie</option> <option value="tchad">Tchad</option> <option value="togo">Togo</option> <option value="tunisie">Tunisie</option> <option value="zambie">Zambie</option> <option value="zimbabwe">Zimbabwe</option> </optgroup> <optgroup label="Asie"> <option value="afghanistan">Afghanistan</option> <option value="arabieSaoudite">Arabie Saoudite</option> <option value="armenie">Arménie</option> <option value="azerbaidjan">Azerbaîdjan</option> <option value="bahrein">Bahreîn</option> <option value="bangladesh">Bangladesh</option> <option value="bhoutan">Bhoutan</option> <option value="birmanie">Birmanie</option> <option value="brunei">Brunéi</option> <option value="cambodge">Cambodge</option> <option value="chine">Chine</option> <option value="coreeDuSud">Corée Du Sud</option> <option value="coreeDuNord">Corée Du Nord</option> <option value="emiratsArabeUnis">émirats Arabe Unis</option> <option value="georgie">Géorgie</option> <option value="inde">Inde</option> <option value="indonesie">Indonésie</option> <option value="iraq">Iraq</option> <option value="iran">Iran</option> <option value="israel">Israël</option> <option value="japon">Japon</option> <option value="jordanie">Jordanie</option> <option value="kazakhstan">Kazakhstan</option> <option value="kirghistan">Kirghistan</option> <option value="koweit">Koweît</option> <option value="laos">Laos</option> <option value="liban">Liban</option> <option value="malaisie">Malaisie</option> <option value="maldives">Maldives</option> <option value="mongolie">Mongolie</option> <option value="nepal">Népal</option> <option value="oman">Oman</option> <option value="ouzbekistan">Ouzbékistan</option> <option value="pakistan">Pakistan</option> <option value="philippines">Philippines</option> <option value="qatar">Qatar</option> <option value="singapour">Singapour</option> <option value="sriLanka">Sri Lanka</option> <option value="syrie">Syrie</option> <option value="tadjikistan">Tadjikistan</option> <option value="taiwan">Taîwan</option> <option value="thailande">Thaîlande</option> <option value="timorOriental">Timor oriental</option> <option value="turkmenistan">Turkménistan</option> <option value="turquie">Turquie</option> <option value="vietNam">Viêt Nam</option> <option value="yemen">Yemen</option> </optgroup> <optgroup label="Océanie"> <option value="australie">Australie</option> <option value="fidji">Fidji</option> <option value="kiribati">Kiribati</option> <option value="marshall">Marshall</option> <option value="micronesie">Micronésie</option> <option value="nauru">Nauru</option> <option value="nouvelleZelande">Nouvelle-Zélande</option> <option value="palaos">Palaos</option> <option value="papouasieNouvelleGuinee">Papouasie-Nouvelle-Guinée</option> <option value="salomon">Salomon</option> <option value="samoa">Samoa</option> <option value="tonga">Tonga</option> <option value="tuvalu">Tuvalu</option> <option value="vanuatu">Vanuatu</option> </optgroup> </select> </fieldset></td> </tr> </table> <fieldset> <legend align="top" class="bodyWhite11" ><?php echo ("Communications") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, </td> , , ---- <?php echo ("Phone") ?>, , , ---- <?php echo ("Cellphone") ?>, , <?php if (isset($erreur)) echo ' ',$erreur; ?>, ---- <?php echo ("Email") ?>*, " tabindex="20">, ---- <?php echo ("Votre Skype ID") ?>, </fieldset></td> </tr> </table> <fieldset> <legend align="top" class="bodyWhite11" ><?php echo ("Questions") ?></legend> <table width="600" border="0" cellspacing="0" cellpadding="0"> ----, </td> , , ---- <?php echo ("Question 1") ?>*, <textarea name="question1" cols="37" rows="3" wrap="VIRTUAL" class="body" tabindex="18"></textarea>, <?php echo ("example, ...") ?>, ---- <?php echo ("Question 2") ?>*, <textarea name="question2" cols="37" rows="3" wrap="VIRTUAL" class="body" tabindex="19"></textarea>, , ---- <?php echo ("Question 3") ?>, <?php echo ("Yes") ?> <?php echo ("NO") ?>, , ---- <?php echo ("Question 4 ") ?>, <?php echo ("Yes") ?> <?php echo ("No") ?>, , ---- <?php echo ("Question 5") ?>, , , ---- <?php echo ("Comment") ?>, <textarea name="comment" cols="37" rows="5" wrap="VIRTUAL" class="body" tabindex="25"></textarea>, </fieldset></td> </tr> </table> </td> </tr> </table></form></td> </tr> </table> </center> </html>
<?php session_start(); /*ici le session_start(); toujours en haut du fichier*/ $err = null; /*au depart*/ //echo ''; //print_r($_POST); //echo ' '; /*petit filtre pas du luxe */ foreach($_POST as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_POST[$k]=$v; } foreach($_GET as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_GET[$k]=$v; } foreach($_REQUEST as $k => $v){ $v = htmlentities(strip_tags(trim($v))); $_REQUEST[$k]=$v; } /*fin filtre*/ function conn(){ mysql_connect('localhost','root',''); mysql_select_db('mydb'); } function checkmail($mail){ if(preg_match('#^(([a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+\.?)*[a-z0-9!\#$%&\\\'*+/=?^_`{|}~-]+)@(([a-z0-9-_]+\.?)*[a-z0-9-_]+)\.[a-z]{2,}$#i',$_POST['email'])){ return true; }else{ return false; } } function ismembre($login){ conn(); $log=mysql_real_escape_string($login); // on recherche si ce login est déjà utilisé par un autre membre $sql = "SELECT id FROM member WHERE login='".$log."' limit 1"; $req = mysql_query($sql) or die('Erreur SQL ! '.$sql.' '.mysql_error()); if(mysql_fetch_row($req)===1){ return true; }else{ return false; } mysql_close(); } /*les tests*/ // on teste l'existence de nos variables. On teste également si elles ne sont pas vides if(isset($_POST['login']) && !empty($_POST['login'])) { } else {$err.=' err login';} if(isset($_POST['pass']) && !empty($_POST['pass'])) { } else {$err.=' err pass';} if(isset($_POST['pass_confirm']) && !empty($_POST['pass_confirm'])) { } else {$err.=' err pass_confirm';} if (isset($_POST['pass'],$_POST['pass_confirm']) && $_POST['pass'] === $_POST['pass_confirm']) { } else {$err.=' pass diff confirm';} if(isset($_POST['email']) && !empty($_POST['email'])) { if(checkmail($_POST['email'])===true) { }else{ $err.=' err check syntaxe mail'; } }else {$err.=' err email';} if(isset($_POST['auction']) && !empty($_POST['auction'])) { } else {$err.=' err auction';} if(isset($_POST['dream']) && !empty($_POST['dream'])) { } else {$err.=' err dream';} if(isset($_POST['login']) && strlen($_POST['login'])>2 && ismembre($_POST['login'])===false) { }else{ $err.=' Login utilisé ... ou ma + 2 cars'; } // on teste si le visiteur a soumis le formulaire if (empty($err) && isset($_POST['inscription']) && $_POST['inscription'] === 'Inscription') { //on insere et redirige conn(); $sql = 'INSERT INTO member VALUES("", "'.mysql_escape_string($_POST['login']).'", "'.mysql_escape_string(md5($_POST['pass'])).'", "'.mysql_escape_string($_POST['type']).'", "'.mysql_escape_string($_POST['name']).'", "'.mysql_escape_string($_POST['firstname']).'", "'.mysql_escape_string($_POST['birth_day']).'", "'.mysql_escape_string($_POST['birth_month']).'", "'.mysql_escape_string($_POST['birth_year']).'", "'.mysql_escape_string($_POST['address1']).'", "'.mysql_escape_string($_POST['address2']).'", "'.mysql_escape_string($_POST['job']).'", "'.mysql_escape_string($_POST['code_postal']).'", "'.mysql_escape_string($_POST['city']).'", "'.mysql_escape_string($_POST['state']).'", "'.mysql_escape_string($_POST['country']).'", "'.mysql_escape_string($_POST['email']).'", "'.mysql_escape_string($_POST['phone']).'", "'.mysql_escape_string($_POST['auction']).'", "'.mysql_escape_string($_POST['dream']).'", "'.mysql_escape_string($_POST['mobile']).'", "'.mysql_escape_string($_POST['skype']).'", "'.mysql_escape_string($_POST['msn']).'", "'.mysql_escape_string($_POST['newsletter']).'", "'.mysql_escape_string($_POST['ext']).'", "'.mysql_escape_string($_POST['karus']).'", "'.mysql_escape_string($_POST['sponsor']).'", "'.mysql_escape_string($_POST['comment']).'")'; mysql_query($sql) or die('Erreur SQL !'.$sql.' '.mysql_error()); mysql_close(); $_SESSION['login'] = $_POST['login']; header('Location: member.php');exit; }else{ echo '<center> '.$err; echo '<hr>[ [javascript:history.back(); RETOUR AU FORMULAIRE] ] </center>'; }