snipplrCallback({"id":46808,"title":"export-mysql-to-excel--csv-via-php","source":"
  1. <?php<\/span><\/div><\/li>
  2. include<\/span> 'config.php'<\/span>;<\/span><\/div><\/li>
  3. include<\/span> 'opendb.php'<\/span>;<\/span><\/div><\/li>
  4.  <\/div><\/li>
  5. $select<\/span> =<\/span> "SELECT * from table_name"<\/span>;<\/span><\/div><\/li>
  6.  <\/div><\/li>
  7. $export<\/span> =<\/span> mysql_query<\/span><\/a> (<\/span> $select<\/span> )<\/span> or die<\/span><\/a> (<\/span> "Sql error : "<\/span> .<\/span> mysql_error<\/span><\/a>(<\/span> )<\/span> )<\/span>;<\/span><\/div><\/li>
  8.  <\/div><\/li>
  9. $fields<\/span> =<\/span> mysql_num_fields<\/span><\/a> (<\/span> $export<\/span> )<\/span>;<\/span><\/div><\/li>
  10.  <\/div><\/li>
  11. for<\/span> (<\/span> $i<\/span> =<\/span> 0<\/span>;<\/span> $i<\/span> <<\/span> $fields<\/span>;<\/span> $i<\/span>++<\/span> )<\/span><\/div><\/li>
  12. {<\/span><\/div><\/li>
  13.     $header<\/span> .=<\/span> mysql_field_name<\/span><\/a>(<\/span> $export<\/span> ,<\/span> $i<\/span> )<\/span> .<\/span> "\\t<\/span>"<\/span>;<\/span><\/div><\/li>
  14. }<\/span><\/div><\/li>
  15.  <\/div><\/li>
  16. while<\/span>(<\/span> $row<\/span> =<\/span> mysql_fetch_row<\/span><\/a>(<\/span> $export<\/span> )<\/span> )<\/span><\/div><\/li>
  17. {<\/span><\/div><\/li>
  18.     $line<\/span> =<\/span> ''<\/span>;<\/span><\/div><\/li>
  19.     foreach<\/span>(<\/span> $row<\/span> as<\/span> $value<\/span> )<\/span><\/div><\/li>
  20.     {<\/span>                                            <\/div><\/li>
  21.         if<\/span> (<\/span> (<\/span> !<\/span>isset<\/span><\/a>(<\/span> $value<\/span> )<\/span> )<\/span> ||<\/span> (<\/span> $value<\/span> ==<\/span> ""<\/span> )<\/span> )<\/span><\/div><\/li>
  22.         {<\/span><\/div><\/li>
  23.             $value<\/span> =<\/span> "\\t<\/span>"<\/span>;<\/span><\/div><\/li>
  24.         }<\/span><\/div><\/li>
  25.         else<\/span><\/div><\/li>
  26.         {<\/span><\/div><\/li>
  27.             $value<\/span> =<\/span> str_replace<\/span><\/a>(<\/span> '"'<\/span> ,<\/span> '""'<\/span> ,<\/span> $value<\/span> )<\/span>;<\/span><\/div><\/li>
  28.             $value<\/span> =<\/span> '"'<\/span> .<\/span> $value<\/span> .<\/span> '"'<\/span> .<\/span> "\\t<\/span>"<\/span>;<\/span><\/div><\/li>
  29.         }<\/span><\/div><\/li>
  30.         $line<\/span> .=<\/span> $value<\/span>;<\/span><\/div><\/li>
  31.     }<\/span><\/div><\/li>
  32.     $data<\/span> .=<\/span> trim<\/span><\/a>(<\/span> $line<\/span> )<\/span> .<\/span> "\\n<\/span>"<\/span>;<\/span><\/div><\/li>
  33. }<\/span><\/div><\/li>
  34. $data<\/span> =<\/span> str_replace<\/span><\/a>(<\/span> "\\r<\/span>"<\/span> ,<\/span> ""<\/span> ,<\/span> $data<\/span> )<\/span>;<\/span><\/div><\/li>
  35.  <\/div><\/li>
  36. if<\/span> (<\/span> $data<\/span> ==<\/span> ""<\/span> )<\/span><\/div><\/li>
  37. {<\/span><\/div><\/li>
  38.     $data<\/span> =<\/span> "\\n<\/span>(0) Records Found!\\n<\/span>"<\/span>;<\/span>                        <\/div><\/li>
  39. }<\/span><\/div><\/li>
  40.  <\/div><\/li>
  41. header<\/span><\/a>(<\/span>"Content-type: application\/octet-stream"<\/span>)<\/span>;<\/span><\/div><\/li>
  42. header<\/span><\/a>(<\/span>"Content-Disposition: attachment; filename=your_file_name.xls"<\/span>)<\/span>;<\/span><\/div><\/li>
  43. header<\/span><\/a>(<\/span>"Pragma: no-cache"<\/span>)<\/span>;<\/span><\/div><\/li>
  44. header<\/span><\/a>(<\/span>"Expires: 0"<\/span>)<\/span>;<\/span><\/div><\/li>
  45. print<\/span> "$header<\/span>\\n<\/span>$data<\/span>"<\/span>;<\/span><\/div><\/li>
  46.  <\/div><\/li>
  47. ?><\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/46808\/export-mysql-to-excel--csv-via-php"});