php-sql-query-builder

php-sql-query-builder copied to clipboard

Hello, I been seen this library and I have a doubt regarding the injectBuilder function Since I saw it implemented in the AbstractBaseQuery class Could anyone explain me this to...

ghost

Wrong type hint

2

https://github.com/nilportugues/php-sql-query-builder/blob/277e87a8bca2ab833b18baad751eba64d0ddddd2/src/Syntax/Where.php#L293 In this and other php docs wrong type hint for `$value`. Analysis of this code using phpstan is failed. Please fix it. Thanks!

demyan112rv

Database + table name

4

I was expecting to be able to build a query along the lines of: `$queryBuilder->select()->setTable('users.user');` Where the table `user` exists within a database `users`. Am I missing an undocumented method...

andybee

Information Request - Using MySqlBuilder with mysqli

2

Hi there, When building a select() query with a where() and an equals() call, when I write the query it looks like "select * from `user` where `user`.`id` = :var1"....

evanirla

Exception when trying to build a simple query

4

Hi, I'm following the docs in order to test the package and I've got that exception: ``` TypeError: Argument 1 passed to NilPortugues\Sql\QueryBuilder\Builder\GenericBuilder::write() must implement interface NilPortugues\Sql\QueryBuilder\Manipulation\QueryInterface, instance of NilPortugues\Sql\QueryBuilder\Manipulation\ColumnQuery...

diogocavilha

Across table conditions

3

I would like to know how to build the query like below that has conditions across tables. ``` SELECT TableA.ColA, TableB.ColB FROM TableA INNER JOIN TableB ON TableA.id=TableB.id WHERE (TableA.ColX...

prasad83

Update doesn't work for '0'-values

3

``` $query = $this->builder->update(Mwst::TABLE, [ 'standard' => '0'] ); $query->where() ->notEquals('id', $vat->get('id') ) ->eq( 'sid', $this->login->getSID() ) ->eq( 'bid', $this->login->getBID() ); // later.. $sql = $this->builder->write( $query ); $data =...

tsillus

Export values

2

Hi, sorry it's not a real issue but it's somehow possible to export solo raw SQL for update or insert?

Dokans

Help other guys, about left join with orderBy bug

1

I love this library, because it Works without establishing a connection to the database. but realy it have many bug wait to fix, I just want help other guys, maybe...

aviggngyv

Placeholders question

2

When using the MySqlBuilder the placeholders are Oracle-style (:v1) instead of MySql-style (?), which produces an error e.g. "Input array has 1 params, does not match query". How to change...

Basili0