Laravel会话无法跨搜索持久化商品数量问题求助

问题描述 #

开发Laravel应用时，用户可搜索商品/分类并指定数量，但在同一视图内切换搜索不同商品/分类时，之前输入的数量无法保留。尽管使用Session存储数据，仍仅能保留最后一次搜索的数量。

问题表现 #

• 用户搜索商品并输入数量后，仅最后一次搜索的分类/商品数量会被保留
• Session仅存储最近一次搜索的数量数据

已测试的实现代码 #

测试实现1 #

// Store selected quantities in the session
$existingQuantities = $req->session()->get('quantities', []);
$newQuantities = $req->input('quantity', []);

// Filter out null values
$newQuantities = array_filter($newQuantities, function($value) {
    return $value !== null;
});

// Merge existing and new quantities
$mergedQuantities = array_merge($existingQuantities, $newQuantities);

// Update session with merged quantities
$req->session()->put('quantities', $mergedQuantities);

// Debugging
dd($req->session()->get('quantities'));

// Retrieve categories and products
$categories = Category::with(['products.inventories'])->get();
$orderItems = [];
$categoryTotals = [];

foreach ($categories as $category) {
    foreach ($category->products as $product) {
        if (isset($mergedQuantities[$product->id]) && $mergedQuantities[$product->id] > 0) {
            $quantity = $mergedQuantities[$product->id];
            $orderItems[] = [
                'category' => $category->category_name,
                'product_name' => $product->product_name,
                'quantity' => $quantity
            ];

            if (!isset($categoryTotals[$category->category_name])) {
                $categoryTotals[$category->category_name] = 0;
            }
            $categoryTotals[$category->category_name] += $quantity;
        }
    }
}

// Insert order items into the database
foreach ($orderItems as $orderItem) {
    DB::table('requestorder')->insert([
        'family_id' => $familyId,
        'category' => $orderItem['category'],
        'categoryTotal' => $categoryTotals[$orderItem['category']],
        'requestedItem' => $orderItem['product_name'],
        'amountNeeded' => $orderItem['quantity'],
        'daterequested' => now()
    ]);
}

// Clear session after order is submitted
$req->session()->forget('quantities');

测试实现2 #

// Retrieve existing quantities from the session
    $existingQuantities = $req->session()->get('quantities', []);

    // Retrieve new quantities from the request
    $newQuantities = $req->input('quantity', []);

    // Log or var_dump existing and new quantities for debugging
    var_dump('Existing Quantities:', $existingQuantities);
    var_dump('New Quantities:', $newQuantities);

    // Iterate over the new quantities
    foreach ($newQuantities as $productId => $quantity) {
        // Log or var_dump each quantity to see why some might be null
        var_dump("Processing Product ID: $productId, Quantity: $quantity");

        // Store all quantities, including null, in the session
        $quantityData = [
            'productid' => $productId,
            'quantity' => $quantity
        ];

        // Use Session::push() to add each quantity to the session
        $req->session()->push('quantities', $quantityData);
    }

    // Retrieve the updated quantities from the session
    $updatedQuantities = $req->session()->get('quantities');

    // Log or var_dump the updated quantities
    var_dump('Updated Quantities in Session:', $updatedQuantities);

    // Your existing code for processing the quantities and creating the order
    // Retrieve all categories with their products and the products' inventories
    $categories = Category::with(['products.inventories'])->get();

    $orderItems = [];
    $categoryTotals = [];

    foreach ($categories as $category) {
        foreach ($category->products as $product) {
            // Check if the product ID exists in the session and has a quantity (even if null)
            foreach ($updatedQuantities as $quantityData) {
                if ($quantityData['productid'] == $product->id) {
                    $quantity = $quantityData['quantity'];
                    $orderItems[] = [
                        'category' => $category->category_name,
                        'product_name' => $product->product_name,
                        'quantity' => $quantity
                    ];

                    if (!isset($categoryTotals[$category->category_name])) {
                        $categoryTotals[$category->category_name] = 0;
                    }
                    $categoryTotals[$category->category_name] += (int) $quantity;
                }
            }
        }
    }

    // Log or var_dump the final order items and category totals
    var_dump('Final Order Items:', $orderItems);
    var_dump('Category Totals:', $categoryTotals);

    // Insert the order items into the database
    foreach ($orderItems as $orderItem) {
        DB::table('requestorder')->insert([
            'family_id' => $familyId,
            'category' => $orderItem['category'],
            'categoryTotal' => $categoryTotals[$orderItem['category']],
            'requestedItem' => $orderItem['product_name'],
            'amountNeeded' => $orderItem['quantity'],
            'daterequested' => now()
        ]);
    }

    // Clear the quantities session after order is submitted
    $req->session()->forget('quantities');

对应Blade视图代码 #

<h4>Order Section</h4>
<section>
  <div class="row">
     <div class="col-12">
           <div class="card">
                            <div class="card-header">
                                <h4 class="card-title">Order Section</h4>
                            </div>          
                            <div class="card-body family-demo-scrollbar">
                                <div class="table-responsive ">
                                <table id="example" class="display" style="min-width: 845px;">
                                 <thead>
                                 <tr>
                                    <th>AVALIABILITY</th>
                                    <th>STATUS</th>
                                    <th>CATEGORY</th>
                                    <th>ITEM NAME</th>
                                    <th>REQUESTED</th>
                                    
                                  </tr>
                                </thead>
                                  <tbody>
                               @foreach($fetchInventoryData as $data)
                               @foreach($data->products as $product)
                               @foreach($product->inventories as $inventory)
                              <tr>
                                <td>{{$inventory->avaliability}}</td>
                                <td style="color: {{ $inventory->status === 'IN STOCK' ? 'green' : 'red' }};">{{ $inventory->status }}</td>

                                <td>{{ $data->category_name }}</td>
                               
                                <td>{{ $product->product_name }}</td>
                                
                                <td>
                                  <input type="number" name="quantity[{{$product['id']}}]" id = "quantity" min="0" class="form-control" >
                                </td>
                              </tr>
                              @endforeach
                               @endforeach
                               @endforeach
                               </tbody>

                              <tfoot>
                                            <tr>
                                                <th>AVALIABILITY</th>
                                                <th>STATUS</th>
                                                <th>CATEGORY</th>
                                                <th>ITEM NAME</th>
                                                <th>REQUESTED</th>
                                            </tr>
                                        </tfoot>
                                    </table>
                                    <br><br>
                                </div>
                            </div>
             </div>
        </div>
    </div>
</section>

问题细节 #

使用dd($req->session()->get('quantities'))仅能看到最近的数量数据，之前搜索的商品/分类对应的Session值丢失。已确认Session文件夹权限正常，var_dump()检查也证实仅存储最新数据。

问题解答 #

1. 为何Session无法保留跨多次搜索输入的所有数量？ #

主要原因包括：

• Session驱动配置错误：若使用array驱动，该驱动仅在当前请求生命周期内有效，请求结束后数据直接丢失，导致每次新请求时Session为空，只能保留最后一次提交的数据。
• 路由未启用Session中间件：若处理请求的路由不在web中间件组内（该组包含StartSession中间件），Session数据无法跨请求持久化。
• 存储逻辑漏洞：测试实现1中array_merge会覆盖相同商品ID的数量，但更关键的是，若用户切换搜索前未提交当前页面的数量，数据根本没存入Session；测试实现2使用push会重复存储同一商品的数量，且若Session无法持久化，也仅能保留当前请求的数据。
• 视图未回显Session数据：切换搜索后页面重新渲染，未从Session读取已保存的数量填充到输入框，导致用户误以为数据丢失。

2. 如何在同一视图内持久化用户为不同商品/分类输入的所有数量？ #

按以下步骤修复：

步骤1：确保Session配置正确

1. 修改.env文件中的SESSION_DRIVER，改为file、database或redis（避免使用array驱动）。
2. 确保处理请求的路由位于routes/web.php中（默认包含web中间件组，负责Session管理）。

步骤2：修正后台数量存储逻辑

优化合并逻辑，支持覆盖或移除商品数量：

// 获取已保存的数量
$existingQuantities = $request->session()->get('quantities', []);
// 获取当前提交的数量
$newQuantities = $request->input('quantity', []);

// 遍历新提交的数量，更新Session数据
foreach ($newQuantities as $productId => $quantity) {
    $quantity = (int)$quantity;
    // 数量为0时移除该商品，否则更新数量
    if ($quantity === 0) {
        unset($existingQuantities[$productId]);
    } else {
        $existingQuantities[$productId] = $quantity;
    }
}

// 更新Session
$request->session()->put('quantities', $existingQuantities);

步骤3：在视图中回显Session数据

页面加载时从Session读取对应商品的数量，填充到输入框：

<input type="number" 
       name="quantity[{{$product['id']}}]" 
       id="quantity" 
       min="0" 
       class="form-control" 
       value="{{ session('quantities.' . $product['id'], 0) }}"
>

步骤4：订单提交后清除Session

仅在成功提交订单后清除Session数据：

// 插入数据库逻辑...

// 清除Session
$request->session()->forget('quantities');

可选优化：AJAX实时提交数量

添加前端AJAX逻辑，实时提交数量到后台，避免页面刷新丢失数据：

document.querySelectorAll('input[name^="quantity["]').forEach(input => {
    input.addEventListener('change', function() {
        const productId = this.name.match(/\[(\d+)\]/)[1];
        const quantity = this.value;
        
        fetch('/save-quantity', {
            method: 'POST',
            headers: {
                'Content-Type': 'application/json',
                'X-CSRF-TOKEN': document.querySelector('meta[name="csrf-token"]').content
            },
            body: JSON.stringify({
                product_id: productId,
                quantity: quantity
            })
        });
    });
});

后台新增对应路由和方法处理AJAX请求，更新Session中的数量即可。

内容的提问来源于stack exchange，提问作者Dangelo Antoine