SitePoint Sponsor

User Tag List

Results 1 to 1 of 1

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Oct 2010
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql Arabic table WhicH i want to excell/csv

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


Tags for this Thread

Bookmarks

Posting Permissions

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