amnl/gc-datatable

PHP library to generate JSON data for Google Chart Tools.

v0.2.0 2013-06-07 19:12 UTC

Requires

• php: >=5.3.0

Requires (Dev)

• phpunit/phpunit: 3.7.*

MIT

• Arno Moonen

• json
• google
• charts
• chart tools

README

This library is meant to simplify the dynamic generation of a JSON-representation of a DataTable when using PHP. DataTables are used by the Google Visualization API / Chart Tools, see this reference on developers.google.com for more info.

Problems? Suggestions?

Create a new issue to tell me about your suggestions and/or problems. I'd love to hear your opinion!

Example

For the time being you can have a look at "Populating Data Using Server Side Code". The code below basically replaces getData.php and sampleData.json and allows you to dynamically change the output.

<?php

/*
 * A bunch of use-statements
 * (assuming you have some kind of autoloading mechanism)
 */
use AMNL\Google\Chart\Table;
use AMNL\Google\Chart\Column;
use AMNL\Google\Chart\Row;
use AMNL\Google\Chart\Type as T;

/* The actual code */
$pizzaTable = new Table(
    new Column(new T\String(), 'Topping'),
    new Column(new T\Number(), 'Slices')
);

$pizzaTable->addRow(new Row('Mushrooms', 3));
$pizzaTable->addRow(new Row('Onions', 1));
$pizzaTable->addRow(new Row('Olives', 1));
$pizzaTable->addRow(new Row('Zucchini', 1));
$pizzaTable->addRow(new Row('Pepperoni', 2));

/* JSON Output */
header('Content-Type: application/json');
echo $pizzaTable->toJson();