URL from data base is not correct when i use PHP with Mysql

Question

I have DB with Url's. For example, my url is

https://besplatka.ua/?prop[161][from]=1&prop[161][to]=3&prop[136][to]=20000&currency=USD

When i use this PHP code

$result = mysqli_query($mysqli, "SELECT url FROM urls WHERE id=5");
while($res = mysqli_fetch_array($result))
{
 $my_url=$res['url'];
}
echo $my_url;

I see that the php page does not display the correct value. Encoding everywhere is UTF-8.

https://besplatka.ua/?prop[161][from]=1&prop[161][to]=3&prop[136][to]=20000¤cy=USD

What does this symbol ¤ mean? How do I fix the error?

Run this right after settting the connection `$mysqli->set_charset("utf8");` — Mihai, Apr 10 '19 at 11:08
Like Mr @Mihai said, add to set_charset to your connection code — sayou, Apr 10 '19 at 11:10
I was add $mysqli->set_charset("utf8"); to connection code But it's not work. The result is the same. — user2219963, Apr 10 '19 at 11:12
I`m guessing you have to insert it again,or fix it in the db. — Mihai, Apr 10 '19 at 11:14

sayou · Accepted Answer · 2019-04-10T12:03:53.740

1

After some search and try I found that the error is not about encoding UTF8 but the & symbol with curren word become this ¤.

So you can fix this by using urlencode function or just put your variable on the first of URL.

Result: https://besplatka.ua/?currency=USD&prop[161][from]=1&prop[161][to]=3&prop[136][to]=20000

I hope that can help you.

edited Apr 10 '19 at 12:03

answered Apr 10 '19 at 11:12

sayou

`` not work. The result is the same. – user2219963 Apr 10 '19 at 11:15
That your DB has the UTF8 type? – sayou Apr 10 '19 at 11:17
You can check this comment: [#14068747 - stackoverflow](https://stackoverflow.com/a/14068747/6173086) – sayou Apr 10 '19 at 11:19
utf8_general_ci in db. – user2219963 Apr 10 '19 at 11:20
i have this header `header('Content-Type: text/html; charset=UTF-8');` but But it's not work. The result is with ¤ – user2219963 Apr 10 '19 at 11:25
thans very mutch – user2219963 Apr 10 '19 at 12:59
@user2219963 you're welcome. If the answer helps you don't forget to mark it correct to help other people. – sayou Apr 11 '19 at 08:37

1 Answers1