php remove from string

Question

Nice quick one for you guys, hope you can help.

After a dodgy CMS I created a while ago, my database is full of product 'names' that have either 1, 2 or 3 spaces before the actual name. This is causing me havoc now and I'm wondering if there's a function that will let me remove these pesky spaces in PHP instead of having to update the database (hundreds of entries).

To make it clearer here's what I'm trying to achieve.

//swap spaces in name for hyphens
$SEOname = str_replace(' ','-',$name);

//works fine on all entries that don't have preceding spaces, but occasionally leads to this
---concrete-fence-posts

Hope you can help.

Thanks.

Felix Kling · Accepted Answer · 2010-10-23 18:17:51Z

1

Use trim():

$SEOname = str_replace(' ','-',trim($name));

answered Oct 23, 2010 at 18:17

Felix Kling

820k181 gold badges1.1k silver badges1.2k bronze badges

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

Comments

Vincent Savard · Accepted Answer · 2010-10-23 18:16:59Z

0

The php function trim() (Or TRIM() in SQL)

$str = trim("   HELLO   "); // "HELLO"

or

SELECT TRIM("    HELLO    "); // "HELLO"

If the spaces are not necessary, it would be a good idea to remove them from your database (with a query such as UPDATE table_name SET column_name = TRIM(column_name);

answered Oct 23, 2010 at 18:16

Vincent Savard

36.1k10 gold badges71 silver badges73 bronze badges

Comments

codaddict · Accepted Answer · 2010-10-23 18:17:22Z

0

You can use the ltrim function to get rid of the leading spaces from a string as:

$str = ltrim($str);

In your case it would be used as:

$SEOname = str_replace(' ','-',ltrim($name));

answered Oct 23, 2010 at 18:17

codaddict

457k83 gold badges501 silver badges537 bronze badges

Collectives™ on Stack Overflow

php remove from string

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related