Here’s a complete example of how to use the PHP SDK for QuickBase to get data from a QuickBase and use it side-by-side with the Google Visualization API to generate annotated time line. The example below is one I used to compare the total number of trials we get on our website with the number of inbound support cases we get.
<p> $trials = array();</p>
<p> // build a 2d array for the Google chart<br ?--> foreach ($result->table->records->record as $record)
$timestamp = round(((double)$record->f) / 1000, 0);
$date_string = date(“F j, Y”, $timestamp);
$case_type = (string) $record->f;
$trials[$date_string][$case_type] += 1;
$trials[$date_string][$case_type] = 1;