sql server display data on google charts

I'm new to koolreport and I want to try google charts. I set up my sql server connection, but I don't know how to get data from the sql server and use it. I want to make a simple table with the Products.ProductName and Products.UnitPrice components using the Northwind database. In the examples section, data is given directly, but I could not find how to extract data from the sql server.

My codes:

index.php

<?php
require_once "../../../../../autoload.php";
require_once "Report.php";

$report = new Report;
$report->run()->render();

Report.view.php

<?php
    use \koolreport\widgets\google\ColumnChart;
    use \koolreport\widgets\google\BarChart;
    use \koolreport\widgets\google\Gauge;
    use \koolreport\widgets\google\Timeline;
    $category_amount = array(
        array("category"=>"Books","sale"=>32000,"cost"=>20000,"profit"=>12000),
        array("category"=>"Accessories","sale"=>43000,"cost"=>36000,"profit"=>7000),
        array("category"=>"Phones","sale"=>54000,"cost"=>39000,"profit"=>15000),
        array("category"=>"Movies","sale"=>23000,"cost"=>18000,"profit"=>5000),
        array("category"=>"Others","sale"=>12000,"cost"=>6000,"profit"=>6000),
    );
?>
<html>
    <head>
        <title>Test multiple google charts</title>
    </head>
    <body>
        <h1>Test multiple google charts</h1>
        <p class="lead">
        There was issue that multiple google charts which are different in packages and stability
        loaded in a sample.
        Only the previous charts works but the rest.
        </p>

        <h2>BarChart</h2>
        <?php
        ColumnChart::create(array(
            "title"=>"Sale Report",
            "dataSource"=>$category_amount,
            "columns"=>array(
                "category",
                "sale"=>array("label"=>"Sale","type"=>"number","prefix"=>"$"),
                "cost"=>array("label"=>"Cost","type"=>"number","prefix"=>"$"),
                "profit"=>array("label"=>"Profit","type"=>"number","prefix"=>"$"),
            )
        ));
        ?>

        <h2>BarChart</h2>
        <?php
        BarChart::create(array(
            "title"=>"Sale Report",
            "dataSource"=>$category_amount,
            "columns"=>array(
                "category",
                "sale"=>array("label"=>"Sale","type"=>"number","prefix"=>"$"),
                "cost"=>array("label"=>"Cost","type"=>"number","prefix"=>"$"),
                "profit"=>array("label"=>"Profit","type"=>"number","prefix"=>"$"),
            )
        ));
        ?>


        <h2>Now Gauge Chart</h2>

        


        

    </body>
</html>

Report.php


<?php

class Report extends \koolreport\KoolReport
{
    public function settings()
    {
        $pathh = '\koolreport\datasources\SQLSRVDataSource';
        return array(
            "dataSources"=>array(
                "sqlserver"=>array(
                    "connectionString" => "sqlsrv:Server=tcp:127.0.0.1;Database=NORTHWND",
                    "username" => "sa",
                    "password" => "---"
                    
                   
                ),
            )
        );


        





    }
    

}

KoolReport's Forum

Sql server display data on google charts #2012

Build Your Excellent Data Report