/courses/schedulecsv.php
PHP | 100 lines | 77 code | 5 blank | 18 comment | 10 complexity | c578ea3014729b4a3e606bc993ef61ac MD5 | raw file
Possible License(s): BSD-3-Clause
- <?php
- //require_once('../Connections/bryanmadge.php');
- $hostname = "localhost";
- $database = "wf-c32a-0dfcce";
- $username = "wf-c32a-0dfcce";
- $password = "bma";
- $bryanmadge = mysql_connect($hostname, $username, $password) or trigger_error(mysql_error(),E_USER_ERROR);
- require_once('../includes/config.php'); // must always be a relative path
- //require_once('../includes/FirePHPCore/fb.php');
- $sql = "SELECT c.catalog_id AS Code,
- 'No' AS 'Web',
- 'No' AS 'Demand',
- CONCAT(DATE_FORMAT(s.course_date, '%m/%d/%Y'), ' ', REPLACE(IF(t.coursetime REGEXP '^[0-9]{2}', LEFT(t.coursetime, 5), ''), '.', ':')) AS 'Start',
- CONCAT(DATE_FORMAT(s.course_date, '%m/%d/%Y'), ' ', REPLACE(IF(t.coursetime REGEXP '^[0-9]{2}', RIGHT(t.coursetime, 5), ''), '.', ':')) AS 'End',
- s.course_classification AS 'ID',
- t.clubname AS 'Location',
- 'admin@symmonsmadge.co.uk' AS 'Email',
- '25' AS 'Language',
- 'www.symmonsmadge.co.uk/booking_form.php' AS 'URL',
- '' AS 'Comment',
- t.standardfees AS 'Price',
- 'GBP' AS 'Currency',
- 'Symmons Madge Associates' AS 'Vendor',
- 'Public' AS 'Type',
- 'Public' AS 'Customer',
- REPLACE(REPLACE(title, CHAR(147), '\"'), CHAR(148), '\"') AS 'Title'
- FROM (catalog c INNER JOIN schedule s
- ON c.catalog_id=s.course_title_id) INNER JOIN trainingclubs t ON s.clubprefix=t.clubprefix
- ORDER BY course_date";
- //var_dump($sql);
- //fb($sql, '$sql');
- mysql_select_db($database, $bryanmadge);
- //var_dump($bryanmadge);
- $result = mysql_query($sql, $bryanmadge) or die(mysql_error());
- //exportMysqlToCsv($res);
- $filename = 'export.csv';
- //function exportMysqlToCsv($result,$filename = 'export.csv')
- //{
- $csv_terminated = "\r\n";
- $csv_separator = ",";
- $csv_enclosed = '"';
- $csv_escaped = "\\";
- // $sql_query = "select * from $table";
- // Gets the data from the database
- // $result = mysql_query($sql_query);
- $fields_cnt = mysql_num_fields($result);
- $schema_insert = '';
- for ($i = 0; $i < $fields_cnt; $i++)
- {
- $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
- stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
- $schema_insert .= $l;
- $schema_insert .= $csv_separator;
- } // end for
- $out = trim(substr($schema_insert, 0, -1));
- $out .= $csv_terminated;
- // Format the data
- while ($row = mysql_fetch_array($result))
- {
- $schema_insert = '';
- for ($j = 0; $j < $fields_cnt; $j++)
- {
- if ($row[$j] == '0' || $row[$j] != '')
- {
- if ($csv_enclosed == '')
- {
- $schema_insert .= $row[$j];
- } else
- {
- $schema_insert .= $csv_enclosed .
- str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
- }
- } else
- {
- $schema_insert .= '';
- }
- if ($j < $fields_cnt - 1)
- {
- $schema_insert .= $csv_separator;
- }
- } // end for
- $out .= $schema_insert;
- $out .= $csv_terminated;
- } // end while
- header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
- header("Content-Length: " . strlen($out));
- // Output to browser with appropriate mime type, you choose ;)
- //header("Content-type: text/x-csv");
- //header("Content-type: text/csv");
- //header("Content-type: application/csv");
- //header("Content-Disposition: attachment; filename=$filename");
- echo $out;
- exit;
- //}
- ?>