PHP如何为逗号分隔字符串添加单引号？求助正确实现方式

Got it, let's break down what's going wrong here and get your code working as intended. The core problem right now is that you're trying to use implode() on a string ($splitnumber) instead of an array—implode() needs an array of values to join together with your quoted separator.

What Your Current Code Is Missing #

You've cleaned up the input string to handle newlines, but you haven't split that cleaned string into individual elements (the numbers you want to wrap in quotes). Let's fix that step by step:

1. Clean the input properly: You were on the right track with stripping extra newlines, but we can simplify that with trim() and preg_replace to normalize line breaks.
2. Split into an array: Depending on whether your input is comma-separated, newline-separated, or both, we'll split the cleaned string into an array of individual values.
3. Filter out empty values: Avoid adding empty quoted strings if there are trailing commas/newlines.
4. Wrap each element in quotes: Use implode() correctly to join the array elements with ', ' and wrap the whole thing in the right format.

Corrected Code #

<?php
// Get and sanitize the input first
$checknumber = mysqli_real_escape_string($dbc, trim($_POST['checknumber']));

// Normalize line breaks and trim any leftover whitespace/newlines
$cleanedNumber = preg_replace('/[\r\n]+/', "\n", $checknumber);
$cleanedNumber = trim($cleanedNumber);

// Split into array: adjust the delimiter based on your actual input
// Use this for COMMA-separated input:
$numberArray = explode(',', $cleanedNumber);
// Use this for NEWLINE (or mixed comma/newline) input:
// $numberArray = preg_split('/[\n,]+/', $cleanedNumber);

// Filter out empty elements from extra commas/newlines
$numberArray = array_filter($numberArray, function($val) {
    return trim($val) !== '';
});

// Trim each element and wrap in single quotes, then join everything
$formattedNumbers = "'" . implode("', '", array_map('trim', $numberArray)) . "'";

// Test your outputs (fixed the missing 'o' in your original echo!)
echo "Original input: " . $checknumber . "<br>";
echo "Cleaned input: " . $cleanedNumber . "<br>";
echo "Formatted result: " . $formattedNumbers;
?>

How This Works #

• Input Sanitization: You were already using mysqli_real_escape_string (great practice for database safety!)—we just added extra trimming to clean up stray whitespace.
• Array Splitting: Pick the delimiter that matches your actual input: use explode(',', ...) for comma-separated values, or preg_split('/[\n,]+/', ...) if users might mix commas and newlines.
• Filtering Empty Values: The array_filter step removes any empty strings that could come from trailing commas or accidental extra newlines.
• Final Formatting: array_map('trim', ...) ensures each number has no extra spaces, then implode("', '", ...) joins them with ', ' between each value. Wrapping the whole thing in outer single quotes gives you the exact '123', '456', '789' format you need.

Example Output #

If your input is 123, 456\n789 (mixed comma and newline), the formatted result will be '123', '456', '789'.

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