SitePoint Sponsor

User Tag List

Results 1 to 1 of 1
  1. #1
    SitePoint Member
    Join Date
    Oct 2010
    0 Post(s)
    0 Thread(s)

    Mysql Arabic table WhicH i want to excell/csv

    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
    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']."; ";
    $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;
    Attached Files Attached Files
    Last edited by TechnoBear; Dec 5, 2012 at 06:43. Reason: Code tags added

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts