php - My $_SESSION variables are only getting the first letter of each index in my array

Solution:

Try changing this:

$row = mysqli_fetch_array($result);
$id [] = $row['Product_PK'];
$name [] = $row['Name'];
$desc [] = $row['Description'];
$price [] = $row['Price'];
$qty [] = $row['Quantity'];
Copy code

To this:

// While $row is an array created by the result of the query...
while ($row = mysqli_fetch_array($result)) {
  // The $id array continutes to have $row['Product_PK'] piled onto it.
  $id[] = $row['Product_PK'];
  // Same with the $name array, etc, etc.
  $name[] = $row['Name'];
  $desc[] = $row['Description'];
  $price[] = $row['Price'];
  $qty[] = $row['Quantity'];
}
// NOW start with your FOR statement. PHP will remember the values assigned during
// the WHILE loop, even though WHILE has ended (closing curly bracket).
Copy code

Solution:

You need to put your mysqli_fetch_array into a loop. By default, mysqli_fetch_array(and its predecessor mysql_fetch_array) only retrieves the current row from the object returned from mysqli_query(and mysql_query).

while($row = mysqli_fetch_array($result)){
   array_push($id, $row["Product_PK"];
   array_push($name, $row["Name"];
   array_push($desc, $row["Descripition"];
   array_push($price, $row["Price"];
   array_push($qty, $row["Quantity"];
}
Copy code

Of course you'll have to define your arrays first so put this in before the while loop above.

$id = $name = $desc = $price = $qty = array();
Copy code

After the PHP interrupter runs the above, you'll end up with 5 arrays (not 5 regular variables). This is the part where I think the logic you're using is a bit confusing. On your HTML mark-up, you only have one form. So the question is, which "product's" information that was returned from the database pull do you want to insert into the form?

Based on what you have so far, you'll need to wrap PHP markers around your entire form. Below would be an example

<php?
for ($i = 0; $i < count($id); $i++):
  $current_id = $_SESSION['prod' . $i . '_ID'] = $id[$i];
  $current_name = $_SESSION['prod' . $i . '_Name'] = $name[$i];
  $current_price = $_SESSION['prod' . $i . '_Price'] = $price[$i];
  $current_desc = $_SESSION['prod' . $i . '_Desc'] = $desc[$i];
  $current_qty = $_SESSION['prod' . $i . '_Qty'] = $qty[$i];
?>
<form method="post" action="" >
        <fieldset>
          <input type="hidden" name="jcartToken" value="<?php echo $_SESSION['jcartToken'];?>" />
          <input type="hidden" name="my-item-id" value="<?php echo $current_id;?>" />
          <input type="hidden" name="my-item-name" value="<?php echo $current_name; ?>" />
          <input type="hidden" name="my-item-price" value="<?php echo $current_price; ?>" />

          <ul>
            <li><strong><?php echo $current_name;?></strong></li>
            <li>Price: $<?php echo $current_price;?></li>
            <li>
              <?php echo $current_desc;?>
            </li>
            <li>
              Available: <?php echo $current_qty;?>
            </li>
              <label>Qty: <input type="text" name="my-item-qty" value="1" size="3" /></label>
            </li>
          </ul>

          <input type="submit" name="my-add-button" value="add to cart" />
        </fieldset>
      </form>
<?php
endfor
?>
Copy code

Now the form mark-up is wrapped with PHP markers. $i number of forms will be created; one each for every item in your arrays.

Solution:

Try this

    $i=0
    while(rows = mysqli_fetch_array($result)) {       

    $_SESSION['prod' . $i . '_ID'] = $row['Product_PK'];;
    $_SESSION['prod' . $i . '_Name'] = $row['Name'];
    $_SESSION['prod' . $i . '_Price'] = $row['Price'];
    $_SESSION['prod' . $i . '_Desc'] = $row['Description'];
    $_SESSION['prod' . $i . '_Qty'] = $row['Quantity'];

    $i++;
    }
Copy code