Introduction #

Although using PDODataSource can connect to SQL Server. However if for some reasons, you do not have the PDO Driver, you may use the old traditional connection to MySQL using SQLSRVDataSource.

Settings #

classstringMust set to '\koolreport\datasources\SQLSRVDataSource'
hoststringHost of database
usernamestringYour login username
passwordstringYour password
dbnamestringDatabase name

Methods #

query(string $str_query)SQLSRVDataSourceThis method is used in report's setup() function. It will help to setup query string which will be executed when report is run.
params(array $params)SQLSRVDataSourceThis method is used to set list of parameters for query statement

Example #

class MyReport extends \koolreport\KoolReport
    public function settings()
        return array(
                    'host' => 'localhost',
                    'username' => 'root',
                    'password' => '',
                    'dbname' => 'automaker',
                    'charset' => 'utf8',  
                    'class' => "\koolreport\datasources\SQLSRVDataSource"  
    public function setup()
        ->query("SELECT * FROM tblPurchase where status=:status")

Get started with KoolReport

KoolReport will help you to construct good php data report by gathering your data from multiple sources, transforming them into valuable insights, and finally visualizing them in stunning charts and graphs.