SQL Report

A report can be generated just from supplying the database connection details and an sql statement. The report column labels are derived from the column names, so if a column is for example customer_address, then the label will automatically be set to "Customer Address". Use an SQL alias to specify a better label. Also use an alias for SQL expressions like COUNT(*) or SUM(x) to get a sensible column label.

Note that you cannot yet use the SELECT * notation you have to specify the individual columns.




<?php
    \Reportico\Engine\Builder::build()
        ...
        ...
        ->datasource()->database("mysql:host=localhost; dbname=<DATABASENAME>")->user("<DATABASE USER>")->password("<DATABASE PASSWORD>")
        ->sql       ("
            SELECT column1, column2, column3 AS some_alias, expression * 2 as some_label
            FROM table
            ORDER BY column1
            ")
        ...
        ...
        ->execute();
    ?>
     1




Run Demo


<?php

    require_once(__DIR__ .'/../vendor/autoload.php');
      

    \Reportico\Engine\Builder::build()
          ->properties([ "bootstrap_preloaded" => true])
          ->datasource()->database("mysql:host=localhost; dbname=DATABASE NAME")->user("USER")->password("PASSWORD")
          ->title     ("Employee List")
          ->description     ("Produces a list of our employees")
          ->sql       ("
                SELECT EmployeeID employee_id, LastName last_name, FirstName first_name, BirthDate birth_date, Country
                FROM northwind_employees
                ORDER BY Country, LastName
                ")
          ->execute();
?>