php page not displaying arabic text

Question

I have a PHP page where I am trying to display Arabic text but its showing.

In MySQL database I'm storing arabic text successfully.

I'm using the following code to connect to the database :

function connect(){
$this->dbLink = mysql_connect($this->dbHost,$this->dbUser,$this->dbPass);   
if(!$this->dbLink) die("Could not connect to database. " . mysql_error());
mysql_select_db($this->dbName);
mysql_set_charset("utf8", $this->dbLink); 
}

And using the following header in the PHP page :

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

But still no success.

Thanks for helping.

your browser should show you the character set and let you change it. — , Aug 29 '11 at 20:31
@yoda the problem is Arabic text didn't display it only echo ?????? — air, Aug 29 '11 at 20:33
@yoda its in localhost, see the page is working fine like if i put Arabic text in page, it display properly but only text coming from database display ????? — air, Aug 29 '11 at 20:36
as i said before i am using this statement in connection mysql_set_charset("utf8", $this->dbLink); — air, Aug 29 '11 at 20:41
You are mixing up PHP and HTML. It's the **HTML** page, not displaying Arabic text and it's not "header in the PHP page" but META-information to the HTML-site. — feeela, Aug 29 '11 at 20:44

Yusuf ali · Accepted Answer · 2011-08-29T21:15:09.513

3

You can use this meta code:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

And please check mysql column's character type..

Look to this

edited Aug 29 '11 at 21:15

answered Aug 29 '11 at 20:37

Yusuf ali

331
1
6
15

i have same meata and column's character type is utf and collection is utf_general_ci and as i said, Arabic is saving properly in database. – air Aug 29 '11 at 20:40
shortly you hava problem ,when you select data? true? – Yusuf ali Aug 29 '11 at 20:48

score 3 · Answer 2 · answered Aug 29 '11 at 21:03

3

check the file encoding, it should be UTF-8, and you can try to run the following query before querying the text:

mysql_query("SET NAMES UTF8");

answered Aug 29 '11 at 21:03

Headshota

21,021
11
61
82

score 1 · Answer 3 · answered Aug 29 '11 at 20:38

1

Addtional to the headers set in the meta section, check your default_charset setting in the php.ini. default_charset should be empty if you set content type header by your own or correspond with your content-type meta information.

answered Aug 29 '11 at 20:38

Christoph Jeschke

36
1

score 1 · Answer 4 · answered Aug 29 '11 at 20:41

You set a META-tag that tells the browser to use ISO-8859-1 (<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />), which is for latin-based scripts, but surely not Arabic.

Also make sure you have UTF-8 at all places:

the DB-column
the DB-connection (you already have it)
the website (via HTTP-header OR META-tag, you don't need both, and you don't need a second META-tag, as stated above…)

score 0 · Answer 5 · answered May 09 '14 at 02:29

0

Try to add this two lines to your php script after the Mysql connection

mysql_query("SET NAMES cp1256"); mysql_query("set character set cp1256");

answered May 09 '14 at 02:29

rhoula

31
2

score 0 · Answer 6 · answered Sep 12 '11 at 11:41

0

Have you tried setting the connection to use UTF-8 (with mysql_set_charset)?

answered Sep 12 '11 at 11:41

Mihai Nita

5,547
27
27

php page not displaying arabic text

6 Answers6