What is up with urldecode() ?!?!?!

marms

I have a very strange issue with urldecode() on a urlencode() string. I have situation where I have to pass a SQL string through a URL to pull off some client side XML mail merge to WORD stuff. It largely works until the user does a query with a paticular city in it. Here is the example

" City like '%edmond%' "

after I urlencode() it this becomes--

" City+like+%27%25edmond%25%27 "

after I urldecode() on the other page it becomes--

" City like 'ímond%' "

What is up with that?!?!?

Obviously this returns no result set back which causes the mail merge to fail.

Any ideas?

Thanks

nnichols

It is because you are using urldecode on the variable when you don't need to (effectively you're doing it twice). The variable you get in the following page has already been decoded by php.

Run the following script and you will see what I mean -

<?
$var = " City like '%edmond%' ";
echo '$var = "' . $var . '"<br>';

$var = urlencode($var);
echo 'urlencode($var) = "' . $var . '"<br>';

$var = urldecode($var);
echo 'urldecode($var) = "' . $var . '"<br>';

$var = urldecode($var);
echo 'urldecode($var) again = "' . $var . '"<br>';

?>

Hope this helps 😉