export arabic data to csv format

farukcse

Dear Sir,

I have a PHP script that export CSV with arabic text, for example I download the CSV on the website then save to desktop of my computer and Open it on NOTEPAD... that works fine I could still see all the arabic text OK with no problem, but if I open the CSV file in Microsoft EXCEL, all the arabic text are busted and no longer readable.
arabic text is inserted and stored in database as UTF-8 format.

Do you know a solution for this, how could I make it work OK on MS Excel, because the user want it to view the CSV file in Excel and this is so much urgent for me . please reply.

Regards,
Fauk Chowdhury.

Expand|Select|Wrap|Line Numbers

  
<?php

// Connect to database

mysql_connect("localhost", "root", "root123");

mysql_select_db("medgulf");
 
 $fname = date("d-m-Y");

// mention the file name to display in download prompt

$file_name = "$fname.csv";
 
header("Content-Disposition: attachment; filename=\"$file_name\"");

header("Cache-Control: cache, must-revalidate");

header("Pragma: public");

header('Content-Type: text/xml,  charset=UTF-8; encoding=UTF-8');
 
$fd1 = $_POST['fd'];

$fm1 = $_POST['fm'];

$fy1 = $_POST['fy']; 

// Output header

//echo "Name, Code"."\n";

$frmday = $fy1."-".$fm1."-".$fd1;

$ld1 = $_POST['ld'];

$lm1 = $_POST['lm'];

$ly1 = $_POST['ly']; 
 
$today = $ly1."-".$lm1."-".$ld1;

//echo $frmday;

$usrname = $_POST['usname'];

$export_date = date("Y-m-d");
 
$result = mysql_query("SELECT product, agent_code, policy_no, DATE_FORMAT(entry_date, '%d/%m/%Y'), DATE_FORMAT(inception_date_eng, '%d/%m/%Y'), DATE_FORMAT(inception_date_hijri, '%d/%m/%Y'), DATE_FORMAT(expiry_date_eng, '%d/%m/%Y'), DATE_FORMAT(expiry_date_hijri, '%d/%m/%Y'), client_info.first_name, client_info.family_name, client_info.father_name, client_info.grand_father_name, client_info.mobile_no, client_info.dob, client_info.p_o_box, client_info.zip_code, client_info.city, client_info.id_type, client_info.id_no, vehicle_type, license_type, net_premium, brandname, model, reg_type, plate_no, model_year, chassis_no, color, user_name, age_limit  FROM vehicle_info, client_info where vehicle_info.policy_no = client_info.sr AND entry_date BETWEEN '$frmday' AND '$today' AND  user_name='$usrname' AND exported='yes' ");

$str = mb_convert_encoding($result, "UTF-8", "ASCII");

echo "encode $str";
 
if($result) {

while($rs = mysql_fetch_array($result))

{    echo $rs[0].", ";

    echo $rs[1].", ";

    echo $rs[2].", ";

    echo $rs[3].", ";

    echo $rs[4].", ";

    echo $rs[5].", ";

    echo $rs[6].", ";

    echo $rs[7].", ";

    echo $rs[8].", ";

    echo $rs[9].", ";

    echo $rs[10].", ";

    echo $rs[11].", ";

    echo $rs[12].", ";

    echo $rs[13].", ";

    echo $rs[14].", ";

    echo $rs[15].", ";

    echo $rs[16].", ";

    echo $rs[17].", ";

    echo $rs[18].", ";

    echo $rs[19].", ";

    echo $rs[20].", ";

    echo $rs[21].", ";

    echo $rs[22].", ";

    echo $rs[23].", ";

    echo $rs[24].", ";

    echo " ".", ";

    echo $rs[25].", ";

    echo $rs[26].", ";

    echo $rs[27].", ";

    echo $rs[28].", ";

    echo " ".", ";

    echo " ".", ";

    echo $rs[29].", ";

    echo $rs[30].", ";

}
 
$result4 = mysql_query("UPDATE vehicle_info SET exported ='yes', exported_date='$export_date'   WHERE user_name ='$usrname'");
 
if (!$result4) {

           die('Query failed: To Vehicle Info Table ');

            }
 
}

else {
 
echo "There Is No Data To Export ";
 
}
 
?>

pbmods

Heya, Fauk.

Make sure you're setting your MySQL connection encoding:

Expand|Select|Wrap|Line Numbers

 
mysql_query("SET NAMES 'utf-8'", $conn);

mysql_query("SET CHARACTER SET 'utf-8'", $conn);

Where $conn is your MySQL connection resource.

export arabic data to csv format

re: export arabic data to csv format

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about