[blackcoder00]

i have some trouble when i insert values into database the record repeats himself how can i avoid this problem guys
and thank alot
ps:i spend one week thinking and searching how to avoid this trouble without result

PHP Code


<?php 
$sql="SELECT name FROM ingredient";
     $result=mysqli_query($conn,$sql);
   /* if (!$result) {
    printf("Error: %s\n", mysqli_error($conn));
    exit();
}*/
echo"<select name='cars[]' id='cars' multiple >";
    
    while($row=mysqli_fetch_assoc($result))
        {
            foreach ($row as $key => $okhrej) {              
               
                 echo"<option value=".$okhrej.">".$okhrej."</option>"; 

                 
            }
            
        }   

 echo"</select>";


  $sql1="SELECT name FROM ingredient";
     $result1=mysqli_query($conn,$sql1);
       while($row1=mysqli_fetch_assoc($result1))
        {
            foreach ($row1 as $key1 => $okhrej1) {              
               
                 echo "<input name='ingsave[]' >";

                 
            }
            
        }   
    mysqli_close($conn); 


PHP Code


<?php 
$selectop = $_POST['cars'];
$name = $_POST['nom'];
$prix = $_POST['prix'];
$prixn = $_POST['prix-neut'];
$savesplease = $_POST['ingsave'];
if(!empty($_POST['cars'])){
foreach ($selectop as $key ) {
    foreach ($savesplease as $key1 ) {
         mysqli_query($conn,"INSERT INTO coffe VALUES ('$key','$name','$prix','$prixn','$key1')");
        }
 }


echo "New record created successfully";
}
 else {
  echo "_error_: " . $sql . "<br>" . mysqli_error($conn);
} 


[BadLandChugs]

i have some trouble when i insert values into database the record repeats himself how can i avoid this problem guys
and thank alot
ps:i spend one week thinking and searching how to avoid this trouble without result

PHP Code


<?php 
  $sql="SELECT name FROM ingredient";
     $result=mysqli_query($conn,$sql);
   /* if (!$result) {
    printf("_error_: %s\n", mysqli_error($conn));
    exit();
}*/
echo"<select name='cars[]' id='cars' multiple >";
 
    while($row=mysqli_fetch_assoc($result))
        {
            foreach ($row as $key => $okhrej) {           
               
                 echo"<option value=".$okhrej.">".$okhrej."</option>"; 

                 
            }
            
        }   

 echo"</select>";


  $sql1="SELECT name FROM ingredient";
     $result1=mysqli_query($conn,$sql1);
       while($row1=mysqli_fetch_assoc($result1))
        {
            foreach ($row1 as $key1 => $okhrej1) {           
               
                 echo "<input name='ingsave[]' >";

                 
            }
            
        }   
    mysqli_close($conn); 


PHP Code


<?php 
$selectop = $_POST['cars'];
$name = $_POST['nom'];
$prix = $_POST['prix'];
$prixn = $_POST['prix-neut'];
$savesplease = $_POST['ingsave'];
if(!empty($_POST['cars'])){
foreach ($selectop as $key ) {
 foreach ($savesplease as $key1 ) {
 mysqli_query($conn,"INSERT INTO coffe VALUES ('$key','$name','$prix','$prixn','$key1')");
 }
 }


echo "New record created successfully";
}
 else {
  echo "_error_: " . $sql . "<br>" . mysqli_error($conn);
} 


google works nice

https://www.tutorialspoint.com/mysql/mys...icates.htm

try it

[blackcoder00]

google works nice

https://www.tutorialspoint.com/mysql/mys...icates.htm

try it

i didn't find anything that could help me

[Nachfolger]

Why is your insert query in 2 loops? Post the full code, it’s hard to tell what’s even happening here.

[HFDone]

delete foreach https://www.w3schools.com/php/php_mysql_select.asp

[blackcoder00]

delete foreach https://www.w3schools.com/php/php_mysql_select.asp

thank you bro but i solved the problem from the last night
the correct code

PHP Code


<?php 
if(!empty($_POST['cars'])){
$stmt = mysqli_prepare($conn,'INSERT INTO coffe VALUES(?, ?, ?, ?, ?)');
mysqli_stmt_bind_param($stmt, 'ssiii', $v, $_POST['nom'], $_POST['prix'], $_POST['prix-neut'], $save);
foreach ($_POST['cars'] as $k => $v) {
    $save = $_POST['ingsave'][$k];
    mysqli_stmt_execute($stmt);
}


echo "New record created successfully";
}
 else {
  echo "_error_: " . $sql . "<br>" . mysqli_error($conn);
} 


---

Why is your insert query in 2 loops? Post the full code, it’s hard to tell what’s even happening here.

yeah that's why i got that problem (insert the record 4*2 ) because i have put it into two foreach loop