PHP and SQL remove specific characters or spaces at the beginning and end of a string

Next let's take a look at the specific characters or spaces at the beginning and end of the removal string in PHP and SQL. Here we only need to use trim.

PHP removes the beginning and end of a string, and the specific character function trim ()

<? Php $ a = "(a, B, c,)"; echo $. "<br/>"; // output: (a, B, c,) $ B = trim ($ ,"()"); // remove the character "(" or ")" echo $ B at the beginning and end of the string. "<br/>"; // output: a, B, c, $ c = trim ($ ,"(,)"); // remove the character "(", "," or ")" echo $ c. "<br/>"; // output: a, B, c?>
Output result: (a, B, c,) a, B, c, a, B, c

In SQL, trim () is used to remove spaces at the beginning and end, ltrim () is used to remove spaces on the left side of the string, and rtrim () is used to remove spaces on the right side of the string.