Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $MYSQL_HOST="localhost";
- $MYSQL_USERNAME="root";
- $MYSQL_PASSWORD="";
- $MYSQL_DATABASE="paesana";
- $MYSQL_TABLE="ds_orders";
- mysql_connect( "$MYSQL_HOST", "$MYSQL_USERNAME", "$MYSQL_PASSWORD" ) or die( mysql_error( ) );
- mysql_select_db( "$MYSQL_DATABASE") or die( mysql_error( $conn ) );
- $filename="ePay";
- $csv_filename = $filename."_".date("Y-m-d_H-i",time()).".csv";
- header("Content-Type: application/vnd.ms-excel");
- $today="2008-12-21";
- $sql = "SELECT * FROM $MYSQL_TABLE where cDate='$today'";
- $result=mysql_query($sql);
- if(mysql_num_rows($result)>0){
- $fileContent="Beneficiary Name,Beneficiary Account No,Beneficiary Bank Code,Transaction Amount,Narrationn";
- while($data=mysql_fetch_array($result))
- {
- $fileContent.= "".$data['customer_id'].",".$data['oNum'].","."$today".",".$data['cShipService']." ".$data['cShipMethod'].",".$data['cEmail'].",".$data['ccType'].",".$data['cShipInstruct'].",".$data['cShipFname']." ".$data['cShipLname']."n";
- }
- $fileContent=str_replace("nn","n",$fileContent);
- echo $fileContent;
- }
- header("content-disposition: attachment;filename=$csv_filename"); ?>
- $csv_filename = $filename."_".date("Y-m-d_H-i",time()).".csv";
- $fd = fopen ($csv_filename, "w");
- echo $fileContent;
- fputs($fd, $fileContent);
- fclose($fd);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement