EL.marwaa123
Messages postés99Date d'inscriptionjeudi 24 avril 2014StatutMembreDernière intervention 7 juin 2014
-
Modifié par mounana199 le 16/05/2014 à 11:49
EL.marwaa123
Messages postés99Date d'inscriptionjeudi 24 avril 2014StatutMembreDernière intervention 7 juin 2014
-
16 mai 2014 à 13:09
Bonjour,
j'ai un prob concernant une variable.voila le code:
if(isset($_POST['creer'])){
if ($modu&&$seuil&&$br&&$ann){
$sql=mysql_query("INSERT INTO module VALUES ('','$modu','$seuil')");
$sqlm=mysql_query("select idM from module where nomM='$modu'");
<gras>$a=mysql_result($sqlm,0);</gras>
$dep=mysql_query("select idD from departement where nomD='$br' && annee='$ann'");
$b=mysql_result($dep,0);
$sql1=mysql_query("INSERT INTO contenir VALUES ('$a','$b')");
echo "<script> alert('la compte a été bien créer veuilez cliquer sur suivant pour créer les sous modules');
document.getElementById('Buon1').disabled ='true';
document.getElementById('Buon2').style.visibility='visible';
</script>";
}
else echo "<script>alert('Remplir tous les champs svp !')</script>";
}
if(isset($_POST['valider'])){
switch($nb){
case 1:
$sql1=mysql_query("INSERT INTO smodule VALUES ('','$sm1','$s1','$coef1')");
$req1=mysql_query("select idS from smodule where nomS='$sm1'");
$vl1=mysql_result($req1,0);
$sql1=mysql_query("INSERT INTO composer VALUES ('$a','$vl1')");
echo "<script>alert('vous avez crée un sous module!')</script>";
break;
case 2:
$sql1=mysql_query("INSERT INTO smodule VALUES ('','$sm1','$s1','$coef1')");
$req1=mysql_query("select idS from smodule where nomS='$sm1'");
$vl1=mysql_result($req1,0);
$sql1=mysql_query("INSERT INTO composer VALUES ('$a','$vl1')");
$sql2=mysql_query("INSERT INTO smodule VALUES ('','$sm2','$s2','$coef2')");
$req2=mysql_query("select idS from smodule where nomS='$sm2'");
$vl2=mysql_result($req2,0);
$sql2=mysql_query("INSERT INTO composer VALUES ('$a','$vl2')");
echo "<script>alert('vous avez crée deux sous modules!')</script>";
break;
case 3:
$sql1=mysql_query("INSERT INTO smodule VALUES ('','$sm1','$s1','$coef1')");
$req1=mysql_query("select idS from smodule where nomS='$sm1'");
$vl1=mysql_result($req1,0);
$sql1=mysql_query("INSERT INTO composer VALUES ('$a','$vl1')");
$sql2=mysql_query("INSERT INTO smodule VALUES ('','$sm2','$s2','$coef2')");
$req2=mysql_query("select idS from smodule where nomS='$sm2'");
$vl2=mysql_result($req2,0);
$sql2=mysql_query("INSERT INTO composer VALUES ('$a','$vl2')");
$sql3=mysql_query("INSERT INTO smodule VALUES ('','$sm3','$s3','$coef3')");
$req3=mysql_query("select idS from smodule where nomS='$SM3'");
$vl3=mysql_result($req3,0);
$sql3=mysql_query("INSERT INTO composer VALUES ('$a','$vl3')");
echo "<script>alert('vous avez crée troix sous modules!')</script>";
break;
case 4:
$sql1=mysql_query("INSERT INTO smodule VALUES ('','$sm1','$s1','$coef1')");
$req1=mysql_query("select idS from smodule where nomS='$sm1'");
$vl=mysql_result($req1,0);
$sql1=mysql_query("INSERT INTO composer VALUES ('$a','$vl')");
$sql2=mysql_query("INSERT INTO smodule VALUES ('','$sm2','$s2','$coef2')");
$req2=mysql_query("select idS from smodule where nomS='$sm2'");
$vl2=mysql_result($req2,0);
$sql2=mysql_query("INSERT INTO composer VALUES ('$a','$vl2')");
$sql3=mysql_query("INSERT INTO smodule VALUES ('','$sm3','$s3','$coef3')");
$req3=mysql_query("select idS from smodule where nomS='$SM3'");
$vl3=mysql_result($req3,0);
$sql3=mysql_query("INSERT INTO composer VALUES ('$a','$vl3')");
$sql4=mysql_query("INSERT INTO smodule VALUES ('','$sm4','$s4','$coef4')");
$req4=mysql_query("select idS from smodule where nomS='$sm4'");
$vl4=mysql_result($req4,0);
$sql4=mysql_query("INSERT INTO composer VALUES ('$a','$vl4')");
echo "<script>alert('vous avez crée quatre sous modules!')</script>";
break;
case 5:
$sql1=mysql_query("INSERT INTO smodule VALUES ('','$sm1','$s1','$coef1')");
$req1=mysql_query("select idS from smodule where nomS='$sm1'");
$vl=mysql_result($req1,0);
$sql1=mysql_query("INSERT INTO composer VALUES ('$a','$vl')");
$sql2=mysql_query("INSERT INTO smodule VALUES ('','$sm2','$s2','$coef2')");
$req2=mysql_query("select idS from smodule where nomS='$sm2'");
$vl2=mysql_result($req2,0);
$sql2=mysql_query("INSERT INTO composer VALUES ('$a','$vl2')");
$sql3=mysql_query("INSERT INTO smodule VALUES ('','$sm3','$s3','$coef3')");
$req3=mysql_query("select idS from smodule where nomS='$SM3'");
$vl3=mysql_result($req3,0);
$sql3=mysql_query("INSERT INTO composer VALUES ('$a','$vl3')");
$sql4=mysql_query("INSERT INTO smodule VALUES ('','$sm4','$s4','$coef4')");
$req4=mysql_query("select idS from smodule where nomS='$sm4'");
$vl4=mysql_result($req4,0);
$sql4=mysql_query("INSERT INTO composer VALUES ('$a','$vl4')");
$sql5=mysql_query("INSERT INTO smodule VALUES ('','$sm5','$s5','$coef5')");
$req5=mysql_query("select idS from smodule where nomS='$sm5'");
$vl5=mysql_result($req5,0);
$sql5=mysql_query("INSERT INTO composer VALUES ('$a','$vl5')");
echo "<script>alert('vous avez crée cinq sous modules!')</script>";
break;
default:
echo "alert('un probleme qlq part s'est produit!')</script>";
}
}
mysql_close();
?>
je veux que la variable 'a' utiliser en cliquant sur le bouton 'creer' soit récupérer dans le bloc de bouton valider pour lui affecter dans une requete sql. pouvez-vous indiquer une méthode? merci d'avance
A voir également:
Affecter une valeur déja utiliser à une variable en php
<?Php
// A mettre en début de tes pages PHP:
session_start();
//-----------------
if(isset($_POST['creer'])){
if ($modu&&$seuil&&$br&&$ann){
$sql=mysql_query("INSERT INTO module VALUES ('','$modu','$seuil')");
$sqlm=mysql_query("select idM from module where nomM='$modu'");
$a=mysql_result($sqlm,0);
$_SESSION['mavariableA'] = $a;
$dep=mysql_query("select idD from departement where nomD='$br' && annee='$ann'");
$b=mysql_result($dep,0);
$sql1=mysql_query("INSERT INTO contenir VALUES ('$a','$b')");
echo "<script>
alert('la compte a été bien créer veuilez cliquer sur suivant pour créer les sous modules');
document.getElementById('Buon1').disabled ='true';
document.getElementById('Buon2').style.visibility='visible';
</script>";
}
else{
echo "<script>alert('Remplir tous les champs svp !')</script>";
}
if(isset($_POST['valider'])){
$a = $_SESSION['mavariableA'];
switch($nb){
case 1:
$sql1=mysql_query("INSERT INTO smodule VALUES ('','$sm1','$s1','$coef1')");
$req1=mysql_query("select idS from smodule where nomS='$sm1'");
$vl1=mysql_result($req1,0);
$sql1=mysql_query("INSERT INTO composer VALUES ('$a','$vl1')");
echo "<script>alert('vous avez crée un sous module!')</script>";
break;
// Le reste de ton code ...
// ...