How can PHP be used to remove leading and trailing spaces from database entries?

When retrieving data from a database, it's common to encounter leading and trailing spaces in the entries. To remove these spaces, we can use the PHP trim() function. This function will remove any whitespace characters, including spaces, tabs, and newlines, from the beginning and end of a string. 

// Assume $row is an array containing database entries
foreach ($row as $key => $value) {
    $row[$key] = trim($value);
}

Keywords

PHP trim() database entries leading spaces trailing spaces

Related Questions