Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Create file and exit;
- $filename = $file."_".date("Y-m-d_H-i",time());
- header("Content-type: application/vnd.ms-excel");
- header("Content-disposition: csv" . date("Y-m-d") . ".csv");
- header( "Content-disposition: filename=".$filename.".csv");
- echo $csv_output;
- // Create file and exit;
- $filename = $file."_".date("Y-m-d_H-i",time());
- header("Content-type: text/csv; charset=ISO-8859-1");
- header("Content-disposition: csv" . date("Y-m-d") . ".csv");
- header("Content-disposition: filename=".$filename.".csv");
- echo iconv('UTF-8', 'ISO-8859-1', $csv_output);
- mysql> SHOW COLUMNS FROM fraud_report;
- +--------------+--------------+------+-----+---------+----------------+
- | Field | Type | Null | Key | Default | Extra |
- +--------------+--------------+------+-----+---------+----------------+
- | id | mediumint(9) | | PRI | NULL | auto_increment |
- | crm_number | varchar(32) | YES | | NULL | |
- | datacash_ref | varchar(32) | YES | | NULL | |
- | amount | varchar(32) | YES | | NULL | |
- | sales_date | varchar(32) | YES | | NULL | |
- | domain | varchar(32) | YES | | NULL | |
- | date_added | datetime | YES | | NULL | |
- | agent_added | varchar(32) | YES | | NULL | |
- +--------------+--------------+------+-----+---------+----------------+
- 8 rows in set (0.03 sec)
- function processFraudForm($crm_number, $datacash_ref, $amount, $sales_date, $domain, $agent_added) {
- // Insert Data to DB
- $sql = "INSERT INTO fraud_report (id, crm_number, datacash_ref, amount, sales_date, domain, date_added, agent_added) VALUES (NULL, '$crm_number', '$datacash_ref', '$amount', '$sales_date', '$domain', NOW(), '$agent_added')";
- $result = mysql_query($sql) or die (mysql_error());
- if ($result) {
- $outcome = "<div id="success">Emails sent and database updated.</div>";
- } else {
- $outcome = "<div id="error">Something went wrong!</div>";
- }
- return $outcome;
- }
- +----+------------+--------------+---------+------------+--------------------+---------------------+------------------+
- | id | crm_number | datacash_ref | amount | sales_date | domain | date_added | agent_added |
- +----+------------+--------------+---------+------------+--------------------+---------------------+------------------+
- | 13 | 100xxxxxxx | 10000000 | £10.93 | 18/12/08 | blargh.com | 2008-12-22 10:53:53 | agent.name |
- print iconv('UTF-8', 'ASCII//TRANSLIT', "Mystring â"); //"Mystring "
Add Comment
Please, Sign In to add comment