How can PHP be used to remove unwanted characters, such as line breaks, from SQL output in XML generation?

When generating XML output from SQL data in PHP, unwanted characters such as line breaks can interfere with the XML structure and cause parsing issues. To remove these unwanted characters, we can use PHP's `preg_replace` function with a regular expression pattern to replace them with an empty string. 

// Sample SQL output containing unwanted characters
$sqlOutput = "This is a sample text with
line breaks.";

// Remove unwanted characters using preg_replace
$cleanedOutput = preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $sqlOutput);

// Output the cleaned data
echo $cleanedOutput;

Keywords

PHP SQL output XML generation character removal line breaks

Related Questions