Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.
MIT License
Bot releases are hidden (Show)
Full Changelog: https://github.com/auraphp/Aura.SqlQuery/compare/2.7.1...3.0.0
Published by harikt over 1 year ago
Full Changelog: https://github.com/auraphp/Aura.SqlQuery/compare/2.8.0...2.8.1
Published by harikt over 2 years ago
Full Changelog: https://github.com/auraphp/Aura.SqlQuery/compare/2.7.1...2.8.0
Published by harikt over 2 years ago
Full Changelog: https://github.com/auraphp/Aura.SqlQuery/compare/2.7.1...3.0.0-alpha1
Published by pmjones about 8 years ago
Hygiene release: update README.
Published by pmjones about 8 years ago
Select::reset*()
methods. Fixes #84, #95, #94, #91.join*()
before from*()
. Joins-before-from are addedPublished by pmjones almost 9 years ago
@method getStatement()
to the QueryInterface for IDE auto-completion.Published by pmjones over 9 years ago
instanceof SubselectInterface
instead of self
; the Select class nowPublished by pmjones over 9 years ago
This release modifies the testing structure and updates other support files.
Published by pmjones over 9 years ago
This release fixes Insert::addRows() so that adding only one row generates the correct SQL statement.
Published by pmjones over 9 years ago
This release incorporates two feature additions and one fix.
addRow()
and addRows()
methods.ON DUPLICATE KEY UPDATE
functionality with the new onDuplicateKeyUpdate*()
methods.setPaging()
now re-calculates the LIMIT and OFFSET values.Published by pmjones over 9 years ago
This release has several new features.
join()
methods now have an extra $bind
param that allows you to bind values to ?-placeholders in the condition, just as with where()
and having()
.getStatement()
has been added to all queries, to allow you to get the text of the statement being built. Among other things, this is to avoid exception-related blowups related to PHP's string casting.where()
, having()
, etc, the Select class now examind the value to see if it is a query object. If so, it converts the object to a string and replaces the ?-placeholder inline with the string instead of attempting to bind it proper. It also binds the existing sequential placholder values into the current Select in a non-conflicting fashion. (Previously, no binding from the sub-select took place at all.)fromSubSelect()
and joinSubSelect()
, the Select class now binds the sub-select object sequential values to the current Select in a non-conflicting fashion. (Previously, no binding from the sub-select took place at all.)The change log follows:
Published by pmjones over 9 years ago
To avoid mixing numbered and names placeholders, we now convert numbered ? placeholders in where() and having() to :# named placeholders. This is because PDO is really touchy about sequence numbers on ? placeholders. If we have bound values [:foo, :bar, ?, :baz], the ? placeholder is not number 1, it is number 3. As it is nigh impossible to keep track of the numbering when done out-of-order, we now do a braindead check on the where/having condition string to see if it has ? placholders, and replace them with named :# placeholders, where # is the current count of the $bind_values array.
Published by pmjones about 10 years ago
Published by pmjones over 10 years ago
Initial 2.0 stable release.
colname => alias
pairs mixed in with sequential colname values.Published by pmjones almost 11 years ago
Initial 2.0 beta release.