How to strip/delete all spaces **except between words** in a string in php?

Question

I saved the values to mysql and I saw spaces like that.

INSERT INTO `names` VALUES (7, 'James Bond            ');

I tried to make it:

INSERT INTO `names` VALUES (7, 'James Bond');

I know make it like that: (But it stripts the space between the words too)

INSERT INTO `names` VALUES (7, 'JamesBond');

Answer 1

Use trim()

$variable = trim( $variable );

http://php.net/trim

Answer 2

Use TRIM() in your DBMS:

INSERT INTO `names` VALUES (7, TRIM('James Bond            '));

or

trim() in php:

$var = trim('James Bond            ');