Thursday 15 May 2014

arabic characters insertion php mysql XML Parsing Error: not well-formed -


Below is the content I am trying to include in textbox ( Maxlength = 50 ) and saved in mysql database records.

`(2) Ø ¥ yu ?? Ø'اء¡ Ø · U ?? Hey ت٠?? U ?? U ?? ع Ø'Ù ?? Ø§Ø¯Ø © Ù ?? Ù ?? ا٠?? Ù ?? Ù ?? § § §? Ø Ù Ù Ø Ø Ø Ø ?? ا٠?? Ø® § Ø ¨? Ù ?? ØÙ ?? ظ٠?? ا ع٠?? Ù ?? ا٠?? Ù ?? Ø ± Øμ

(3) تØÙ ?? Ù ?? Ù ?? Ø ?? ت٠?? Ù ?? Ù ?? ع Ø · Ù? Ø Ø Ø Ø Ø Ø ØØØØØØØØØ Ø Ø ?? Ø ± ت ت٠?? Ù ?? Ù? ع Ø · Ù? ँ ँ ¥ Ù ?? Ù ?? Where ?? ØØØØØ © U ± U ?? § U ?? Ø

(4) § U ?? ØªØ¸Ø ± u ?? ت٠?? Ù ?? Ù ?? For OØØØØØØØØØØØØØØ ØØØØØØØØØØØØ ØØØØØØØ ØØØØØØÙ U ?? U ?? ا٠?? Ø'Ù ?? Ø§Ø¯Ø © (Ù ?? Ù? اÙ? Ø © اÙ? Ø £ Ù? Ø Ø § ¡¡¡¡¡¡§§?? Ø¬Ø²Ø§Ø | Ø ± U? Ø © _ u ?? Ø · u ?? Ø ± _ § u ?? u ?? u ?? u ?? æ © § u ?? Ø³Ø ± Ø · ا٠??) a ???? Line Ù ?? Ù ?? Where ?? ØØØØØ © U ± U ?? § U ?? Ø Ø ¥ Ø ° ا u ?? u ?? ت u ?? u ?? ØØ§Ø¬Ø © U ?? ØªØ Ø¯l ?? O u ?? Ø ° Ù ?? س٠?? Ø ± ØªØ ?? u ?? u ?? u ?? تØت u ?? Ø¹Ø ± u ?? § u ?? ØªØ · ou ?? u ?? § u ?? Ø ° Ù ?? u ?? u ?? ت o ¥ yu ?? Ø'Ø§Ø | Ù ?? u ?? u?? § u ?? Ø®Ø · u ?? Ø © 1o ?? u ?? اخ ¡°? Ø§Ø ± ا٠?? ع٠?? u ?? ت٠?? u ?? u ?? u ??)

(5) Øا٠?? O (Ø £ Ù ?? تس٠?? u ?? ت٠?? ا Ø ¥ Ø ° ا u ?? u ?? ت ت٠?? ض٠?? Ø ° Ù ?? Ù ??) Ù? ? Ø ° Ù ?? ا٠?? Ù ?? Ù ?? Ù ?? Ø § § 2 (اÙ? Ø®Ø · Ù ?? ese 2 Ù ?? 4) Ù ?? Ù ?? U ?? U ?? § U ?? Ø ¢ U ?? U ?? U ?? O تØØØا ü ?? Ø'Ù ?? ØØØØØ © ت٠?? U ?? U ?? ع Ø · u ?? Hey ت٠?? U ?? U ?? ع Ø · Ù ?? ب سÙ? Ø ± ت Ù ?? Ù ?? Ù ?? U ?? Ø · u ?? Hey س٠?? Ø ± ت جد¯ ?? U © U ?? U ?? § U ?? Where ?? U ?? Ø § Ù Ø Ø Ù Ø Ø Ø Ù Ù ?? Ù ?? § U ?? U ?? ست٠?? Where ?? Ø £ Ù ?? Ø Ø Ø Ø ¯ Ù? Ø Ø ³Ù ³Ù ³Ù ± ± Ù Ù ?? Ù ?? § U ?? ع٠?? Ø ± ع٠?? Where ?? §§ § U ?? ت٠?? ت ØμÙ ?? اØÙ ?? ت٠?? It is saved when it shows: Ø'اء¡ Ø · U ?? Hey ت٠?? U ?? U ?? ع Ø'Ù ?? Ø§Ø¯Ø © Ù ?? Ù ?? ¿½

and gives an error with XML parsing, I am using the htmlspecialchars function before returning to XML - but it does not work here is.

& lt ;? Xml version = "1.0" encoding = "UTF-8" standalone = "yes"?

I have utf-8 as well as XML output

any idea, how to remove it.

The first response will be appreciated.

Use php properly in the Mysql database to read, write and sort Arabic text , Make sure that:

1- MySQL charset: UTF-8 Unicode (UTF 8)

2- MySQL Connection Match: utf8_general_ci

3- Your database And tableclothes is set to: utf8_general_ci or utf8_unicode_ci

Then, when you are connected to DB, add this code to your php script:

  mysql_query ("set Name 'utf8' "); Mysql_query ('set character settings utf8');   

Source :.

No comments:

Post a Comment