Error when trying to insert the data from the cart to the new tables

Question

$x = $i + 1;
        $pp_checkout_btn .= '
        
          ';

versus

// Dynamic Checkout Btn Assembly
    $x = $i + 1;
    $pp_checkout_btn .= '
    
      ';

with the above input data where i set up another page to retrieve the data

prepare($sql); 
$countArray = count($_POST["item_name"]);
for ($i = 0; $i < $countArray; $i++) {
$stmt->bind_param('sss', $_POST['item_name'][$i], $_POST['amount'][$i], $_POST['quantity'][$i]);
$stmt->execute();
}

echo $sql   ; 

exit();
}
?>

this retrieve with the 1st one above but it skipped the first item_name[] in the cart where as the second one above failed to retrieve data using $_POST["item_name"] any other words I can use in order to retrieve data from the second one?

it actually affected my indexes..where after the implement of item_name[] or item_name[ ' . $x . ] ..it remove the line one down..eg first line click remove, it remove the second line, if click second line, it remove the third line, if nothing in third line, it show no response

Array ( [cartOutput] =>   Array ( [ 1 ] => 123 ) [quantity] => Array ( [ 1 ] => 1 ) [custom] => 19-1, ) array(4) { ["cartOutput"]=> string(44) "   array(1) { [" 1 "]=> string(3) "123" } ["quantity"]=> array(1) { [" 1 "]=> string(1) "1" } ["custom"]=> string(5) "19-1," } 
Notice: Undefined index: item_name in /home/u382560552/public_html/order_list.php on line 23
INSERT INTO orders (product_name, price, quantity, date_added) VALUES(?,?,?, NOW())

the above is printr(POST) and vardump(POST) for item_name[ ' . x . ' ]





Your Cart




  
  
    
    Your Cart
  
  
    Home   ·   Products   ·   Help   ·   Contact
    
  
  
    

    

    
      
        Product
        Product Description
        Unit Price
        Quantity
        Total
        Remove
      
     BiO-LiFE BIO-VIZION 100 + 30 CAPS
Provides the natural carotenoids lutein & zeaxanthin, plus The A.C.E. & Zinc antioxidants. Lutein and zeaxanthin are naturally present in the macula of the human retina. BiO-LiFE Bio-Vizion is a unique formula that provides a source of lutein and zeaxanthin preserved in their natural form from marigold flowers. It is also formulated with other anti free-radical nutrients such as Vitamin A,C,E plus the mineral zinc and selenium.

Features:

Dosage: Adult - One capsule daily with food or as recommended by your pharmacist.
Dosage: Children (6-12 yrs): One capsule every other day with food or as recommended by your pharmacist.
100 tablets per bottle or box $140.00 
        
        
        
           $140.00 
     
    
    Cart Total :    $140.00 USD
    




    
    
      

    
    
    

    

    Click Here to Empty Your Shopping Cart
    
   

  
  Copyright | Admin

the above is html view source


 array("item_id" => $pid, "quantity" => 1));
    } else {
        // RUN IF THE CART HAS AT LEAST ONE ITEM IN IT
        foreach ($_SESSION["cart_array"] as $each_item) { 
              $i++;
              while (list($key, $value) = each($each_item)) {
                  if ($key == "item_id" && $value == $pid) {
                      // That item is in cart already so let's adjust its quantity using array_splice()
                      array_splice($_SESSION["cart_array"], $i-1, 1, array(array("item_id" => $pid, "quantity" => $each_item['quantity'] + 1)));
                      $wasFound = true;
                  } // close if condition
              } // close while loop
           } // close foreach loop
           if ($wasFound == false) {
               array_push($_SESSION["cart_array"], array("item_id" => $pid, "quantity" => 1));
           }
    }
    header("location: cart.php"); 
    exit();
}
?>

= 100) { $quantity = 99; }
    if ($quantity < 1) { $quantity = 1; }
    if ($quantity == "") { $quantity = 1; }
    $i = 0;
    foreach ($_SESSION["cart_array"] as $each_item) { 
              $i++;
              while (list($key, $value) = each($each_item)) {
                  if ($key == "item_id" && $value == $item_to_adjust) {
                      // That item is in cart already so let's adjust its quantity using array_splice()
                      array_splice($_SESSION["cart_array"], $i-1, 1, array(array("item_id" => $item_to_adjust, "quantity" => $quantity)));
                  } // close if condition
              } // close while loop
    } // close foreach loop
}
?>

Your shopping cart is empty";
} else {
        // Start PayPal Checkout Button
    $pp_checkout_btn .= '
    
    
      ';
        // Create the product array variable
        $product_id_array .= "$item_id-".$each_item['quantity'].","; 
        // Dynamic table row assembly
        $cartOutput .= "";
        $cartOutput .= '' . $product_name . '
';
        $cartOutput .= '' . $details . '';
        $cartOutput .= '$' . $price . '';
        $cartOutput .= '
        
        
        
        ';
        //$cartOutput .= '' . $each_item['quantity'] . '';
        $cartOutput .= '' . $pricetotal . '';
        $cartOutput .= '';
        $cartOutput .= '';
        $i++; 
    } 
    setlocale(LC_MONETARY, "en_US");
    $cartTotal = money_format("%10.2n", $cartTotal);
    $cartTotal = "Cart Total : ".$cartTotal." USD";
    // Finish the Paypal Checkout Btn
    $pp_checkout_btn .= '

    
    ';
}
?>




Your Cart




  
  
    

    

    
      
        Product
        Product Description
        Unit Price
        Quantity
        Total
        Remove
      
     
     
    
    
    




    

    

    Click Here to Empty Your Shopping Cart

actual form as requested

Barmar · Accepted Answer

This is wrong:

$pp_checkout_btn .= '

';

And change this:

$x = $i + 1;
$pp_checkout_btn .= '

  ';

to:

$pp_checkout_btn .= '

  ';

This will let PHP fill in the array indexes, starting from 0; you were starting from 1.

Finally, you have two elements with id="cartOutput": the hidden input and the submit button. You need to rename one of them, because IDs must be unique. Or remove the IDs if they're not used for anything.

Error when trying to insert the data from the cart to the new tables

Answers (2)

Related Questions