function export_csv_data($export)
{
global $ib_error, $warning, $dbhandle;
$fields_terminator = replace_escape_sequences($export['csv']['fterm']);
$enclose_type = $export['csv']['ftencl'];
$fields_enclosed = replace_escape_sequences($export['csv']['fencl']);
$escape_character = replace_escape_sequences($export['csv']['fesc']);
$line_terminator = replace_escape_sequences($export['csv']['lterm']);
$replace_null = $export['general']['replnull'];
if ($export['csv']['fnamesf']) {
$headline = '';
foreach ($export['query']['columns'] as $column) {
$headline .= csv_value($column, FALSE, $enclose_type, $fields_enclosed, $escape_character, $replace_null, $fields_terminator);
}
echo csv_line($headline, $fields_terminator, $line_terminator);
}
$num = fbird_num_fields($export['query']['result']);
// build one line for the csv file from every result object
while ($row = @fbird_fetch_row($export['query']['result'], IBASE_TEXT)) {
$line = '';
for ($idx = 0; $idx < $num; $idx++) {
$value = prepare_export_value($row[$idx], $export['query']['col_types'][$idx]);
$line .= csv_value($value, $export['query']['num_fields'][$idx], $enclose_type, $fields_enclosed, $escape_character, $replace_null, $fields_terminator);
}
// send line to client
echo csv_line($line, $fields_terminator, $line_terminator);
}
echo $line_terminator;
}
function event_load_csv($list, $fileName = "events.csv")
{
$csv = '';
$csv .= csv_line(array("web_id", "requested_at", "duration", "event",
"page", "value", "remote_host", "referer",
"user_agent"));
foreach($list as $event)
{
$browser = new BrowserInfo($event->getUserAgent());
$fields = array($event->getWebId(),
date("m/d/y H:i", $event->getRequestedAt()),
$event->getDuration(),
$event->getEvent(),
$event->getPage(),
$event->getValue(),
$event->getRemoteHost(),
$event->getReferer(),
$browser->getName() . " " . $browser->getVersion()
);
$csv .= csv_line($fields);
}
header('Content-type: text/csv');
header("Content-Disposition: attachment; filename=\"" . $fileName . "\";");
echo $csv;
}
$filePtr = file($argv[1]);
$GLOBALS["isVerbose"] = $argv[2] == "--verbose" ? true : false;
if (!$filePtr) {
die_usage("Error : file not found.");
}
$csv = array_map('str_getcsv', $filePtr);
$total = 0;
$success = 0;
foreach ($csv as $key => $row) {
$address = trim($row[0]);
$address = str_replace(';', ' ', $address);
$address = preg_replace('!\\s+!', ' ', $address);
verbose("Looking for : {$address}");
$geo = file_get_contents('http://maps.googleapis.com/maps/api/geocode/json?address=' . urlencode($address) . '&sensor=false');
$geo = json_decode($geo, true);
if ($geo['status'] = 'OK') {
$success++;
verbose("Found !");
$latitude = $geo['results'][0]['geometry']['location']['lat'];
$longitude = $geo['results'][0]['geometry']['location']['lng'];
verbose("Longitude : {$longitude}");
verbose("Latitude : {$latitude}");
csv_line("{$latitude};{$longitude}");
} else {
verbose("Not found !");
csv_line(";");
}
$total++;
sleep(1);
}
verbose("Result : {$success} / {$total} founded.");
<?php
echo utf8_bom();
$header = array();
foreach ($all_rows[0] as $cells) {
$header[] = $cells[0];
}
echo csv_line($header);
foreach ($all_rows as $row) {
$line = array();
foreach ($row as $cells) {
$line[] = $cells[1];
}
echo csv_line($line);
}
