function make_wind_csv($fobj, $start_ts, $end_ts) { $wharfColumnToHeaderMap = array('dateUTC' => 'Time (UTC)', 'windSpeed' => 'Windspeed (MPH)', 'windDir' => 'Wind Heading (Deg)', 'turbineAmps' => 'Wind Turbine Current (Amps)', 'ADC2' => 'Divert-load (Amps)', '24*turbineAmps' => 'Wind Turbine Power (Watts)', '.8*POWER(ADC2,2)' => 'Divert-load power (Watts)', '24*turbineAmps/6' => 'Wind Turbine Power (Watt-hours) rectangular estimate', '.8*POWER(ADC2,2)/6' => 'Divert-load Power (Watt-hours) rectangular estimate'); fputcsv($fobj, array_values($wharfColumnToHeaderMap)); if ($start_ts != NULL) { if ($end_ts != NULL) { $query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime >= " . $start_ts . " and utime <= " . $end_ts . " ORDER BY utime asc"; } else { $query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime >= " . $start_ts . " ORDER BY utime asc"; } } elseif ($end_ts != NULL) { $query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime <= " . $end_ts . " ORDER BY utime asc"; } else { $query = "SELECT " . join(', ', array_keys($wharfColumnToHeaderMap)) . " FROM wharf_data WHERE utime >= " . (time() - 24 * 3600 * 14) . " ORDER BY utime asc"; } query2csv($fobj, $query); }
// $highlightSQL =& Text_Highlighter::factory('SQL',array('numbers'=>true)); // echo "Executed QUERY : "; // echo $highlightSQL->highlight($sql_query); highlight_string("Executed QUERY : " . $sql_query); echo "<BR><BR>"; $results = execute_query($sql_query); // print_r($results); // echo "<BR><BR>"; if ($results == "1") { echo "<table><tr><td>Query Successful!</td></tr></table>"; } else { query2table($results); $result2 = execute_query($sql_query); query2xls($result2, 'query.xls'); $result3 = execute_query($sql_query); query2csv($result3, 'query.csv'); ?> <P><A HREF="query.xls">Αποτελέσματα σε Excel</A></P> <P><A HREF="query.csv">Αποτελέσματα σε CSV</A></P> <?php } mysql_close($dbconnection); } else { ?> <FORM METHOD=POST action="query.php"> <input type="text" id="query" style="font-family: courier new" size="120" name="query" value="SELECT * FROM "/> <input type="submit" style="font-family: courier new"/> <input type="button" style="font-family: courier new" value="Καθαρισμός" onclick="document.all.query.value='';"/> </form>