My array just insert one time into database and ignoring other data

Question

I intend to use an array to insert into my database, but only the first data have been inserted into the database and did not insert the other value, below is my code.

$orderID=mysqli_insert_id($con);
    $query2="INSERT INTO user_order(orderID, productName,productPrice, Quantity) VALUES (?,?,?,?)";
    
    $stmt=mysqli_prepare($con,$query2);
    
    mysqli_stmt_bind_param($stmt,"isii", $orderID, $productName, $productPrice, $Quantity);
    
    foreach($_SESSION['cart'] as  $key => $values)
    {
        
        $productName = $values['Item_Name'];
        $productPrice = $values['Price'];
        $Quantity = $values['Quantity'];
        mysqli_stmt_execute($stmt);
        
    }

is `orderID` unique-key? shouldn't you increment `$orderID` each loop? or if uses AI just ignore it from your query — Juan Eizmendi, Jul 24 '21 at 04:14
what error? `mysqli_insert_id` works on AUTO_INCREMENT so, if that's setup you can omit it in your query — Juan Eizmendi, Jul 24 '21 at 04:42
[How to get the error message in MySQLi?](https://stackoverflow.com/a/22662582/1839439) — Dharman, Jul 24 '21 at 11:44
What is the return value of `mysqli_stmt_execute()`. Output it with `var_dump()` for debugging purposes. — Progman, Jul 24 '21 at 11:47

score 0 · Answer 1 · answered Jul 24 '21 at 11:48

You can try:

foreach ($records as $row) {
    $fieldVal1 = mysql_real_escape_string($records[$row][0]);
    $fieldVal2 = mysql_real_escape_string($records[$row][1]);
    $fieldVal3 = mysql_real_escape_string($records[$row][2]);
    $query ="INSERT INTO programming_lang (field1, field2, field3) VALUES ( '". $fieldVal1."','".$fieldVal2."','".$fieldVal3."' )";
    mysqli_query($conn, $query);
}

score -1 · Answer 2 · answered Jul 24 '21 at 04:17

-1

You are binding the param before they assign.

Try this

foreach($_SESSION['cart'] as  $key => $values){
        $productName = $values['Item_Name'];
        $productPrice = $values['Price'];
        $Quantity = $values['Quantity'];
        
        $orderID = mysqli_insert_id($con);
        $query2 = "INSERT INTO user_order(orderID, productName,productPrice, Quantity) VALUES (?,?,?,?)";
    
        $stmt = mysqli_prepare($con,$query2);
    
        mysqli_stmt_bind_param($stmt,"isii", $orderID, $productName, $productPrice, $Quantity);

        mysqli_stmt_execute($stmt);
        
    }

answered Jul 24 '21 at 04:17

S N Sharma

1,436
2
7
20

hi there I just tried it and still the same – Danial Hakim Jul 24 '21 at 04:29
check your cart, your cart have single or multiple items. – S N Sharma Jul 28 '21 at 06:35

My array just insert one time into database and ignoring other data

2 Answers2