php-sql-query-builder

php-sql-query-builder copied to clipboard

tutorial doesn't work

15

PHP 7.0 ```$query = $builder->select() ->setTable('user') ->setColumns(['userId' => 'user_id', 'username' => 'name', 'email' => 'email']); echo $builder->write($query); ` ``` [Symfony\Component\Debug\Exception\FatalThrowableError] Type error: Argument 1 passed to NilPortugues\Sql\QueryBuilder\Builder\GenericBuilder::write() must implement interface...

collmomo

MS SQL Server Syntax

2

There is some diferences between MS SQL Server syntax and others DBMS. I'm using GenericBuilder How can I adapt for MS SQL Server? Example: MySQL: `SELECT * FROM table_name LIMIT...

fabioars

use php-sql-query-builder without composer

1

hello every one how can i use php-sql-query-builder without composer? thankyou

asadghazanfary

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

1

Example: ```php $query = $builder ->insert('post', [ 'title' => 'Пост №2', 'description' => '', 'content' => 'Содержание второй записи', 'created' => 'NOW()', 'updated' => 'NOW()', ]) ; ``` PDO doesn't...

kyzima-spb

Hello! I was wondering the following feature in this library, see this scenario: Recently with the intensification of `JSON` communication messages, and more frameworks appearing in the internet like Angular,...

ovflowd

Hi, Nil! Your project is nice. However, I think there is a missing feature: aliases for table names. Althought there is the Table::setAlias() method, it seems to be unused in...

parpalak

Making writeSelectLimit friendly to PDO drivers.

1

Executing prepared statement with values fails if limit values are not binded as integer. To overcome this making the limit friendly without adding placeholder can be very useful.

prasad83

CREATE TABLE?

2

It seems that this library has all, BUT the actual creation process. Could it be added? :) ``` php $b->createTable("foo",[ "id", "int(11)", "NOT_NULL", ["AUTO_INCREMENT"] ]); ``` Just a thought. Kind...

IngwiePhoenix

Get part of a generated query

2

Is there any possibility to generate a part of a query manually? I need this ALIASED Select for example ``` sql MATCH(a,b) AGAINST ('term') AS relevance ``` So I already...

alexschwarz89

Dependency Injection / Code Decoupling

10

Right now the usage of static classes as factories makes it really had to extend the query builder on a per-project basis. A more decoupled approach that would allow for...

shadowhand