arabic characters doesn't appear in exported excel file

[setovan]

hi guys i am using the following code to export a table in my DB in excel sheet

 

<?php
mysql_query("set names utf8");


mysql_connect('localhost','root','admin');
mysql_select_db('mms');

   $result=mysql_query("select * from test");
   function xlsBOF()
   {
   echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0);
   return;
   }
   function xlsEOF()
   {
   echo pack("ss", 0x0A, 0x00);
   return;
   }
   function xlsWriteNumber($Row, $Col, $Value)
   {
   echo pack("sssss", 0x203, 14, $Row, $Col, 0x0);
   echo pack("d", $Value);
   return;
   }
   function xlsWriteLabel($Row, $Col, $Value )
   {
   $L = strlen($Value);
   echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L);
   echo $Value;
   return;
   }
   header("Pragma: public");
   header("Expires: 0");
   header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
   header("Content-Type: application/force-download");
   header("Content-Type: application/octet-stream");
   header("Content-Type: application/download");;
   header("Content-Disposition: attachment;filename=list.xls");
   header("Content-Transfer-Encoding: binary ");
   xlsBOF();

   xlsWriteLabel(0,0,"id");
   xlsWriteLabel(0,1,"name");
   $xlsRow = 1;
   while($row=mysql_fetch_array($result))
   {
   xlsWriteNumber($xlsRow,0,$row['id']);
   xlsWriteLabel($xlsRow,1,$row['name']);
   $xlsRow++;
   }
   xlsEOF();
   ?>

and i have tried a lot to solve this problem for exporting arabic data in excel sheet from database but i can't find a solution. so please help me

 

[setovan]

the data appears "????"

[silkfire]

Where did you get this code from?

 

There are Excel libraries out there, why are you making your own binary functions??

[setovan]

Where did you get this code from?

 

There are Excel libraries out there, why are you making your own binary functions??

i am just a beginner and not familiar with PHP i got it from another forum so if there is any other method that export the excel with arabic characters please tell me thanks

[setovan]

any help !