Salut a tous,
S.V.P quelqu'un m'aide à trouver la faute dans ce code SVP
<script langage="javascript">
function verifier(){
if(document.formulaire.num.value == "" || isNaN(document.formulaire.num.value) ||
document.formulaire.num.value.length!=7) {
alert("Veuillez entrer un Nmero d'inscri valide ...");
document.formulaire.num.value =""
document.formulaire.num.focus();
return false;
}
}
</script>
<form action="inscri.php" method="POST" name="formulaire" onSubmit="return verifier()"
>
Nom :
<div style="width:100px; padding: 0px 0px 0px 37px; font-weight:bold">
<input name="nom" type="text" class="a_field" style="width:200px" />
</div>
Prénom:
<div style="width:100px; padding: 0px 0px 0px 37px; font-weight:bold">
<input name="prenom" type="text" class="a_field" style="width:200px" />
</div>
<div>
Adresse Mail:
</div>
<div style="width:100px; padding: 0px 0px 0px 37px; font-weight:bold">
<input name="mail" type="text" class="a_field" style="width:200px" />
</div>
N° Inscription:
<div style="width:100px; padding: 0px 0px 0px 37px; font-weight:bold">
<input name="num" type="text" class="a_field" style="width:100px" />
</div>
Password:
<div style="width:100px; padding: 0px 0px 0px 37px; font-weight:bold">
<input name="password" type="password" class="a_field" style="width:100px" />
</div>
<p> vous êtes en
<SELECT NAME="classe">
<OPTION VALUE=1> premiére
<OPTION VALUE=2 selected> dexiéme
<OPTION VALUE=3> troisiéme
</SELECT>
<SELECT NAME="section">
<OPTION VALUE=1> Telecom
<OPTION VALUE=2 selected> Réseau Informatique
<OPTION VALUE=3> Multimedia
</SELECT>
</p>
<br>
<DL>
<DT> Quel Semestre ? <br>
<DD> <I> <INPUT TYPE=CHECKBOX NAME= semestre VALUE="semestre1"> Semestre 1<br></I>
<DD> <I> <INPUT TYPE=CHECKBOX NAME=semestre VALUE="semestre2">Semestre 2<br></I>
</DL>
<br>
Dans quel niveau?<br>
<INPUT TYPE=RADIO NAME=niveau VALUE="L"> License
<INPUT TYPE=RADIO NAME=niveau VALUE="M"> Mastére
<INPUT TYPE=RADIO NAME=niveau VALUE="I"> Ingénieura
<p> <INPUT NAME="send" TYPE="submit" VALUE="Valider" >
</div>
<br /><br />
</form>
//**************************
<?php
$cnx = mysql_connect("localhost","root","") or die("Unable to connect to database");
mysql_select_db("sitebd") or die( "Unable to select database");
$NOM='';
if (isset($_POST["nom"])) {$NOM=$_POST["nom"]; }
$PRENOM='';
if (isset($_POST["prenom"])) {$PRENOM=$_POST["prenom"];}
$MAIL='';
if (isset($_POST["mail"])) {$MAIL=$_POST["mail"];}
$NUM='';
if (isset($_POST["num"])) {$NUM=$_POST["num"];}
$PASSSWORD='';
if (isset($_POST["password"])) {$PASSSWORD=$_POST["password"];}
$CLASSE='';
if (isset($_POST["classe"])) {$CLASSE=$_POST["classe"];}
$SECTION='';
if (isset($_POST["section"])) {$SECTION=$_POST["section"];}
$SEMESTRE='';
if (isset($_POST["semestre"])) {$SEMESTRE=$_POST["semestre"];}
?>
<?php
mysql_connect("localhost","root","") or die("Unable to connect to database");
mysql_select_db("sitebd") or die( "Unable to select database");
$query_Recordset1="SELECT NumInscr FROM etudiant WHERE NumInscr='$NUM' ";
$Recordset1 = mysql_query($query_Recordset1) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
if ($totalRows_Recordset1 >=1)
{echo "Le Numero d-inscription saisit existe déjà dans la base de donnée ..."; }
else
{
if(empty($NUM) OR empty($NOM) OR empty($PRENOM) OR empty($PASSWORD) OR empty($NIVEAU) OR
empty($SECTION))
{
echo 'Veuillez remplir les champs: NumInscri, Nom, Prénom, password, niveau, section';
}
else
{
$sql1 = "INSERT INTO etudiant (Nom, Prenom, NumInscr, niveau, section, mail, password, classe, semestre)
VALUES( '$NOM', '$PRENOM', '$NUM', '$NIVEAU', '$SECTION', '$MAIL', '$PASSWORD', '$CLASSE',
'$SEMESTRE') ";
$sql2 = "INSERT INTO authentification(login, pwd) VALUES ('$NUM','$PASSWORD')";
$requete = mysql_query($sql1) or die('Erreur SQL !'.$sql1.'<br>'.mysql_error());
mysql_query($sql2) or die('Erreur SQL !'.$sql2.'<br>'.mysql_error());
if($requete)
{
echo("L'insertion a été correctement effectuée") ;
}
else
{
echo("L'insertion à échouée") ;
}
mysql_close();
}
}
?>
<p>
<?php
mysql_free_result($Recordset1);
?>
pourquoi rien ne s'ajoute a la base de donnée??
<3