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
|
$ajoutIdIngredient1 = mysql_query ("select IdIngredient from ingredient where nom = '$ingredient1'");
$ajoutIdIngredient2 = mysql_query ("select IdIngredient from ingredient where nom = '$ingredient2'");
$ajoutIdIngredient3 = mysql_query ("select IdIngredient from ingredient where nom = '$ingredient3'");
$ajoutIdIngredient4 = mysql_query ("select IdIngredient from ingredient where nom = '$ingredient4'");
$ajoutIdIngredient5 = mysql_query ("select IdIngredient from ingredient where nom = '$ingredient5'");
// Permet de récupérer l'ID du nom de la recette
if ( mysql_num_rows($ajoutnom) ) {
$row = mysql_fetch_row ($ajoutnom);}
if (mysql_num_rows($ajoutIdIngredient1)){
$data1 = mysql_fetch_row($ajoutIdIngredient1);}
if (mysql_num_rows($ajoutIdIngredient2)){
$data2 = mysql_fetch_row($ajoutIdIngredient2);}
if (mysql_num_rows($ajoutIdIngredient3)){
$data3 = mysql_fetch_row($ajoutIdIngredient3);}
if (mysql_num_rows($ajoutIdIngredient4)){
$data4 = mysql_fetch_row($ajoutIdIngredient4);}
if (mysql_num_rows($ajoutIdIngredient5)){
$data5 = mysql_fetch_row($ajoutIdIngredient5);}
mysql_query("INSERT INTO IngredientRecette (IdRecette, IdIngredient1, Qte1, IdIngredient2, Qte2, IdIngredient3, Qte3, IdIngredient4, Qte4, IdIngredient5, Qte5) VALUES (('$row[0]'), ('$data1[0]'),'$qte1',('$data2[0]'),'$qte2',('$data3[0]'),'$qte3',('$data4[0]'),'$qte4',('$data5[0]'),'$qte5')") or die (mysql_error()); |
Partager