Replacing %20 with a Dash

Question

Hello,

When I echo out the variable below, spaces are represented as %20.

$row["title"]

So, for instance, if $row["title"] equals "Portugal Crushes North Korea," it echoes out as Portugal%20Crushes%20North%20Korea.

In my source code, how could I replace each %20 with a dash?

Thanks in advance,

John

Answer 1

Your data is probably url-encoded - use rawurldecode($row['title']) to get it back.

Answer 2

Both should do

$string = 'Portugal%20Crushes%20North%20Korea';

echo str_replace('%20', '-', $string);
echo str_replace(' ', '-', rawurldecode($string));

Url Decoding the string before replacement isn't strictly necessary though. It just makes sense in case there is additional encoded characters in the string, e.g.:

echo rawurlencode('Portugal Crushes North Korea (7:0)');
// Portugal%20Crushes%20North%20Korea%20%287%3A0%29

With decoding applied, the space to dash replacement would be

Portugal-Crushes-North-Korea-(7:0)

See the PHP Manual

• rawurldecode — Decode URL-encoded strings

Answer 3

how could I replace each %20 with a dash?

str_replace('%20', '-', $row['title']);

Answer 4

Looks like what your doing here is encoding the title before it goes into the database!

i would not do this way, instead do not encode data for DB but encode it as your looping the results to the page, or even better add an extra column called slug.

so you have in title "Some Clean Title Here" and in the slug column you have "some-clean-title-here" so then you use $row['slug']

then in your look use

<a href="site_root.tld/post/<?=$row['slug']?>"><?=$row['title'];?></a>

Always escape your data with mysql_real_escape_string and use a function that dont just urlencode the slug on db entry but also creates a sleek elegant safe formatted string.

the best form for a slig is a-zA-Z0-9 - _ only.