Using urlencode in mysql row php

Question

I get some data from the database then create a link from the data.

<a href=\"news/people/" . urldecode($row['title']) . ".html\" target=\"_self\">"

the output is link is http://wwww.website.com/news/people/ask+question+stack.html so instead of having the plus sign in the link i will like to hve a link with hyphen like this http://wwww.website.com/news/people/ask-question-stack.html

Thanks for the help Newbie

does this help: urldecode(str_replace("+", "-", $row['title'])) ? — Maximus2012, Aug 29 '13 at 21:30
possible duplicate of [php function to make slug (url string)](http://stackoverflow.com/questions/2955251/php-function-to-make-slug-url-string) — George Yates, Aug 29 '13 at 21:31

score 1 · Answer 1 · edited Aug 29 '13 at 22:24

1

It should be URL Encoding not URL Decoding when building a link with content from a database. if the content in $row['title'] = "ask question stack", then you could replaces spaces with hyphens and then encode your string.

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

edited Aug 29 '13 at 22:24

slavoo

4,967
63
33
38

answered Aug 29 '13 at 21:39

user2730567

11
2

score 0 · Answer 2 · edited Aug 29 '13 at 22:07

0

You can use this :

urldecode(str_replace("+", "-", $row['title']))
urldecode(str_replace(" ", "-", $row['title']))
urldecode(str_replace("_", "-", $row['title']))
urldecode(str_replace(".", "-", $row['title']))

edited Aug 29 '13 at 22:07

interjay

97,531
20
242
238

answered Aug 29 '13 at 21:46

leonxn

1

score 0 · Answer 3 · answered Jan 17 '16 at 04:37

0

urlencode(str_ireplace(array('+', ' ', '_', '.'), '-', $row['title']));

answered Jan 17 '16 at 04:37

Vijay Arun

398
9
13

Using urlencode in mysql row php

3 Answers3