Search the Community

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