PHP实现数据库多选值格式转换：单值保留/多值转数组

Hey there! I've got you covered. Let's break down how to handle this scenario where your database returns either a single value string or a multi-value string separated by |*|.

Approach #

The core idea is straightforward:

• Check if the input string contains the multi-value separator |*|
• If it does, split the string into an array and clean up any potential empty entries
• If it doesn't, return the original single value as-is

Complete Code Implementation #

Here's a reusable function that handles both cases, plus some edge cases for robustness:

function parseMultiSelectValue(string $value) {
    // Check if the value contains the multi-value separator
    if (strpos($value, '|*|') !== false) {
        // Split the string using the separator
        $valuesArray = explode('|*|', $value);
        // Filter out any empty strings (in case of accidental leading/trailing separators)
        $valuesArray = array_filter($valuesArray, function($item) {
            return trim($item) !== '';
        });
        // Reset array keys to be sequential (optional but cleaner)
        return array_values($valuesArray);
    }
    
    // If it's a single value, return it as-is
    return $value;
}

// Test cases
// Single value scenario
$singleValue = "2";
var_dump(parseMultiSelectValue($singleValue)); // Output: string(1) "2"

// Multi-value scenario
$multiValue = "1|*|3|*|150";
var_dump(parseMultiSelectValue($multiValue)); // Output: array(3) { [0]=> string(1) "1" [1]=> string(1) "3" [2]=> string(3) "150" }

// Edge case: value with empty entries (e.g., accidental trailing separator)
$edgeCaseValue = "5|*|7|*|";
var_dump(parseMultiSelectValue($edgeCaseValue)); // Output: array(2) { [0]=> string(1) "5" [1]=> string(1) "7" }

Explanation #

• strpos() Check: We use strpos() to detect if the separator exists—this is more efficient than checking the result of explode() directly.
• array_filter(): This step ensures we don't end up with empty array elements if the input string has leading, trailing, or duplicate separators (a common edge case with form submissions).
• array_values(): Resets the array keys to start from 0, which makes the array cleaner to work with in loops or when accessing elements by index.

This function is flexible enough to handle your exact use case while being resilient to unexpected input.

内容的提问来源于stack exchange，提问作者Mahmood Esali