remove spaces from string PHP and insert to database

Question

I'm trying to remove spaces from string but only from beggining and end of the string. Everythink work fine but after insert string to database there is no spaces but in the same place is "�".

Here is my code:

$synonimy = $_POST['fsynoms'];
$synonimyPodzielone = explode( ',', $synonimy );
for($k=0; $k < count($synonimyPodzielone); $k++)
{
    for($m=0; $m<strlen($synonimyPodzielone[$k]);$m++)
    {

        if($synonimyPodzielone[$k][$m]==" ")
        {
            $synonimyPodzielone[$k][$m]="";
        }
        else
        {
            break;
        }
    }
}

I have also tryied with str_replace trim and same problem.

Any idea how to do that?

use PHP Trim function?

Mm-Art-In
– Mm-Art-In

2015-01-27 11:02:22 +00:00
Commented Jan 27, 2015 at 11:02 — Mm-Art-In
– Mm-Art-In, Commented Jan 27, 2015 at 11:02
� looks like an type encoding problem..

Pogrindis
– Pogrindis

2015-01-27 11:14:06 +00:00
Commented Jan 27, 2015 at 11:14 — Pogrindis
– Pogrindis, Commented Jan 27, 2015 at 11:14
Yes it could be but before removing spaces it works perfect

krystian
– krystian

2015-01-27 11:16:44 +00:00
Commented Jan 27, 2015 at 11:16 — krystian
– krystian, Commented Jan 27, 2015 at 11:16

nikc.org · Accepted Answer · 2015-01-27 11:12:05Z

1

What you're looking for is trim. With the help of array_map you can even skip the for loop.

$input = " foo , bar , baz , qux ";
$words = explode(",", $input);
$wordsTrimmed = array_map("trim", $words);
$csvString = implode(",", $wordsTrimmed);

echo $csvString; // foo,bar,baz,qux

You can of course make it neater:

function trimWords($string, $glue = ",") {
    return implode($glue, array_map("trim", explode($glue, $string)));
}

$input = " foo , bar , baz , qux ";
$csvString = trimWords($input);

echo $csvString; // foo,bar,baz,qux

answered Jan 27, 2015 at 11:12

nikc.org

17k7 gold badges53 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

krystian Over a year ago

yes but what if there is $input = " foo , bar two , baz , qux" and i want to keep word "bar two" no bartwo

nikc.org Over a year ago

@krystian Trim only removes leading and trailing whitespace.

Dai · Accepted Answer · 2015-01-27 11:04:16Z

1

The trim($str) function ( http://php.net/manual/en/function.trim.php ) is hard to use incorrectly, were you just not storing the return value? (the trim function in PHP does not modify the argument, it instead returns a new string with whitespace removed).

$synonimy = $_POST['fsynoms'];
$synonimy = trim( $synonimy );

insert_into_database( $synonimy );

answered Jan 27, 2015 at 11:04

Dai

158k31 gold badges314 silver badges436 bronze badges

1 Comment

krystian Over a year ago

yes but if i have an array with strings like: $tab=['word1', ' word2 ', word-part1 word-part2 ']; i want to remove spaces only before word and after word no between word-part1 and word-part2;

nikc.org · Accepted Answer · 2015-01-27 11:05:07Z

1

PHP Trim: http://php.net/manual/en/function.trim.php should make life much easier.

for($m=0; $m<strlen($synonimyPodzielone[$k]);$m++)
{
    $synonimyPodzielone[$k][$m] = trim($synonimyPodzielone[$k][$m]);    
}

edited Jan 27, 2015 at 11:05

nikc.org

17k7 gold badges53 silver badges83 bronze badges

answered Jan 27, 2015 at 11:04

Mm-Art-In

23.1k13 gold badges81 silver badges144 bronze badges

1 Comment

krystian Over a year ago

yes i have tryied it and it work but after insert string to database in place of spaces are "��". Example i want to put word : Hello but before Hello are two spaces i want to remove it and use trim. After that there is ��

Christian Hagdorn · Accepted Answer · 2015-01-27 11:09:30Z

0

Or even simpler.

$synonimy = trim($_POST['fsynoms']);
insert_into_database($synonimy);

answered Jan 27, 2015 at 11:09

Christian Hagdorn

4835 silver badges6 bronze badges

Comments

Casimir et Hippolyte · Accepted Answer · 2015-01-27 11:20:32Z

0

using strtr is also possible (and fast):

$synonimy = trim($_POST['fsynoms']);
$synonimy = strtr($synonimy, array(' ,' => ',', ', '=>','));

Note: if your string contains duplicate spaces you want to remove, in this case you can use this:

$synonimy = preg_replace('~\s*(,)\s*|\A\s+|\s+\z~u', '$1', $_POST['fsynoms']);

that deals with unicode strings.

edited Jan 27, 2015 at 11:20

answered Jan 27, 2015 at 11:14

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

Collectives™ on Stack Overflow

remove spaces from string PHP and insert to database

5 Answers 5

2 Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related