title: Display BigInt DataType of length 10 in Excel Sheet using PHP
body: <p>I want to make a excel file by fetching data from database. Every thing works fine but the phone number field return unknown value in excel sheet but it displays correct value in browser.</p>
  
  <pre><code>&lt;?php
   include('connection.php');
      header( "Content-Type: application/vnd.ms-excel" );
      header( "Content-disposition: attachment; filename=spreadsheet.xls" );
                          $q = mysql_query("select * from members order by id desc");
  
                          echo 'First Name' . "\t" . 'email' . "\t" . 'Phone' . "\t". 'address' . "\t". 'Membership Number' . "\t". 'Membership Category' . "\n";
  
                          while($r = mysql_fetch_array($q))
                          {
                              $name = $r['name'];
                              $email = $r['email'];
                              $phone = $r['phone'];
                              $address = $r['address'];
                              $mem_num = $r['mem_num'];
                              $mem_cat = $r['mem_category'];
                          echo "$name"."\t"."$email"."\t"."$phone"."\t"."$address"."\t"."$mem_num"."\t"."$mem_cat"."\n";
                          }
                      mysql_close($con);
  ?&gt;
  </code></pre>
  
  <p><img src="https://content.screencast.com/users/Dalvik/folders/Jing/media/170a5c4c-7315-4125-b47d-68fb44c69fb1/2015-01-21_2355.png" alt="Screenshot"></p>