How to store my session array into my database

Question

How do I store my data in session array into my database ? Upon entering the product and its quantity, the user will be directed to a checkout page. In the checkout page, upon filling up the necessary information in a form, I am trying to use a button to submit the session array into my database.

My current code:

<?php
    session_start();
    $array = $_SESSION['shopping_cart'];  
    $connect = mysqli_connect('localhost', 'root', '', 'table');
    ?>
    $sql = "INSERT INTO customer_order (productName, quantity, totalPrice, pax)";
    foreach($array as $product){
       $sql = "INSERT INTO p2_5.customer_order (productName, quantity, totalPrice, pax)";
       $sql .= " VALUES ('{$product['name']}', '{$product['quantity']}', '{$product['price']}', '{$product['pax']}')";
       if ($connect->query($sql)) {
          $errorMsg = "Connection failed: " . $connect->connect_error;
          $success = false;
   } 
}

However, upon clicking on the button, I am able to store client information into my database, but I would have an PHP error message Undefined index: name, Undefined index: quantity, Undefined index: price, Undefined index: pax ?

Can do it a a JSON String json_encode() or using serialize() — RiggsFolly
– RiggsFolly, Commented Nov 15, 2019 at 12:28
1) you're closing php tag with ?>. 2) you're passing elements from $array without referencing to their index, I mean without $array[0] or $array[1] — Aksen P
– Aksen P, Commented Nov 15, 2019 at 12:28
“What did I do wrong ?” - looks like you are developing without having proper PHP error reporting enabled, otherwise PHP should have given you notices about how you are trying to access array elements that aren’t actually there. So please go and enable it first of all now! — 04FS
– 04FS, Commented Nov 15, 2019 at 12:30
Oh I see now. You need to add a loop to your code. Looping over the $array — RiggsFolly
– RiggsFolly, Commented Nov 15, 2019 at 12:31

Aksen P · Accepted Answer · 2019-11-15 14:04:09Z

4

You're passing elements from $array without referencing to their indexes, I mean without $array[0] or $array[1].

You need to add a loop like below:

foreach($array as $product){
   $sql = "INSERT INTO customer_order (productName, quantity, totalPrice, pax)";
   $sql .= " VALUES ('{$product['name']}', '{$product['quantity']}', '{$product['price']}', '{$product['pax']}')";
   if ($connect->query($sql)) {
       $errorMsg = "Connection failed: " . $connect->connect_error;
       $success = false;
   } 
   if ($errorMsg != "Connection failed: ") {echo $errorMsg; $connect->close(); return;}
}

This will allow you to save each row data from shopping_cart.

edited Nov 15, 2019 at 14:04

answered Nov 15, 2019 at 12:40

Aksen P

4,6153 gold badges16 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

John Wick Over a year ago

sorry, however when I check my database, nothing is being stored

Aksen P Over a year ago

@JohnWick, show me echo $sql; return;. Put it before if statement. This will make the first query string and you'll see what you're sending to DB.

John Wick Over a year ago

INSERT INTO root.customer_order (productName, quantity, totalPrice, pax) VALUES ('Seafood Set', '8', '250', '90')

Aksen P Over a year ago

@JohnWick, try to erase p2_5.(or root.) and try again

Aksen P Over a year ago

@JohnWick, hah, then add ' around each column name -> ('productName', 'quantity', 'totalPrice', 'pax')

|

Collectives™ on Stack Overflow

How to store my session array into my database

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related