nilportugues/php-sql-query-builder issues and pull requests

#133 - fix: Translate only type-safe null to sql null

Pull Request - State: open - Opened by sevjan 4 months ago

#132 - Disable table name prepend in group by

Pull Request - State: open - Opened by SatanaKonst 7 months ago

#131 - Add diagram.svg to readme

Pull Request - State: closed - Opened by nilportugues 7 months ago

#130 - Feat/vendor

Pull Request - State: closed - Opened by willemdaems 9 months ago

#129 - PHP 8 deprecated warning on Syntax>Column

Issue - State: open - Opened by vanbe over 2 years ago - 4 comments

#128 - How to get SQL with values embedded instead of paramaterialised SQL?

Issue - State: open - Opened by srth12 over 2 years ago - 3 comments

#127 - Styling and chapter typo

Pull Request - State: closed - Opened by sevjan almost 3 years ago

#126 - Count function doesn't work

Issue - State: open - Opened by milito-78 about 3 years ago

#125 - Add REPLACE statement

Issue - State: open - Opened by SirobbsCrafter about 3 years ago

#124 - Values in WHERE conditions are returned as 'NULL' when they shouldn't

Issue - State: open - Opened by adrienlabelle almost 4 years ago - 1 comment

#123 - sprintf()-like syntax support

Issue - State: open - Opened by maartenheideman about 4 years ago

#122 - How use left join in foreach?

Issue - State: open - Opened by misterkonst about 4 years ago

#121 - hardening columnAlias remove

Pull Request - State: open - Opened by roelfsche over 4 years ago

#120 - hardening columnAlias removal

Pull Request - State: closed - Opened by roelfsche over 4 years ago - 1 comment

#119 - Do not insert null string in sql query if string is '0'

Pull Request - State: closed - Opened by makeey almost 5 years ago

#118 - Select from another select

Issue - State: open - Opened by JhefersonBR about 5 years ago - 1 comment

#117 - Support for Nested Joins?

Issue - State: open - Opened by courtney-miles about 5 years ago

#116 - Example didn't work

Issue - State: open - Opened by Kal-Aster about 5 years ago - 1 comment

#115 - preparing php7 upgrade

Pull Request - State: open - Opened by nilportugues about 5 years ago

#114 - Order by RAND

Issue - State: open - Opened by usernotnull about 5 years ago

#113 - Do not filter values in AbstractCreationalQuery

Pull Request - State: closed - Opened by makeey over 5 years ago - 1 comment

#112 - add setWhere method

Pull Request - State: closed - Opened by hunteryun over 5 years ago

#111 - Can you add setWhere function ?

Issue - State: open - Opened by hunteryun almost 6 years ago

#110 - Implement table aliasing and extent the builder to have multiple…

Pull Request - State: open - Opened by MDaskalovAtBE about 6 years ago

#109 - New placeholder management

Pull Request - State: closed - Opened by nitricware about 6 years ago - 1 comment

#108 - Purpose of injectBuilder method

Issue - State: open - Opened by ghost about 6 years ago

#107 - Wrong LIMIT syntax in postgres

Issue - State: closed - Opened by medbrat13 about 6 years ago

#106 - Comparison against empty string converted to 'NULL' string

Issue - State: open - Opened by russell-pa about 6 years ago - 1 comment

#105 - Limit syntax fail

Issue - State: open - Opened by konorlevich over 6 years ago - 1 comment

#104 - Do not reset placeholders in set writers

Pull Request - State: closed - Opened by Sevavietl over 6 years ago

#103 - Correct PHPDoc return types for insert/update factories

Pull Request - State: closed - Opened by guym4c over 6 years ago

#102 - Wrong type hint

Issue - State: open - Opened by demyan112rv almost 7 years ago - 2 comments

#101 - Placeholders question

Issue - State: open - Opened by Basili0 almost 7 years ago - 2 comments

#100 - Allow custom self column in join

Pull Request - State: closed - Opened by nathandentzau almost 7 years ago

#99 - Values in writed SQL

Issue - State: closed - Opened by yakovkravtsov about 7 years ago - 1 comment

#98 - Nested subWhere's in complex where statements?

Issue - State: open - Opened by riseoflex88 about 7 years ago - 2 comments

#97 - placeholders question

Issue - State: open - Opened by sinticbolivia over 7 years ago - 3 comments

#96 - Fix the where clause issue to solve issue #73

Pull Request - State: closed - Opened by mmuhasan over 7 years ago

#95 - Writer for UNION queries should not reset the placeholder counter

Issue - State: closed - Opened by chrisberl over 7 years ago - 1 comment

#94 - Using it without Composer

Issue - State: closed - Opened by belaarany over 7 years ago - 4 comments

#93 - Database + table name

Issue - State: open - Opened by andybee over 7 years ago - 4 comments

#92 - PHP 7.0 - Update Query - setValues() - empty string value filtered out

Issue - State: open - Opened by evanirla over 7 years ago - 3 comments

#91 - How to search for gt or lt timestamp field?

Issue - State: closed - Opened by shehabic-work over 7 years ago

#90 - Help other guys, about left join with orderBy bug

Issue - State: open - Opened by aviggngyv almost 8 years ago - 1 comment

#89 - Exception when trying to build a simple query

Issue - State: open - Opened by diogocavilha almost 8 years ago - 4 comments

#88 - Modified original library to meet requirements for Perkbox project

Pull Request - State: closed - Opened by snapfreeze almost 8 years ago

#87 - Information Request - Using MySqlBuilder with mysqli

Issue - State: open - Opened by evanirla almost 8 years ago - 2 comments

#86 - Accept Column object through setColumns.

Pull Request - State: closed - Opened by prasad83 about 8 years ago

#85 - Across table conditions

Issue - State: open - Opened by prasad83 about 8 years ago - 3 comments

#84 - Allows writing "0" to row

Pull Request - State: closed - Opened by marcusirgens about 8 years ago

#83 - Export values

Issue - State: open - Opened by Dokans about 8 years ago - 2 comments

#82 - Update doesn't work for '0'-values

Issue - State: open - Opened by tsillus over 8 years ago - 3 comments

#81 - Nested queries

Issue - State: closed - Opened by assada over 8 years ago - 1 comment

#80 - use php-sql-query-builder without composer

Issue - State: open - Opened by asadghazanfary over 8 years ago - 1 comment

#79 - How to use the built-in MySQL functions such as NOW?

Issue - State: open - Opened by kyzima-spb over 8 years ago - 1 comment

#78 - MS SQL Server Syntax

Issue - State: open - Opened by fabioars over 8 years ago - 2 comments

#77 - Ability of dynamic setColumns and setValues parameters injection by object types

Issue - State: open - Opened by ovflowd about 9 years ago

#76 - Aliases for table names

Issue - State: open - Opened by parpalak about 9 years ago

#75 - select orderby logic changes

Pull Request - State: closed - Opened by qlarin about 9 years ago

#74 - orderBy array

Issue - State: closed - Opened by qlarin over 9 years ago - 2 comments

#73 - tutorial doesn't work

Issue - State: open - Opened by collmomo over 9 years ago - 15 comments
Labels: Bug, Documentation

#72 - Missing AND NOT

Issue - State: closed - Opened by nilportugues over 9 years ago - 2 comments
Labels: Bug

#71 - Missing IS NOT BETWEEN

Issue - State: closed - Opened by nilportugues over 9 years ago - 1 comment
Labels: Bug

#70 - Where should i config the database parameters like dbhost, dbname, dbuser, dbpass?

Issue - State: closed - Opened by ghost over 9 years ago - 1 comment
Labels: Documentation

#69 - Unable to use FROM_UNIXTIME function

Issue - State: closed - Opened by selabie68 over 9 years ago - 4 comments
Labels: Bug

#68 - added where::asLiteral

Pull Request - State: closed - Opened by malteriesch over 9 years ago - 2 comments

#67 - Making writeSelectLimit friendly to PDO drivers.

Pull Request - State: open - Opened by prasad83 over 9 years ago - 1 comment
Labels: Improvement

#66 - Issue with where() causing exception

Issue - State: closed - Opened by svgaman almost 10 years ago - 4 comments
Labels: Improvement

#65 - CREATE TABLE?

Issue - State: open - Opened by IngwiePhoenix about 10 years ago - 2 comments

#64 - Get part of a generated query

Issue - State: open - Opened by alexschwarz89 about 10 years ago - 2 comments
Labels: Improvement

#63 - MYSQLi Prepared Statements Support

Issue - State: closed - Opened by alexschwarz89 about 10 years ago - 1 comment

#62 - Write and WriteFormatted should be merged into the same method.

Issue - State: open - Opened by nilportugues over 10 years ago
Labels: Improvement

#61 - Change method names

Issue - State: open - Opened by nilportugues over 10 years ago
Labels: Improvement

#60 - Table aliasing for Select and Joins

Issue - State: open - Opened by nilportugues over 10 years ago
Labels: Improvement, Missing features

#59 - Scrutinizer Auto-Fixes

Pull Request - State: closed - Opened by scrutinizer-auto-fixer over 10 years ago

#58 - Scrutinizer Auto-Fixes

Pull Request - State: closed - Opened by scrutinizer-auto-fixer over 10 years ago

#57 - Scrutinizer Auto-Fixes

Pull Request - State: closed - Opened by scrutinizer-auto-fixer over 10 years ago

#56 - Scrutinizer Auto-Fixes

Pull Request - State: closed - Opened by scrutinizer-auto-fixer over 10 years ago

#55 - Scrutinizer Auto-Fixes

Pull Request - State: closed - Opened by scrutinizer-auto-fixer over 10 years ago