Databases
StackOverflow2013
Postsdbo
POphp preg_replace € sign with "euro"
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphp preg_replace € sign with "euro"
    primarykey
    data
    text
    <p>I would like to replace the € sign in $XML_COMMENT with "euros" before adding to a xml file.</p> <p>The € sign not being a utf-8 character I get and error message from simplexml</p> <pre><code>Warning: SimpleXMLElement::addAttribute(): string is not in UTF-8 in ... Warning: SimpleXMLElement::asXML(): output conversion failed due to conv error, bytes 0x82 0x26 0x61 0x6D in .... </code></pre> <p>The euro sign appears in the MySQL (utf-8) database as '€'</p> <p>But appears correctly in the textarea on the webpage.</p> <p>I tried to use these different str_replace </p> <pre><code>$XML_COMMENT=str_replace('€','euros',$XML_COMMENT) $XML_COMMENT=str_replace('€','euros',$XML_COMMENT) $XML_COMMENT=str_replace(chr(128),'euros',$XML_COMMENT) $XML_COMMENT=str_replace(chr(0xE2).chr(0×82).chr(0xAC),'euros',$XML_COMMENT) $XML_COMMENT=str_replace(chr(0x82).chr(0x26).chr(0x61).chr(0x6D),'euros',$XML_COMMENT) </code></pre> <p>without success</p> <p>FYI: I'm using utf-8 everywhere (MySQL, Web Page and XML)</p> <p>Here's my code</p> <pre><code>// ? : $XML_COMMENT= "bla bla bla € bla bla bla"; // ? : $XML_COMMENT= "bla bla bla € bla bla bla"; // expected : $XML_COMMENT= "bla bla bla euros bla bla bla"; $ProductLog_XML = simplexml_load_file($file); $ProductUpdate = $ProductLog_XML-&gt;order-&gt;product-&gt;addChild('update'); $ProductUpdate-&gt;addAttribute('comment',$XML_COMMENT); $fp=fopen(file, "w"); fwrite($fp, $ProductLog_XML-&gt;asXML()); fclose($fp); </code></pre> <p>Is there any alternative using regex / preg_replace ?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USbaptme
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO`I'm using utf-8 everywhere.` No you're not. Most likely your editor is misconfigured and uses another encoding.
      singulars
      1. POphp preg_replace € sign with "euro"
      1. USphihag
    2. COi checked it with utf-8 yes it dosent work with utf-8 encoding where as when i removed the meta tag which specified my charset it worked properly!!!!! ---- Unable to understand :( whats going which type of character is it?
      singulars
      1. POphp preg_replace € sign with "euro"
      1. USVipin Jain
    3. CO@phihag what makes you say that? I don't think the editor has anything to do with my problem since $XML_COMMENT comes from a utf-8 MySQL table fed by a utf-8 webpage.
      singulars
      1. POphp preg_replace € sign with "euro"
      1. USbaptme
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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