HTML Characters in MySQL PHP

Question

In my database i have the following information

one for each row.

s=evil+dead&Search.x=0&Search.y=0
s=algoritmos&Search.x=20&Search.y=19
s=clavez+para+pc+optimizer+pro&Search.x=-1028&Search.y=-5
s=pc+optimizer+pro
s=fairy+tail&Search.x=30&Search.y=24
s=optimizer+pro&Search.x=14&Search.y=13
s=linares
s=optimicer+pro&Search.x=0&Search.y=0
s=optimizer+pro
s=optimizer+pro&Search.x=-1071&Search.y=-5
s=Escribe+un+pseudoc%C3%B3digo+que+reciba+2+del+usuario%3A&Search.x=-1071&Search.y=-5

When i print them on php looks like

Escribe+un+pseudoc%C3%B3digo+que+reciba+2+argumentos+de+parte+del+usuario%3A

So i need to replace characters like those

%C3%B3 for o
+ for a space

Is there a way to do it via php and not to use an array of strings with each code?

have you tried taking a look at urldecode function

Satya
– Satya

2013-04-26 03:30:11 +00:00
Commented Apr 26, 2013 at 3:30 — Satya
– Satya, Commented Apr 26, 2013 at 3:30

raidenace · Accepted Answer · 2013-04-26 03:32:26Z

2

I think urldecode should do it for you.

answered Apr 26, 2013 at 3:32

raidenace

12.8k1 gold badge34 silver badges35 bronze badges

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

Comments

AmbrosiaDevelopments · Accepted Answer · 2013-04-26 03:40:16Z

0

Demo.

<?php

echo urldecode("Escribe+un+pseudoc%C3%B3digo+que+reciba+2+argumentos+de+parte+del+usuario%3A");

?>

answered Apr 26, 2013 at 3:40

AmbrosiaDevelopments

2,59221 silver badges28 bronze badges

Collectives™ on Stack Overflow

HTML Characters in MySQL PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related