存储库MySQLi阵列中的PHP会话吗？ [英] Store mySQLi array in PHP session?

问题描述

你如何存储在PHP会话的mysqli阵列？我用whil​​e循环来呈现出数组，但我应该怎么分配他们每个人的会议？

下面是我的尝试：

 而（$行= mysqli_fetch_array（$的SqlCommand））{
             的$ id = $行[身份证];
             $ PRODUCT_NAME = $行[PRODUCT_NAME];
             $价格= $行[价格];
             。$ all_list =ID = $ ID，产品名称= $ PRODUCT_NAME，价格= $价格\\ N的;
}/ *只有工作，如果只限制1 * /
// $ _ SESSION [身份证] = $ ID;
// $ _ SESSION [PRODUCT_NAME] = $ PRODUCT_NAME;
// $ _ SESSION [价格] = $的价格;
 

我也试过session变量分配给每个数组的但它只能工作，如果结果限于一个。在我的情况下，结果将是至少一个或多个。我该怎么做？

解决方案

 而（$行= mysqli_fetch_array（$的SqlCommand））{
             $ _SESSION [] ['身份证'] = $行[身份证];
             $ _SESSION [] ['PRODUCT_NAME'] = $行[PRODUCT_NAME];
             $ _SESSION [] ['价格'] = $行[价格];
             。$ _SESSION [] ['all_list'] =ID = $ ID，产品名称= $ PRODUCT_NAME，价格= $价格\\ N的;
}
 

将所有的行存储为会话的数组。

要查看结果使用下面的行后while循环：的var_dump（$ _ SESSION）;

要访问某个特定的值（例如 ID ）使用以下命令：回声$ _SESSION [0] ['身份证'];

How do you store mySQLi array in PHP session? I used while loop to render out the array but how should I assign each of them to the session?

Here is my attempt:

while($row = mysqli_fetch_array($sqlCommand)){ 
             $id = $row["id"];
             $product_name = $row["product_name"];
             $price = $row["price"];
             $all_list .= "id= $id, product name = $product_name, price = $price \n";
}

/*only work if only LIMIT  1*/
//$_SESSION["id"] = $id;
//$_SESSION["product_name"] = $product_name;
//$_SESSION["price"] = $price;

I have also tried to assign session variable to each of the array however it only works if the result is limited to one. In my case the result will be at least one or more. How can I do that?

解决方案

while($row = mysqli_fetch_array($sqlCommand)){ 
             $_SESSION[]['id'] = $row["id"];
             $_SESSION[]['product_name'] = $row["product_name"];
             $_SESSION[]['price'] = $row["price"];
             $_SESSION[]['all_list'] .= "id= $id, product name = $product_name, price = $price \n";
}

Will store all rows as an array in your session.

To look at the result use the following line after the while loop: var_dump($_SESSION);

To access a specific value (for example id) use the following: echo $_SESSION[0]['id'];

这篇关于存储库MySQLi阵列中的PHP会话吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！