Mysql Arabic Table Which I Want To Excell/csv

[peterman5]

Hello

I have mysql tables where the text is arabic, I want to export them to Excell, If this is not possible , then to csv and then to excell,

 

How I can do that, I have the phpmyadmin, It is not necessary that I do it through php, but if there is no other choice, i will do it through php

 

I have written php code, but the result is that the arabic gives me ????

 

 

Help is appreciated

 

This is the code

<?php

$host = 'localhost';

$user = 'user';

$pass = 'password';

$db = 'db';

$table = 'table';

$file = 'Subscribers';

$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());

mysql_select_db($db) or die("Can not connect.");

@mysql_query('SET NAMES utf8');

@mysql_query("SET CHARACTER SET 'utf-8'");

$result = mysql_query("SHOW COLUMNS FROM ".$table."");

$i = 0;

if (mysql_num_rows($result) > 0)

{

while ($row = mysql_fetch_assoc($result))

{

$csv_output .= $row['Field']."; ";

$i++;

}

}

$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");

while ($rowr = mysql_fetch_row($values))

{

for ($j=0;$j<$i;$j++)

{

$csv_output .= $rowr[$j]."; ";

}

$csv_output .= "\n";

}

header("Content-Type: text/x-csv; chartset=utf-8");

header("Content-Disposition: attachment; filename=file.csv");

header("Pragma: no-cache");

header("Expires: 0");

print $csv_output;

exit;

?>

csv.php

excell.php