如何提取字符串首个左括号与末个右括号间内容并完成后续处理？

Got it, let's build a PHP function that handles all the steps you need—extracting the bracket-wrapped content, modifying it, and splitting into fields. Here's a complete implementation with explanations:

The Function #

function processFields(string $string, mixed $search, mixed $replace): array {
    // Locate the first opening bracket and last closing bracket
    $firstOpenPos = strpos($string, '(');
    $lastClosePos = strrpos($string, ')');

    // Handle edge cases where brackets are missing or invalid
    if ($firstOpenPos === false || $lastClosePos === false || $firstOpenPos > $lastClosePos) {
        return explode(',', trim($string, ';'));
    }

    // Extract the full bracket-enclosed content (including brackets)
    $bracketSection = substr($string, $firstOpenPos, $lastClosePos - $firstOpenPos + 1);

    // Perform str_replace on the bracket content
    $modifiedBracketSection = str_replace($search, $replace, $bracketSection);

    // Replace the original bracket section with the modified one
    $processedString = substr_replace($string, $modifiedBracketSection, $firstOpenPos, $lastClosePos - $firstOpenPos + 1);

    // Remove trailing semicolon and split into fields by commas
    return explode(',', trim($processedString, ';'));
}

How It Works #

Let's break down each step:

• Bracket Positioning: Uses strpos() and strrpos() to find the first ( and last ) in the string. We add a check to handle cases where brackets are missing or out of order, falling back to splitting the original string if needed.
• Extract Bracket Content: Grabs the entire section from the first opening bracket to the last closing bracket (matching your example's requirement to get (if(isnull(table.id_),1,table.id_))).
• Modify Content: Runs str_replace() on the extracted bracket section—this works with both single string values and arrays for multiple replacements.
• Reconstruct & Split: Puts the modified bracket section back into the original string, trims off the trailing semicolon, then splits the result into fields using explode(',').

Usage Example #

Here's how to use it with your sample string:

$string = "field1,field2,(if(isnull(table.id_),1,table.id_)) as field3,field4;";

// Replace 'table.id_' with 'users.id'
$fields = processFields($string, 'table.id_', 'users.id');

print_r($fields);

Output #

Array
(
    [0] => field1
    [1] => field2
    [2] => (if(isnull(users.id),1,users.id)) as field3
    [3] => field4
)

Multiple Replacements #

You can also pass arrays to replace multiple values at once:

// Replace 'table.id_' with 'users.id' and '1' with '0'
$fields = processFields($string, ['table.id_', '1'], ['users.id', '0']);

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