- Version 3.4.1
- Version 3.4.0
- Version 3.3.0
- Version 3.2.0
- Version 3.1.0
- Version 3.0.0
- Version 2.5.3
- Version 2.5.1
- Version 2.5.0
- Version 2.0.0
- Version 1.5.0
- Version 1.4.0
- Version 1.3.0
- Version 1.2.0
- Version 1.1.0
- Version 1.0.0
Change Log
Version 3.4.1 #
- Fixed: SQL Server syntax for fetch rows
Version 3.4.0 #
- Added: new line before keyword sql output mode
Version 3.3.0 #
- Added: Ability to return new query of anynomous alias function in from() method
Version 3.2.0 #
- Added: Ability to query from table alias
Version 3.1.0 #
- Fixed: Small bug in generating delete query
Version 3.0.0 #
- Add whereOpenBracket(), whereCloseBracket() methods
- Add option to build named and question mark parameter query and its parameter values to improve security
- Add schemas to Query to check select validity
- Add ability to call procedure with parameters
- Add procedure call
- Add Oracle syntax support
Version 2.5.3 #
- Fix the
toArray()
method - Fix issue with
where()
method
Version 2.5.1 #
- Fix Query's rebuildSubQueries() method and make its toArray() recursive.
Version 2.5.0 #
- Enhance the
selectRaw()
,whereRaw()
andorderByRaw()
Version 2.0.0 #
Query
: Fix the selectRaw renderingQuery
: Adding parameters towhereRaw()
,havingRaw()
,orderByRaw()
methodsSQL
: Add options to set quotes for identifiersSQL
: Make default not use quotes for identifiersSQLServer
: Generate correct query for limit and offsetQuery
: AddgroupByRaw()
methodQuery
: Addcreate()
static function to create query from arrayQuery
: AddingtoArray()
function to export query to array formatQuery
: Addfill()
method to quickly fill query with arrayQuery
: Fix the whereRaw binding params
Version 1.5.0 #
- Change README
Version 1.4.0 #
- Fix aggregate
Version 1.3.0 #
- Fix error of
where
condition when value is boolean type - Fix the cover identifier for [table.column] format
Version 1.2.0 #
- Change function "as" to "alias",
- Change function "switch" to "branch"
- Render query correctly for update and insert when encounter boolean value
- Fix the PostgresQL interpreter
Version 1.1.0 #
- When value of where condition is null, change from "=" to is null
Version 1.0.0 #
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.