Databases
StackOverflow2013
Postsdbo
POPHP str_replace slash and quote
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP str_replace slash and quote
    text
    copied!<p>I had my data called from db with words contained <code>'</code> such as <code>company's</code> and some words display like <code>company\\\\\'s</code>, despite I had a function to replaced all those special characters into normal, but wording like <code>company\'s</code> is still around. Is there any proper way to replace all kind of special characters properly? </p> <pre><code>function chrEncode($data) { $data = str_replace('’', '&amp;#39;' ,$data); $data = str_replace('é', 'é' ,$data); $data = str_replace('â€', '-' ,$data); $data = str_replace('-œ', '&amp;#34;' ,$data); $data = str_replace('“', '&amp;#34;' ,$data); $data = str_replace('ê', 'ê' ,$data); $data = str_replace('ö', 'ö' ,$data); $data = str_replace('…', '...' ,$data); $data = str_replace('-¦', '...' ,$data); $data = str_replace('–', '–' ,$data); $data = str_replace('′s', '’' ,$data); $data = str_replace('-²s', '’' ,$data); $data = str_replace('‘', '&amp;#39;' ,$data); $data = str_replace('-˜', '&amp;#39;' ,$data); $data = str_replace('-“', '-' ,$data); $data = str_replace('è', 'è' ,$data); $data = str_replace('（', '(' ,$data); $data = str_replace('）', ')' ,$data); $data = str_replace('•', '&amp;bull;' ,$data); $data = str_replace('-¢', '&amp;bull;' ,$data); $data = str_replace('§', '&amp;bull;' ,$data); $data = str_replace('®', '&amp;reg;' ,$data); $data = str_replace('â„¢', '&amp;trade;' ,$data); $data = str_replace('ñ', 'ñ' ,$data); $data = str_replace('Å‘s', 'ő' ,$data); $data = str_replace('\\\"', '&amp;quot;' ,$data); $data = str_replace("\r", '&lt;br&gt;' ,$data); $data = str_replace("\\r", '&lt;br&gt;' ,$data); $data = str_replace("\n", '&lt;br&gt;' ,$data); $data = str_replace("\\n", '&lt;br&gt;' ,$data); $data = str_replace("\\\'", '&amp;#39' ,$data); $data = str_replace("'", "&amp;#39" ,$data); return $data; } </code></pre> <p>Please advise, thanks!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload