Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require_once("../db.php");
- $contents="Database Id,Name,Amount,Cheque/Cash,Bank,Cheque Date,Branch,Address,Receipt No,Receipt Daten";
- $user_query = mysql_query("SELECT * from tablename ORDER BY RAND()");
- $contents = strip_tags($contents);
- header("Content-Disposition: attachment; filename=my_file_".date('d-F-Y').".csv");
- $out = fopen('php://output', 'w');
- fputcsv($out, array('Database Id', 'NAME', 'AMOUNT', 'CHEQUE/CASH DETAILS' , 'BANK' , 'CHEQUE DATE' , 'BRANCH', 'ADDRESS', 'RECEIPT NUMBER', 'RECEIPT DATE'));
- while ($row = mysql_fetch_assoc($user_query)) {
- fputcsv($out, $row);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement