- Fixes more type hints in some statement classes
- Where clause hints were not expansive enough
- Fixes type hints in some statement classes
- Some parameters only allowed null and needed string|null
- Reverts change to
DeleteStatementconstructor$tableargument made nullable again- Only calling
setTable()now if$tableexists
- Updated
READMEand docs contents- Cleaned up the php examples and content
- Updated internal tools php-cs-fixer and phpstan
- Cleared all phpstan errors up to level 8 (max)
- Changed (corrected) some return types for functions
- These were all from phpstan errors
- Increased minor version number because of compatibility
- Fixes bug with having
- Removed backticks from
having()method - These were not needed and they caused downstream issues
- Removed backticks from
- Updated
GroupClauseclass with:- For backwards compatibility,
groupBy()accepts botharrayandstring
- For backwards compatibility,
- Updated
GroupClauseclass with:arraytype is required ingroupBy()function- Values can still be appended with multiple calls
- Added
InsertMultiStatementclass with:- Support to insert multiple rows at once
- Support for
ON DUPLICATE KEY UPDATE
- Refactored code formatting to PSR-2/Symfony
- Set up PHP CS Fixer and config file with rules
- Removed unnecessary PHP doc tags and comments
- Changed namespaces and updated all documentation
- Moved code out of
PDOsub-folder and intosrc
- Updated
Databaseclass with:- Allow user provided PDO options to overwrite default values
- Updated
StatementContainerclass with:- Added check to stop executing when field value is not expected
- Updated
LimitClauseclass with:- Fixed
LIMIT/OFFSETformat - Changed default offset value
- Added check whether offset is null (before checking if is integer)
- Fixed
- Updated
StatementContainerclass with:- Added transactional
commit()method - Added transactional
rollBack()method - Added transactional
beginTransaction()method
- Added transactional
- Updated
LimitClauseclass with:- Added validation to check if parameters are casted to expected integers
- Updated
OffsetClauseclass with:- Added validation to check if parameter is casted to expected integer
- Added ability to insert associative arrays (#35)
- Updated
Databaseclass with:- Renamed
$columnsargument ininsert()method
- Renamed
- Updated
StatementContainerclass with:- Added
isAssociative()method - Fixed
getPlaceholders()method
- Added
Proposed by Raistlfiren. Thanks!
- Updated
SelectStatementclass with:- Fixed
getColumns()method
- Fixed
- Updated
WhereClauseclass with:- Reverted
__toString()method
- Reverted
- Updated
HavingClauseclass with:- Reverted
__toString()method
- Reverted
- Updated
WhereClauseclass with:- Fixed some weird bug in
__toString()method
- Fixed some weird bug in
- Updated
HavingClauseclass with:- Fixed the same weird bug in
__toString()method
- Fixed the same weird bug in
Mentioned by EliaRigo. Thanks!
- Updated
LimitClauseclass with:- Fixed
limit()method
- Fixed
- Updated documentation
- Added protected override allowed
- Better parameter naming
- Revised documentation (WIP)
- Updated
InsertStatementclass with:- Fixed
execute()method
- Fixed
- Updated
InsertStatementclass with:- Added
$insertIdargument inexecute()method
- Added
- Updated
Databaseclass with:- Fixed
$optionsargument in__construct()method
- Fixed
- Updated
SelectStatementclass with:- Fixed all aggregates
- Added
whereMany()method - Updated
limit()method
- Updated
Databaseclass with:- Minor change
__construct()method - Minor change
insert()method - Minor change
update()method
- Minor change
- Updated
LimitClauseclass with:- Minor change
__toString()method
- Minor change
- Updated
OffsetClauseclass with:- Minor change
__toString()method
- Minor change
- Updated
StatementContainerclass with:- Minor fix
setPlaceholders()method
- Minor fix
- PSR-2 coding style guide adopted
- Updated
InsertStatementclass with:- Added
columns()method
- Added
- Updated
UpdateStatementclass with:- Added
set()method
- Added
- Updated
StatementContainerclass with:- Added
$tableargument indelete()method
- Added
- Updated
WhereClauseclass with:- Fixed
orWhereLike()method
- Fixed
- Updated
SelectStatementclass with:- Minor fix
select()method (working fix)
- Minor fix
- Updated
SelectStatementclass with:- Minor fix
select()method
- Minor fix
- Removed old changelog notes
- Revised release version