Advertisement
Guest User

Untitled

a guest
Sep 18th, 2014
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. require_once("../db.php");
  2.  
  3. $contents="Database Id,Name,Amount,Cheque/Cash,Bank,Cheque Date,Branch,Address,Receipt No,Receipt Daten";
  4. $user_query = mysql_query("SELECT * from tablename ORDER BY RAND()");
  5.  
  6.  
  7. $contents = strip_tags($contents);
  8.  
  9.  
  10.  
  11. header("Content-Disposition: attachment; filename=my_file_".date('d-F-Y').".csv");
  12. $out = fopen('php://output', 'w');
  13. fputcsv($out, array('Database Id', 'NAME', 'AMOUNT', 'CHEQUE/CASH DETAILS' , 'BANK' , 'CHEQUE DATE' , 'BRANCH', 'ADDRESS', 'RECEIPT NUMBER', 'RECEIPT DATE'));
  14.  
  15. while ($row = mysql_fetch_assoc($user_query)) {
  16. fputcsv($out, $row);
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement