The & symbol in mysql queries

[imperium2335]

Hi,

 

This is a problem that keeps cropping up.

 

I know the hex code for & is %26, but what function in PHP can convert %26 into the & symbol for display purposes, and use %26 for mysql and url purposes?

[teynon]

The function you are specifically referring to is urlencode($string); decode using urldecode($string);

 

However, you could also htmlspecialchars($value, ENT_QUOTES); then when you retrieve the results, use htmlspecialchars_decode($value);

[LeadingWebDev]

$s=''; 
foreach(explode("\n",trim(chunk_split($string,2))) as $h) 
     $s.=chr(hexdec($h)); 

[imperium2335]

There is still a problem when it comes to URLs.

 

I have Hartmann%20%26%20Braun.html in my URL, but when I use GET and echo it I just get Hartmann.

[teynon]

Can we see your code? Its hard to tell what you are trying to do.

[imperium2335]

the url "manufacturer-Hartmann%20&%20Braun.html" is a rewrite which follows:

 

RewriteRule manufacturer-results/manufacturer-(.*)\.html$ manufacturer-results.php?manufacturer=$1

 

But I don't think that is the problem?

 

echo $query = $_GET['family'] ;

gives me 'Hartmann'

[imperium2335]

Does anyone have any ideas? Even with urlencoding the & symbol it still doesnt work.