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

PHP removes trim () from the beginning and end of a string. the instance code is as follows: & lt ;? Php $ a & quot; (a, B, c,) & quot; echo $ a & quot; & lt; br & gt; & quot; output: (, b, c,) $ btrim ($ a, & quot; () & quot;); removes the first string

PHP removes the trim () function from the beginning and end of a string. the instance code is as follows:

2. $ A = "(a, B, c ,)";
3. Echo $ ."
   "; // Output: (a, B, c ,)
4. $ B = trim ($ a, "()"); // remove the character "(" or ")" contained at the beginning and end of the string.
5. Echo $ B ."
   "; // Output: a, B, c,
6. $ C = trim ($ a, "(,)"); // remove the "(", "," or ")" characters at the beginning and end of the string.
7. Echo $ c ."
   "; // Output: a, B, c
8. ?>

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.